Learn how to a build a cloud-first strategyRegister Now

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

Blank page after last page of detail showing

I have a Report with GH#1a through GH#1g... GH#1g has a subreport..
No Page Header, No Report Header, and No  Report Footer on the Main Report

The Last Detail line always has a blank page after it...

I have tried using Not onlastrecord on every GF and GH and I cant get rid of it...

I have since removed all instances of this...Please help
0
Mikeyman_01
Asked:
Mikeyman_01
  • 4
  • 4
  • 2
  • +1
1 Solution
 
Kyle AbrahamsSenior .Net DeveloperCommented:
try suppressing blank sections and / or suppressing the blank reports.
0
 
James0628Commented:
It might help if you could post the report.

 Where are you using Not OnLastRecord?  Are you using it with "New Page Before/After", or as a suppression formula, or something else?

 James
0
 
mlmccCommented:
Do you have the NEW PAGE BEFORE/AFTER option set on any section?

mlmcc
0
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 
Mikeyman_01Author Commented:
I have submitted my document...
delivery-note-0005.rpt
0
 
mlmccCommented:
Try unchecking the PRINT AT BOTTOM option on the GF1

Any chance the note field has just a bunch of blank lines?

mlmcc
0
 
Mikeyman_01Author Commented:
The note field could be a bunch of blank lines, but it might not be
0
 
mlmccCommented:
Try trimming the note field before displaying it

mlmcc
0
 
Mikeyman_01Author Commented:
How do I 'trim the note field before displaying it'
0
 
Mikeyman_01Author Commented:
I did this.. per your request 'Try unchecking the PRINT AT BOTTOM option on the GF1'
and it is still happening
0
 
mlmccCommented:
You would need to create a formula and use it on the report rather than the field

Formula
 Trim({YourField})

mlmcc
0
 
James0628Commented:
If "note field" is referring to the Notepad field, it seems like the simplest way to see if that's a factor would be to go into the field format and uncheck "Can Grow", and see if you still get the blank page.  If so, then Notepad presumably isn't the problem.

 James
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now