on 11-28-2011 8:13 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.