I'm new to the forum & not too advanced when it come to Crystal. I'm using Crystal 9 & iMIS 10.6...

 

I have a report that pulls members who have an "active" status & "unpaid dues for Chapter & National" (two seperate dues items).  The report returns results for both dues items (2 line items) for all but 3 states - theses 3 states only return 1 line item but it does add in to the summary the cost of the missing dues product.

 

When I check the records the missing dues item is on the record and coded correctly.

 

Can someone steer me in the right direction to solving this?

 

Btw: I didn't see a way to add an attachment.

 

Thanks,

 

DJandlo

In checking the linking below is what I found...  Should I try changing some of the join types myself?  Also, I added the select statement below.

Thanks!

Tables:
Name
Subscriptions
Activity
Product_Type
Get_Descriptions
Product_Sub
Trans (Transaction)

Linking:                                                 Join Type: Inner        Link Type: =

Name.ID --> Subscriptions.ID          

Subscription.Prod_Type --> Product_Type.Prod_Type

Product_Type.Descrip --> Get_Descriptions.Descrip

Subscriptions.Prod_Code --> Activity.Prod_Code

Subscriptions.ID --> Activity.ID (Removed this link)

Subscription.Prod_Code --> Product_Sub.Prod_Code

Product_Sub.Prod_Cod e --> Trans.Prod_Code

{Name.MEMBER_TYPE} in ["GEN", "AC", "AF", "CO", "FE", "RES"] and
{Name.PAID_THRU}= Date(2010,12,31) and
({Subscriptions.PRODUCT_CODE}in['GEN2011', 'AF2011', 'CO2011', 'FE2011', 'RES2011'] OR
{Subscriptions.PRODUCT_CODE} like "CHAPT*") and
{Name.STATUS} = "A"

 

 

{Subscriptions.PRODUCT_CODE} like "CHAPT*")

 

If I'm correct then it should be returning any product that has a chapter (the product code is CHAPT/<STATE>).

 

The second part is being shown for all but 3 states.

 

({Subscriptions.PRODUCT_CODE}in['GEN2011', 'AF2011', 'CO2011', 'FE2011', 'RES2011'] OR
{Subscriptions.PRODUCT_CODE} like "CHAPT*") and

Truly a head scratcher...