I’m looking for an efficient way to implement a fixed size / amount of records in the details section of a Crystal Report. For instance the details section size should always match the size of exactly 6 records. The problem is when less then 6 records are returned from a query. I dont need to suppress any additional records, my query will keep it filtered to the limit.
The background of my report simulates a form that needs to be filled out. There is a specific fixed-boxed area where the details / item records appear. However the details section grows/shrinks depending on amount of records passed to the report causing the rest of the form template to be thrown out of position. I need this to stay to a fixed size, no matter if there are 1 to 6 records displayed.
I’ve used a few workarounds so far such as implementing a sub-report in the details section, padding additional blank records to make up the difference, passing each of the record as an individual parameter etc…. Each of these have produced the desired results but are slow & inefficient, I’m hoping to find a better/faster way. Speed of creating & sending these reports directly to a printer is priority.
The background of my report simulates a form that needs to be filled out. There is a specific fixed-boxed area where the details / item records appear. However the details section grows/shrinks depending on amount of records passed to the report causing the rest of the form template to be thrown out of position. I need this to stay to a fixed size, no matter if there are 1 to 6 records displayed.
I’ve used a few workarounds so far such as implementing a sub-report in the details section, padding additional blank records to make up the difference, passing each of the record as an individual parameter etc…. Each of these have produced the desired results but are slow & inefficient, I’m hoping to find a better/faster way. Speed of creating & sending these reports directly to a printer is priority.
Last edited: