Report Question

I have some data in a main table with one or more related rows in a portal. 1:M.

Since I don't know in advance how many rows might be in the related portal table, how do I create a report that will expand automatically to display all the portal rows (could be none or ten)?

Don't want to have each page of the report with potentially 10 blank portal rows if none are in there for that parent record.

Thanks,

Two ways to solve this come immediately to mind:

  • Base your report on the related table instead of the main table;

  • Use sliding and shrinking rules to reduce white space when rows don't exist.

Hope this helps.

4 Likes

Good idea, thank you!!! :slight_smile: