Fixed Number of Rows Printed for Data Band
Posted: Fri Jul 08, 2022 4:52 pm
I have a report where I need a fixed number of rows printed regardless of the number of records pulled by the data band.
For this example I have a report where I need 10 Rows displayed per page.
Example 1: Data Band pulls 1 record with associated information, the report would display 1 populated row and 9 empty rows. Example 2: Data Band pulls 6 records with associated information, the report would display 6 populated rows and 4 empty rows. Example 3: Data Band pulls 8 records with associated information, the report would display 8 populated rows and 2 empty rows. Example 4: Data Band pulls 11 records with associated information, the report would display 10 populated rows on page one them move to page 2 and display 1 populated row with 9 empty rows.
Samples Attached - NOTE: I added numbering 1-10 in the left column to show the total number of rows. Dummy Data manually entered not using Data Band is used for the example.
For this example I have a report where I need 10 Rows displayed per page.
Example 1: Data Band pulls 1 record with associated information, the report would display 1 populated row and 9 empty rows. Example 2: Data Band pulls 6 records with associated information, the report would display 6 populated rows and 4 empty rows. Example 3: Data Band pulls 8 records with associated information, the report would display 8 populated rows and 2 empty rows. Example 4: Data Band pulls 11 records with associated information, the report would display 10 populated rows on page one them move to page 2 and display 1 populated row with 9 empty rows.
Samples Attached - NOTE: I added numbering 1-10 in the left column to show the total number of rows. Dummy Data manually entered not using Data Band is used for the example.