Crystal formula based on sub report
I have a report and want to base a formatting formula on a field on the sub report.
When I look for the fields I want to add to my formula (from the sub report) they are not available.
Is this even possible?
When I look for the fields I want to add to my formula (from the sub report) they are not available.
Is this even possible?
Agree.
FOr example if the report is grouped on a field nd you have the subreport in the group header, then you can format the details and group footer based on a value passed back from the subreport.
Can you give us more information on the formatting you want to use in the main report?
It may also be possible to use a SQL Expression to get the information you need.
Another idea would be to have a User Function (UFL) call that returns the information.
mlmcc
FOr example if the report is grouped on a field nd you have the subreport in the group header, then you can format the details and group footer based on a value passed back from the subreport.
Can you give us more information on the formatting you want to use in the main report?
It may also be possible to use a SQL Expression to get the information you need.
Another idea would be to have a User Function (UFL) call that returns the information.
mlmcc
ASKER
Hi Guys,
I'm not hopeful, but here is some more info: -
I have 2 report headers one of which I want to hide depending on the result of the sub report. The sub report is a one-liner having Customer Code and a parameter (Email or Post)
Peter: not sure what you mean by: -The only route you can look at is to pass the value from the subreport to the main report using a shared variable and then test the variable value.
I'm not hopeful, but here is some more info: -
I have 2 report headers one of which I want to hide depending on the result of the sub report. The sub report is a one-liner having Customer Code and a parameter (Email or Post)
Peter: not sure what you mean by: -The only route you can look at is to pass the value from the subreport to the main report using a shared variable and then test the variable value.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the (very detailed) help!
The only route you can look at is to pass the value from the subreport to the main report using a shared variable and then test the variable value.
This means the main form formatting must come After (lower than) the subreport in the design.