Report Printing Header and Footer on 2nd Page when no detail lines
Hoping someone can assist please. I am using Report Builder Enterprise
Edition Version 9.02. I am creating a Purchase Order Using a Header,
Footer and Detail section. I am Grouping by a supplier code and delivery
address code.
The Detail section contains fields being extracted from a SQL database.
What I am finding is that once the detail section holds 16 lines a new
page is being created that only contains the Header and Footer but no
details.
I was getting this problem before when I found that if the detail
section only has one line it was printing the footer and header on a
second line. I decreased the size of my footer and this stopped
happening continuously, now it kicks in when the order reaches 17 lines.
I am very inexperienced so if someone can give me some clear, easy
guidance I would really appreciate it
Thanks
New To It all
--- posted by geoForum on http://delphi.newswhat.com
Edition Version 9.02. I am creating a Purchase Order Using a Header,
Footer and Detail section. I am Grouping by a supplier code and delivery
address code.
The Detail section contains fields being extracted from a SQL database.
What I am finding is that once the detail section holds 16 lines a new
page is being created that only contains the Header and Footer but no
details.
I was getting this problem before when I found that if the detail
section only has one line it was printing the footer and header on a
second line. I decreased the size of my footer and this stopped
happening continuously, now it kicks in when the order reaches 17 lines.
I am very inexperienced so if someone can give me some clear, easy
guidance I would really appreciate it
Thanks
New To It all
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
For future reference, we prefer you use your real name when posting to these
newsgroups.
The reason you are getting the following behavior is probably from the fact
that you are running out of space on the first page and perhaps have
KeepTogether set to True for one of your groups. Try adjusting the
NewPageThreshold (New Page When Less Than) property of the group to ensure
it will give you enough space to fit your footer band.
If this does not help, try simplifying your report. For instance, try
removing the second group and try to recreate the issue. Be sure your data
is ordered first on the first group break field, then the second.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com