bruceiow Posted February 14, 2015 Share Posted February 14, 2015 Hi All, I am after a bit of advice on how I might be able to format my report a bit better. I have built a report based on a table and have a portal that then displays all related records. The report works fine in 50% of cases. The scenarios where it doesn't work is where the amount of related records exceeds the amount of rows shown by the portal. A scroll bar is displayed to the end user and the records can be seen by scrolling but this report is designed for printing. Some records will have 1 related record, some may have 50. I need to find a way of catering for both of those senarios on one report. Can anyone help, I feel that the portal is a great form tool but maybe not so useful on the reporting side of things. Many thanks Link to comment Share on other sites More sharing options...
comment Posted February 14, 2015 Share Posted February 14, 2015 I have built a report based on a table and have a portal that then displays all related records. A few (and rare) exceptions aside, it is standard procedure to produce reports from the most atomic table - in your case the "related records" table. Instead of a portal, show these records in the body of the layout (set to list view), and use a sub-summary part to show data from the parent records. Note that such reports exclude parents with no children - that would be one of those exceptions. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3330 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now