Force a section to print on the next page

[junction123]

Hi,

I am using Crystal Reports 9.0 embedded in VB dot Net. SQL is the backend database driving the report data.

The report already has a few sections

Fund Investment Summary



Series Summary

I need to add a brand new section called Interested Parties. But I need to print this section on the next page sicne the report data is large and I do not want to break the new section , like printing some data on one page and continuing to print on the next page.

Teh report also needs additional columns added so changed the orientation under Report Options to be landscape to acomodate the additonal columns.

Please advise on how to force a section to print on the next page.

Thanks in advance for your help.

Regards,
Junction123

 

[lbass]

In the section expert, highlight the section that will contain the new information and check "new page before" and "keep section together".

-LB

 

[junction123]

I am going to try that.

Thanks LB.

Best Regards,
Junction123

 

[junction123]

LB,

I also have two sub reports that provide details for the section

Fund Investment Summary



Series Summary

Series Summary (subreport providing details)


Summary Of Activity
ActivitySummary (subreport providing details)

Summary of Activity
ActivitySummary2 (subreport providing details)

INTERESTED PARTIES (added new section)
Email Name

I am unable to see this section at all.

All above sections have a suppress formula based on the same condition. I included the same formula for teh new section that I added. I also added your suggestion.

I cannot figure out why the section is not showing.

if not ({Detail.fund_CapitalAdditions}<>0) and not({Detail.fund_CapitalReductions}<>0) then
formula = true
else
if not({Detail.HideSeries}) then
formula = true
else
formula = false
end if
end if

Thanks again for your help.

Best Regards,
Anita

 

[junction123]

When I preview the Main report to go to next page, it says
'The page size was not large enough to format the contents of an object in the report'.

Should I add the new section prior to the section that has the sub report or it does not matter?

Thanks for your help.

Best Regards,
Anita

 

[junction123]

Also the other sections are all Group Header sections and grouped by several fields.

I am not sure whether teh new section should be grouped or just a detail section.

I will try inserting as a Detail section and see whether the report shows the section.

 

[junction123]

How many sections can a report have? The section I added is Section 19. I also tried adding a subreport below the section
INTERESTED PARTIES

The subreport ahs the details for the Email and Name hardcoded. I still do not see the section.

I will try the New Page Before and teh Keep section together with teh subreport option as I did earlier.

Can you please tell me why the section is not showing up? maybe there is no space in the report?
Thanks for your help.

Best Regards,
Anita

 

[junction123]

Also, originally the orientation was Portrait. I changed it to Landscape to accomodate the new section.

As a result I do not see the third section 'Summary Activity' nor do i see teh new section that I added.

Orientation and Legal expands teh width to accomodate new columns but the height is reduced and hence I believe the sections do not show.

But how can I force the sections not showing to continue on a new page?

Thanks for your help.

Best Regards,
Anita

 

[lbass]

Please identify your sections by their actual names, e.g., group header, detail or detail_a, page footer, etc. Section 19 is not the name of any section.

I think you should remove the conditional section suppression until you get the subreports displaying correctly. Do not add a subreport to the page header or page footer sections. The logic of the report should dictate where the sub is placed. If you want it to execute for each group instance, place it in the group section. If you only need it once per report, use a report footer section.

-LB

 

[junction123]

I tried the subreport without the suppress formula but it still did not print the sections to the next page.

Is there another way that you know of to force the section to print on a new page?

Thanks for your help.

Best Regards,
Anita

 

[junction123]

When I tried suppressing each section to find out why it cannot accomodate all sections under Landscape/legal Orientation, I get this message when I try to accomodate three sections.

The page was not large enough to format contents of an object in the report. I am unable to move to the next page.

Do you know why I would get this message?

Thanks

 

[junction123]

LB,

If I need only the headers under the Fund Summary section to repeat on a page break, then how can I force this?

The headers under Series Ummary and Summary Activity should not repeat on page break. I am hoping this will give me more space to accomodate the sections not showing.

Thanks

 

[lbass]

Please identify your groups by the field you are grouping on and then identify the subreports by where you are placing them in the main report. Also explain how you have formatted sections in the section expert. Then explain the current problem again.

I only meant for you to unsuppress temporarily so you could see what was going on.

-LB

 

[junction123]

LB,
I was able to force the 4th section(grouped by) top the next page.

However, as I got this by commenting out the suppress formula for one of the section containing the subreprot that is under section III, both supreports are printed and the 4th section goes to the 4th page.

Typically, I should have one of the subreport(from section III) printed and section I adn section II all on the first page, while section IV will print on the second page.

I need to figure out, how to print just one part in section III as well get section IV on the next page.

When the suppress formula is uncommented for both sub reports. then section III prints only one subreport based on the conditional suppress formula, but section IV is not printed.

The reprort layout is as below. The 4th section is in the group header.

Fund Investment Summary (group section I)
Series Summary (group section II)
Subreport

Summary Activity (group section III)
subreport1
Subreport2

Interested parties (group section IV)





I was able to bring the 4th section to a new page however the third section prints both sub report 1 and subreport2. Tehre is a conditional suppress formula to suppress either subreport1 or subreport2 for section 3.

So the report now prints 4 pages instead of 2. The 4th section appears in the 4th page.

I get this by commenting out the suppress formula for one of the sections that contain one subreport.

Now how do I show just one subreport for section3 and show the 4th section is the the piece I need to figure out.

Below is the formula for each subreport in section 3.

'if not ({Detail.fund_CapitalAdditions}<>0)and not({Detail.fund_CapitalReductions}<>0) then
' formula = true
'else
' if ({Detail.HideSeries}) then
' formula = true
' else
' formula = false
' end if
'end if

 

[junction123]

Also, I noticed that section III has same exact columns for both subreports except there is one additional column for subreport1.

Series TradeDate Description Number


subreport2 has teh below columns
TradeDate Description Number

Is there a way I can just combine both header in one section and have a formula to show the series column heading when subreport1 is selected?

The section III is causing the problem.

 

[lbass]

Please restate using actual report section names, as I have requested earlier: group header #1, group header #2, details, group footer, etc. and identify the fields or formulas you are grouping on. Section I, II, III, mean nothing to me.

-LB

 

[junction123]

GroupHeader #5k ,Group Header #l, Group Header #m, Group Header #n have teh formula to suppress the section.

The suppress formula is for suppressing Group Header #l, Group Header #n depending on HideSeries.

The fields grouped by are PshipCode, ClassId, EntityCode, SubEntityCode, InterestedPartyCode.

If I move the above group headers to detail instead and not having to repeat the column headers, will that help?



'if not ({Detail.fund_CapitalAdditions}<>0)and not({Detail.fund_CapitalReductions}<>0) then
' formula = true
'else
' if ({Detail.HideSeries}) then
' formula = true
' else
' formula = false
' end if
'end if



'if not ({Detail.fund_CapitalAdditions}<>0)and not({Detail.fund_CapitalReductions}<>0) then
' formula = true
'else
' if not(({Detail.HideSeries})) then
' formula = true
' else
' formula = false
' end if
'end if

 

[lbass]

Sorry, but I just can't follow this.

-LB