Working with values from a Subreport, in the Main report

[AlanCrawford]

Hi guys,
Is it possible to take the value of a field in a subreport, and use it to suppress the detail field in the mainreport?

I have a report which has one detail band only. In that detail band is a field sized subreport which displays one field from a single selected record from another table (which is linked to the table in the main report).

Is there anyway I can use conditional suppression to suppress the main report detail band - depending on the value in the subreport field?

Thanks in advance for your help.

Alan Crawford
Sx3

 

[dgillz]

I have never done this but I have done math formulas with subreport data -- shared variables are the key. Assign the subreport value(s) to a shared variable, then conditionally suppress like you normally would, and reference the shared variable in your formula, and I believe this will work. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[Hattusas]

You have to use formulas and must define ALL of your variables as "shared".

 

[AlanCrawford]

Thanks for the help - it seems to be working... ;o)

 

[Guest_imported]

Hello ,

I need a specific help for a Crystal report that I've been developing. I've created a sub-report which is accepting value from the main report as parameter and displaying in the Detail section of the latter. The problem is how to create a total field based on the values returned from the subreport.Please help.

 

[AlanCrawford]

See thread149-107997 - "Summing a subreport and the main report?" for the answer. )

Best Wishes,

Alan