Spacing changes between Page Header and Page Footer 1

[CaptainD]

I have a Main report with two sub pages. Each sub page is a crosstab report. I placed one crosstab in the Page Header and suppressed the Report Header. I placed the other crosstab in the Report Footer and suppressed Details.

There is also a text object for the report title above the crosstab that is in the Page Header.

When I view the report, page one looks good with a small space between the header and footer. When I go to page 2 and 3 the report header and report footer lose their spacing. In print preview mode I tried moving the report footer crosstab down but it just moves itself back up.

Is there any way to "Lock" it in place so I maintain the spaceing?

 

[lbass]

Since crosstabs cannot be placed in a page header, where exactly is the first crosstab?

-LB

 

[CaptainD]

The crosstab is in another form by itself and I placed it as a sub-page in the main forms Page Header section.

 

[lbass]

Sorry, but you must be talking about another application--VB? Crystal doesn't have forms or subpages.

-LB

 

[CaptainD]

Sorry, my terms were not correct.

I'm using Crystal reports X1

I have a main report and two sub reports. Each of the sub reports have a crosstab

One sub-report is in the page header of the main report and the other is in the page footer or the main report.

 

[lbass]

Are these the only objects in your report? You are more likely to get better spacing if you place the subs in separate report footer sections. Why are there multiple pages? Do the subs just execute once but then continue for multiple pages? Try suppressing all sections within each sub except the one containing the crosstab, and then in the main report, resize the sections containing the crosstabs to minimize their height.

-LB

 

[CaptainD]

The first crosstab that is in the page header so that it would be above the crosstab in the page footer. My boss wants the first crosstab on each page. At the momment it only has three rows (Data for 2007 and 2008 with a grand total.)

It is placed in it's Page Header section with the other sections suppressed.

There is also a text object with the report title in the page header.

The report footer has only the second crosstab which at the momment has three pages of information.

The second crosstab is placed in it's "Report Header" with the Details and Report Footer suppressed. I moved it to the footer but it did not make a difference. I also tried moving it down in it's report header area with no change.

The page footer has text object tht says "Print:" along with a {Data Date} field and a {Page N of M} field

 

[lbass]

Within each sub the report sections should be minimized so that borders are snug up against the crosstab. Try minimizing the height of the subreport in the main report also, so that it must grow to fill the necessary space.

I'm having a little trouble visualizing where this extra space is. Also how is the main report creating more than one page? I don't think a sub placed in a page footer can be longer than one page, so I'm back to wondering whether the second sub is really in a page footer section or in the report footer section.

-LB

 

[CaptainD]

I don't think a sub placed in a page footer can be longer than one page, so I'm back to wondering whether the second sub is really in a page footer section or in the report footer section.

The report footer has only the second crosstab which at the momment has three pages of information.

The two crosstabs are in their own report headers with everything else suppressed.

The main report has the Report header and details suppressed. One crosstab is in the Page header below a text object with the title for the report.

The report footer has the other crosstab that if viewed separate (Or in the main report) has three pages ( 2 1/2 pages of information)

The crosstab in the report footer is about 1/2 inch below the "Details" section.

When viewed in the main report, I have the text object with the first crosstab about a 1/2 inch below it, then about 3/4 inch below that the second crosstab starts. When I go to page 2 or 3 the second crosstab moves up against the first crosstab.

Then there is also a page footer that holds the printed date and page numbers.

And you are correct, at one point I tried to place the larger crosstab in the page footer to see what would happen and it would not "compile" because it was to large.

I appreciate your help.

 

[lbass]

Okay, I see the layout now. Sorry for the confusion. First I would put any separate objects in their own section, e.g., put the text header above the first crosstab in Ph_a, and the crosstab in PH_b. I think the second page is printing differently because it is a continuation of the report footer section. To control the space, add an additional PH_c, and then place the second crosstab right up against the upper boundary of the report footer section, instead of trying to regulate the space using the report footer section. Adjust Ph_c to the height of space you want to see.

-LB

 

[CaptainD]

That worked.

Thanks for the help !!!