Report creator (digital metaphors) adds blank lines to the detailed range to the end of the page

Question

I am using ReportBuilder 10 in Delphi 2006 with an Access 2000 database. I am trying to create a report using a filtered query.

Telerik Report: Starch Row in Detailed or Add Empty Lines

Repeat the vertical line on each page in Report Builder / SSRS

As in the questions above, I am trying to add blank lines (or records) to the ReportBuilder data range after the filtered query records. Until it fills the page. My data feed is similar to an excel table, and it can take 25 rows per page. If I have 30 entries, the first page is good. But on the second page there will be 5 entries. Then a huge gap will appear between the parts and the bottom columns. It looks bad.

I tried to find this, but nothing works. Only the second link above. But no solution I can use has been published.

I hope I correctly explained my problem to you guys. Any help would be appreciated.

Answer 1

I don't know ReportBuilder well enough to give specifics, but I suggest

• Add 25 blank lines to the report query result. You must do this using a series of UNION commands. Make sure all sorting actions put them at the end of the results.
• Create a boolean variable isBlankLine , which is updated for each detail line when it is evaluated for the layout. This variable is simply set to true if the record is an empty string (one of the lines added in step 1.)
• Create another boolean variable isReportEnd , which is evaluated on the page footer. This value is true if isBlankLine is true, otherwise it is set to false.
• Finally, for each line string, suppress the line if isReportEnd true.

This will fill the page with blank lines and suppress any additional pages. The only catch I can think of is that if the report ends with exactly 25 entries, so that the first line of the next page is an empty line, then your last page will be empty.