Suppress record in sub-report based on value in container report?

[ZacharyR]

Hi,

What is the syntax to suppress the display of a record in a sub-report based on a value of the corresponding record in the container report?

Example....I have a table with values of A, B, C

Currently, if I select only A to be displayed in the container report, the subreport will still show values A, B, C.

How can I tell the subreport to only show value A when the container only shows A?

thanks!

Zach

 

[lbass]

You should be linking the subreport to the main report on the field that contains 'A'. Then when you limit the records in the main report to A values, the subreport will automatically be limited to those as well.

-LB

 

[ZacharyR]

thanks...There's only one field I can use to link the two reports, and it's not the field that has the A, B, C values

But, I just realized you can link the subreport to the container report on more than one field....i'll give it a try. thanks!

Zach