Only the 1st line of a portal table is displayed in the "list" report.
I have a Job Management Database: it contains a "Jobs" table and "Activity" table. A user can open a "jobs" form. In that form there is a portal to a "jobs activity" database. The user can create any number of entries into that job for specific "job activity" associated with that job. All works great.
I want to be able to create a "list" view report that can summarize the job information as well as all the portal job activity. When I build a list view report, only the first line of the portal "activity" appears. How can I get the report to display all the portal job activity?
I've see suggestions for creating the report based on the portal table. That could work well if I wanted to display a single job record on a page but I was hoping to use "list view" to maximize space on a printed page. There are typically 100+ jobs that are active at any one time.
Thank you for your suggestions.