Blank Page end of Report CR 9

[taterday]

I hope I am clear. If not, please tell me what you need to help me.

No header or footer are printed on the main report. These are suppressed.

I have 3 subreports locationed in details a, b, c sections. The subreports prints within groups. The group options has been edited to print each new group on a new page.

I am using xbase tables. The databases are null if there is no data. Each subreport/section has its own table. The subreports are not linked on the main report. They print one after the other.

Other than the blank page at the end of the report, it works perfect.

Problem: blank page

Detail A will always have data records.
B will only have one record or none.
C will only have one record or none.

There is an extra page if B or C have no records.

What I have done on main report:

In the A section expert, on the new page before,
Not onlastrecord

In the B section expert, on the new page before,
ONfirstrecord or not isnull({cr_b.sdvs}]

In the C section expert, on the new page before,
ONfirstrecord or not isnull({cr_c.sdvs}]

I have tried "And" in the formula, nothing changed.
The blank page does not designate where it coming from. There is a gray line without the DA or DB or DC below it.

Please help. Thank you.

Tater

 

[lbass]

In the main report section expert, format each section to "suppress blank section". Also select each subreport->format subreport->subreport tab->check "suppress blank subreport".

Also check (in design mode) in the main report and within Make sure all sections have boundaries that are nested against the subreports (no white space).

-LB

 

[taterday]

Thank you. I double check everything and made sure I did your suggestions.

Same problem.


Tater

 

[lbass]

I meant to say: Also check (in design mode) in the main report and within [red]the subreports that there are no unused, unsuppressed sections.[/red] Make sure all sections have boundaries that are nested against the subreports (no white space).

Can you confirm that you are not exporting the report, i.e., that the extra page is occurring in Crystal?

Also, you mention that the subs are executing within a group. How are the group sections formatted in the section expert?


-LB

 

[taterday]

There was some white space. I removed this. there are not any other sections.

I believe it is occurring in CR. I created the tables in the app and did not delete them. I am using them in the design mode and preview mode for testing. I am testing the A having data and B and C with no data. I have tried using a blank record with a suppress: with field <= " ". there wasn't any difference.

What is strange to me is that I only get one blank page either with B and C empty. if B and C both have data, there is no blank page.

I hope I am answering your question. I appreciate your help.

A, B and C subreports are formatted this way:

Group Header #1: no formating
Group Header #1a: Suppress blank section checked
Group Header #b: Suppress not checked (in x-2) NOT InRepeatedGroupHeader

(Different heading when sdvs exceeds first page.)

Details: Suppress blank section checked.
Group Footer #1: Suppress blank section checked
Page footer: Suppress checked
Report Footer: Suppress checked

From the Report Group Expert: Group by Sdvs
Options: Repeat Group Header on Each page

 

[lbass]

Are you referring to the contents of the subreports? You should be formatting the main report sections that contain the subs to "suppress blank section" and you also need to format the subs to "suppress blank subreport".

-LB

 

[taterday]

Hi Lbass,

This is the attributes of the Main Report
The other was the attributes of the subreports themselves.

Main report
Report Header: Suppress checked
Page Header: Suppress checked

Detail a: Free-Form Placement checked
New Page Before: checked with x-2 not onlastrecord
Suppress Blank Section: Checked

Detail b: Free-Form Placement checked
New Page Before: checked with x-2 onfirstrecord or NOT isnull({cr_b.SDVS})
Suppress Blank Section: Checked

Detail c: Free-Form Placement checked
New Page Before: checked with x-2 onfirstrecord or NOT isnull({cr_c.SDVS})
Suppress Blank Section: Checked

Report Footer: Suppress checked
Page Footer: Suppress checked

End Main Report formating.

Main report formatting on subreports:
Subreport in Detail A:
Format Editor Subreport tab
Suppress blank subreport

Subreport in Detail B:
Format Editor Subreport tab
Suppress blank subreport

Subreport in Detail C:
Format Editor Subreport tab
Suppress blank subreport

Thank you,

 

[lbass]

I believe it is occurring in CR.

Can you run the Crystal Report independently to verify whether this is the case? I've seen multiple posts in the past where there is a blank last page when exported to other applications. I can't recall if this is a factor when integrated into another application. It may have something to do with differing margins or something, if I remember correctly.

Also I don't see the point of the "not onlastrecord" for the A section when used with "New page before" or of the "onfirstrecord" for the other two sections--but I don't think it matters to your current issue.

Just as a test, what happens if you eliminate the new page before on these sections? Do you still get the final blank page?

-LB

 

[taterday]

I am executing CR and running it in the design mode independently.

I eliminate the new page before on all sections and all x-2 editing and previewed the report and there wss the blank page. I did a report refresh data, also.

Section A only one with data, blank page

Changed this:
Added Section B data, no blank page but no page break between sections.

Does this help?

 

[lbass]

When Section A is the only one with data (with no page breaks built in), does the blank page show anything on the left designating the section?

-LB

 

[taterday]

No.

Just a light brown line with nothing below it.

 

[lbass]

Do the subreport objects clearly fit within the the margins of the main report?

-LB

 

[taterday]

Yes. They seem to fit. They are sized X=.010 and Y=7.25.
I have .25 on X, tried to get rid the white.
The subreports are set at .7 and 7.1

If A, B, and C have data, there is no extra page. Weird??