This can be done only if your detail section will always be the same height - if you have any "Can Grow" data that may or may not have multple lines, there is no way to handle this.
- First you need to determine the maximum number of lines that can appear on the report.
- You'll have one detail section that contains data.
- If you don't have any grouping in your report, you need to create a group on a field that only has one value in the report.
- Create a separate group footer section for each possible line that you need to have that you may not have data for. Each of these sections will be set up like your detail section (lines and any hard-coded text you may need), but will not include any fields. If you will always have at least one row of data, you can create one fewer of these sections than the total lines that can appear on the report.
- Create a running total that will count some unique identifier that is in your detail data and reset on change of the group where you've created the footer sections. I'll call this {#RecordCount}.
- In the suppression formula for the first footer section put something like the following formula:
{#RecordCount} >= 1
For the second section use:
{#RecordCount} >= 2
And so on for each section. This will suppress the "blank" sections that aren't required because there is a corresponding detail section with data.
-Dell
IP Logged
