Accessing a cross tab value from a subreport for purposes of sorting

[former_member601482]

Hello,

I have a crystal report that contains customer information.  For each customer, there is a subreport that contains a cross tab listing the customer's invoice amount for each month and a total invoice amount (sum field) as the rightmost column.

I would like for my main report to sort the customers by the total invoice amount.  But since this value is contained in the cross tab of the subreport, I'm not sure I can access it.  Any ideas on how I might be able to do this, or the best way to do this?

Thank you!

[abhilash_kumar · Accepted solution]

Hi Bob,

Using shared variables is the only way to bring values from the Main Report to a subreport.

And, CR does not allow sorting on shared variables.

The workaround is to calculate that total, in the Main Report.

-Abhilash