Pass Main Report Value to Sub Report 1

[tc3596]

Will shared variables work here? I've tried it but I can't seem to get it. I'm using 8.5. My sub report is in Group Footer 1. In my sub, if main value = x then suppress field in sub. Any thoughts?

 

[lbass]

You have to create the shared variable in the main report by creating a formula. For example:

whileprintingrecords;
shared numbervar x := sum({table.field},{table.group})

You must place this formula somewhere on the main report canvas and it must be placed in a section that in which the subreport is located.

Then in the subreport, you would click on the field you want conditionally suppressed->format field->common->suppress->x+2 and enter:

whileprintingrecords;
shared numbervar x;

x = 500 //assuming you want the field suppressed if it is this value.

-LB