Jump to content

Remove Group Header when Multiple Data Bands are blank


katepassaro

Recommended Posts

 Hello - 

I have a main report that includes a group header band, and then three sub-reports that are housed in three detail bands. I'd like to not print the group header if all three of the subreports are blank, but I can't figure out how to write a print when expression because it really is the data from three separate queries. 

Any ideas? 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Just a quick update as I found a solution.

 

I created three smaller queries to combine the group header element, and a row count from each of the queries and then unioned/summed them. Using this as a where clause for my main report query helped only display headers that had sub query data.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...