cancel
Showing results for 
Search instead for 
Did you mean: 

Static Report Form

Former Member
0 Kudos

I need a way to create a grid with a set number of rows, independent of the number of records in the dataset. I am thinking of using a crosstab, but I do not know how I would create empty rows to complete the grid if I only have a few records. Anyone a solution for this or maybe if this is something that is too much of a hassle to even to do in Crystal Reports.

Accepted Solutions (1)

Accepted Solutions (1)

former_member292966
Active Contributor
0 Kudos

Hi,

It's not impossible but it's also not very simple. I've created forms that had to have a maximum of 6 records per page. If there were less then blank lines were needed to make up the difference.

It took a combination of a record counter resetting in the Page Header. In the Group Footer where I show my records, I format the New Page After formula where RecordCount = 6.

To get the extra blank lines, I created 5 empty group footer sections. In the Suppress section formula I had it check the record count. If the final record count on the page was 1 then all 5 section will show. If the final record count was 2 then the last 4 sections would show, etc.

Hope this helps. In my case it got complicated because I had multiple groups to manage.

Brian

Former Member
0 Kudos

Thanks for the reply, I will give it a shot.

Answers (0)