Hello - I have a Crystal Report that contains a GRID made up in the details section. What I want to do is extend the grid for the rest of the page, when less than the line records are printed. For example - there is room for 12 grid lines in my report -
each line has a grid with data from the database. If there are 4 records in the database - it prints 4 grid lines with the data. I want it to print the remaining 8 lines with the grid, just with no data in the cells of the grid. I tried counting the records
in the report, then doing a FOR/NEXT Loop print records for (12 - Count), but I am unsuccessful. Here is the Formula Field I created to attempt to do this.
TFLerew325
0 Points
2 Posts
Crystal Reports - repeat grid lines in details
Dec 11, 2012 02:42 PM|LINK
Hello - I have a Crystal Report that contains a GRID made up in the details section. What I want to do is extend the grid for the rest of the page, when less than the line records are printed. For example - there is room for 12 grid lines in my report - each line has a grid with data from the database. If there are 4 records in the database - it prints 4 grid lines with the data. I want it to print the remaining 8 lines with the grid, just with no data in the cells of the grid. I tried counting the records in the report, then doing a FOR/NEXT Loop print records for (12 - Count), but I am unsuccessful. Here is the Formula Field I created to attempt to do this.
WhilePrintingRecords
EvaluateAfter ({@LastRecord})
Shared LineCount as Number
Shared LastRecord as Number
For LineCount = 1 to (12-(Count({QCInspectionLineTable.BlueprintNumber})))
Formula = {QCInspectionLineTable.BlueprintNumber}
Next LineCount
Please help or tell me what I am doing wrong...
Thanks,
Todd