Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

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.
0
tbsgadi
Asked:
tbsgadi
1 Solution
 
nico5038Commented:
0
 
nico5038Commented:
Also read some comments down as perove did publish the code he used finally.

Nic;o)
0
 
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
 
Computer101Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now