Don't include detail if no data

[RichS]

I have a report that is based on a query. The query gives names from one table and many entries for that name from another. I have designed a report so that the name is in the header of the name group and the entries for the name in the detail section.

Sometimes, the name has no entries for it, but my form still prints the headings for the entries. If I use code to hide the entry fields when empty, the report still leaves a gap where a single entry would be. Is there a way of producing a report that only prints entries when available and prints the next name immediately after (no gap) when there isn't?

 

[Alisa]

What if you modify your query to only return the name of the table if it has entries?

 

[RichS]

The report must include ALL names, so if I filtered on whether the details were available, the names with no additional details would be left off.

As an example, a similar database could hold a list of music CD titles in one table and a list of tracks for all the CDs in another table, linked with a common CD identifier. If it only had the CD title in the first table and no track information, the report would still need to list the CD but in my case, the report is still printing text labels for a the first track, even though there are no details.

The query returns details of every CD and every track linked. The Report groups the results by CD title, showing the title in the group header, then shows the track information in the main details section. I basically need the report to leave out the details section if there are no details, or do I need to do the report in a different way? This is why I am asking for assistance...

 

[Alisa]

What if you set the details section property to CanShrink = yes?