Hello
I am creating a report. The main header report page is tied to a table where none of the records repeat, so I can keep it all on one page for the header.
But a part of the header would be listing values from a table that has a relationship with the unique records but can have more than one record
So for example:
PLAN: N-1234, district, name, etc, records that are only once in the table with the unique records.
Then the next table can have
N-1234, Tree1, color,
N-1234, Tree2, color
Or more records,
I'm trying to add this Tree1 and Tree 2 to the header but the header will become 2 pages now when I do this.. Is there a way to force it to one page, like a stacked table/columns on the header page?
Or does the Tree1 and Tree2 have to be stored in one field to make this work.
In the past the header page I created were all of the unique records so I didn't have this issue.
Then the body of the report, one page would be tree1 with its records and then page 2, Tree 2 with its records.
I'm being asked to have a field on the header that would list these (tree) values either as column type or separated by commas, tree1, tree2. But I would still have the main report with the the pages for each of these
Thanks