Crystal 9.0
I have a report that calculates the count and total balance due for items based on two different codes – A and B. There is a sub-report as well which lists the details for each of the two codes. My issue is that when I run the report, the sub-report is totaling the count and balance correctly to match the figures in the main report, but the details in the sub-report are missing data. The balance due on each detail item can be either $197.50 or $98.75. Any record where the balance due is $197.50 is printing, but records where the balance due is $98.75 is missing.
There is no conditional suppression anywhere that I can find in either the main or sub-report, and the only criteria for balance due in both is that the balance must be greater than $0.00.
I am passing parameters from the main report to the sub-report but I don't think there's any issue there, because if I run the SQL Query from both the main report and the sub-report in SSMS all of the records are returned properly in both reports. The data is there – it’s just not printing the details in the sub-report properly and I can’t figure out why.
Is there a way I can search for conditional formatting in areas I may have missed? Are there other things I can check?
Thanks.
I have a report that calculates the count and total balance due for items based on two different codes – A and B. There is a sub-report as well which lists the details for each of the two codes. My issue is that when I run the report, the sub-report is totaling the count and balance correctly to match the figures in the main report, but the details in the sub-report are missing data. The balance due on each detail item can be either $197.50 or $98.75. Any record where the balance due is $197.50 is printing, but records where the balance due is $98.75 is missing.
There is no conditional suppression anywhere that I can find in either the main or sub-report, and the only criteria for balance due in both is that the balance must be greater than $0.00.
I am passing parameters from the main report to the sub-report but I don't think there's any issue there, because if I run the SQL Query from both the main report and the sub-report in SSMS all of the records are returned properly in both reports. The data is there – it’s just not printing the details in the sub-report properly and I can’t figure out why.
Is there a way I can search for conditional formatting in areas I may have missed? Are there other things I can check?
Thanks.