Programmatically add blank records in Detail Section
Posted on 2004-03-25
I have a report where the layout is setup so that the data is printed in a tabular format, where the data is obtained from a SQL Server stored procedure. Thus, if I have 13 records, then I will get 13 rows of data produced in the Detail section. In addition, I have set the CAN GROW property of one of my textbox fields in the Detail section to true.
The report is capable of holding 25 records, if the previously mentioned textbox does NOT grow. If it grows, then there's no telling how many records the page will actually contain. Here's my problem: Regardless of now many records are actually able to fit the report, I would like to fill the detail section with BLANK rows if the data obtained did not fill the page.
For example, say none of the records will cause the textbox to grow. Then this means I can have a total of 25 rows on each page. However, say, instead of 25 records, I get 15. Then, I would like to programmatically add the remaining 10 records, as blanks, into the detail section so that the report looks filled.
When the textbox grows, this is even hairier, because now I don't know how many blank rows I'll need to add.
By the way, I'm using the Crystal Reports Bundled edition, wich came with VisStudio .NET 2002.