We help IT Professionals succeed at work.

Section starting on a new page

pvsbandi
pvsbandi asked
on
hi ,

  I have 2 questions on this report.
  Attaching my report in question.

1. I have a section called "Worker Supervisor approvals/Overrides".
  This section is starting on a new page, leaving a big blank space before the previous section.
 
   Can someone kindly help fix it, so it just follow the previous section?

2. This section "Worker Supervisor approvals/Overrides" has the Type field. I need to show the following order.
 "Request" followed by "Approval". Then "first OVerride" and then "Second OVerride".
How can i achieve that sort?

Please help.
Test-report.rpt
Comment
Watch Question

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
1. I have a section called "Worker Supervisor approvals/Overrides".
YOu have NEW PAGE BEFORE conditionally set for that section.
Delete the formula

2.  Use a formula.  CHeck the SortOrder formula I built

mlmcc
Test-report-1-.rpt

Commented:
In design view, right click the grey section area on the left hand side. Click "Section Expert".

Select Section: Group Header #17: COMMON.SCREENING_ID - A

Notice that the "New page before" formula is highlighted red? Click the button and remove the formula code.

This resolves issue 1.

Author

Commented:
Thanks so much!