rowfei
asked on
Crystal Reports - Change sub-report blank value
Hi,
I have several sub-reports that group by the one category. In the main report links to two different sub-reports, which displays "Item 1" & "Item 2" for each category. Since Item 1 doesn't have record under category A, but item 2 does. That's why the reports shows below:
Category Item 1 Item 1 % Item 2 Item 2 %
A / 12/15 82%
B 20/25 85% 15/18 90%
C / 25/30 88%
Total: 20/25 85% 52/53 89%
How can I change those no record item 1 under category to test "N/A".. Below is the report that I would it to be displayed:
Category Item 1 Item 1 % Item 2 Item 2 %
A N/A 12/15 82%
B 20/25 85% 15/18 90%
C N/A 25/30 88%
Total: 20/25 85% 52/53 89%
Thanks,
I have several sub-reports that group by the one category. In the main report links to two different sub-reports, which displays "Item 1" & "Item 2" for each category. Since Item 1 doesn't have record under category A, but item 2 does. That's why the reports shows below:
Category Item 1 Item 1 % Item 2 Item 2 %
A / 12/15 82%
B 20/25 85% 15/18 90%
C / 25/30 88%
Total: 20/25 85% 52/53 89%
How can I change those no record item 1 under category to test "N/A".. Below is the report that I would it to be displayed:
Category Item 1 Item 1 % Item 2 Item 2 %
A N/A 12/15 82%
B 20/25 85% 15/18 90%
C N/A 25/30 88%
Total: 20/25 85% 52/53 89%
Thanks,
ASKER
Hi mlmcc,
I have two formulas below. Then I add a text into the report: total_Y/total.
total_Y := sum({@total_Y});
total := sum{@total});
Thanks,
I have two formulas below. Then I add a text into the report: total_Y/total.
total_Y := sum({@total_Y});
total := sum{@total});
Thanks,
How do you show the 20/25
Is it like
CStr(total_Y,0) & '/' & CStr(total,0)
If so try this
If CStr(total_Y,0) & '/' & CStr(total,0) = '/' then
'N/A'
Else
CStr(total_Y,0) & '/' & CStr(total,0)
mlmcc
Is it like
CStr(total_Y,0) & '/' & CStr(total,0)
If so try this
If CStr(total_Y,0) & '/' & CStr(total,0) = '/' then
'N/A'
Else
CStr(total_Y,0) & '/' & CStr(total,0)
mlmcc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is it a formula?
If so can you change it so if there is no data it will show N/A
mlmcc