Add Blank rows to report

Hi Experts,

I have a report grouped by Companies.

I need it to have a minimum of  3 rows per Company ie even if the the Company has only 2 rows of Data I want the report to add a blank line.
I don't want to use a subreport.
I have an idea how to do it from the query but I'd prefer to do it from the report.
LVL 46
tbsgadiAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0
 
nico5038Commented:
0
 
nico5038Commented:
Also read some comments down as perove did publish the code he used finally.

Nic;o)
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
tbsgadiAuthor Commented:
Hi Nic;o) the code there doesn't work,but anyway my case is different.
Perove in the end used PageBreaks
 I don't want a new page after each company.
0
 
nico5038Commented:
OK, then it's probably easiest to force an extra row in your query.
What is the relation between your company table and the 2 or 3 row table ?

Nic;o)
0
 
tbsgadiAuthor Commented:
I think I have it,
I'm adding a textbox using Chr(13) & Chr(10) &[Company] showing only if count(*) is <2
setting line spacing etc
This seems to be the easiest way out
0
 
nico5038Commented:
When you have no (or little) space between the rows that's indeed a brilliant plan :-)
Don't forget to have the CanGrow option set to "Yes" for the field.

Nic;o)
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
For future reference: See the MoveLayout, PrintSection, and NextRecord properties in the on-line help.  With this properties, you can do all sorts of things, like repeating lines, dropping down the page, etc.

  For example, to print your blank lines, you could have done this in the OnFormat Section of the detail:

If <some condition> then
 .MoveLayout = True
 .NextRecord = False
 .PrintSection=True
End if

  By default, Access sets all these properties to true for each section print.  Changing them allows you to control the processing of the report engine in many different ways.

Jim.
0
All Courses

From novice to tech pro — start learning today.