I have a variable from a sub report being passed to the main report. That variable is a sum of a column in the sub report. I'm then summing the sum in the main report using a global variable and that is all working fine.

But, the data in the sub report is being filtered not just by the default parameter linking sub report to main report, but also by a user input parameter on a column in the sub report.

The end result is the main report is displaying the proper lines from the sub report that I want (although there is a blank detail line with a header from the sub report where the user input parameter doesn't match.)

The problem is the variables are including the data that is hidden on the main report, summing the values that are filtered by the user input parameter.

I hope this makes sense, very difficult to explain this properly.   Can anyone help me with this?

Thanks,

Matt

Thanks for your response, I'm just finally getting back to finishing this report.

Can you get me a bit closer here?   I'm comfortable with Crystal but am fairly new to playing with variables.

Right now I just have a formula in the subreport called "shared" that contains

shared numbervar test:={@sum2};

I understand what you are saying about incrementation, but what's the syntax to say "where the detail line is displayed" ?

Thank you for your help!

Edited by theghetto - 16 May 2012 at 6:47am