Adding row in a report

  • Thread starter Thread starter Duane
  • Start date Start date
D

Duane

Hello,

I have a report that shows the total number of items for a particular area,
date and time. There might be 1 record or there might be 50. What I want
is for my report to always show 60 rows evertime the report is run. I know
I can loop through and just add extra records, but there must be a better
way to achieve this without all the overhead.

Is there a way to add blank extra rows in VBA?

Any help would be greatly appreciated.
 
Duane said:
I have a report that shows the total number of items for a particular
area, date and time. There might be 1 record or there might be 50. What
I want is for my report to always show 60 rows evertime the report is run.
I know I can loop through and just add extra records, but there must be a
better way to achieve this without all the overhead.

Is there a way to add blank extra rows in VBA?
Click to expand...
Add the "extra" rows in the source query. You can use a Numbers table that
has a single numberValue column. Fill that table with integers from 1 to x,
where in your case x is at least 60. Then join that table in your source
query with a condition Where numberValue <= 60. If you provide the SQL for
your table(s) and the current report query, someone might be able to give
more specific advice.

It is also possible to write VBA to prevent the standard row advancement
through the data source until 60 rows have been output, but adjusting the
query is probably more straightforward.
 
Is the detail section height set to Not Grow or might it expand for some
records?
Do you have any type of grouping where you need 60 per group?
Are there page breaks by group?
 
Back
Top