Suppress Blank Section

[furlman41]

I have a rather large report file with a number of sections on the first couple of pages that I need to supress if blank.

When I DON'T use the "Suppress Blank Section" option, the report looks goofy [with white space], but the sections appear in the right order. Then, when I use the "Supress Blank Section" option for the sections that I need it, I get some sections repeating twice in a row on different pages. Is this a bug in Crystal Reports, or am I using the property wrong?

And, if it is a known bug.. are there any workarounds? Please help.

Thanks,
John Furlong

 

[Ngolem]

it is no bug that I know of...describe your report better...ie. the groupings...which sections are repeating...what the output looks like

You have given nothing to use to solve your problem....I do not believe it to be a Crystal bug....rather it is a developer bug

Jim Broadbent

 

[furlman41]

Ok, thanks for the quick response Jim. Here is some detail.

I have a report that displays a wide range of client information. The first section deals with personal information.

One of the sections that I need to suppress looks like this:

Husband
Medical insurance: $
Dental insurance: $
Uninsured medical expenses: $
Etc.
Etc.

Wife
Medical insurance: $
Dental insurance: $
Uninsured medical expenses: $
Etc.
Etc.

Section 3
Education expenses:


Now, if Wife wasn't entered into the database, then there will be no information for the wife, so I want to supress it. I have a few sections that function just like this.

So, when i DON'T use the option "Suppress Blank Section" and the Wife isn't entered, then I get blank space. However, if I use the "Suppress Blank Section" option AND the Wife section is near the end of page 1, then Section 3 (Education expenses) appears on page 1 AND page 2 for some reason.

Any suggestions?

John Furlong

 

[Ngolem]

Ok...what is the report structure

ie. How is it Grouped/organized

For example

Group 1 - Husband
Group 2 - wife
details
Footer 1
Footer 2

Where are these sections that you sho

Jim Broadbent

 

[furlman41]

Each one is their own section & subreport, because they have different RecordSelectionFormulas.

----------------------------------
Section 1 - Subreport Husband
----------------------------------
Section 2 - Subreport Wife
----------------------------------
Section 3 - Subreport Education
----------------------------------

Does that help? I'm not sure if I'm giving you what you asked for.

John Furlong

 

[Ngolem]

yes....now the problem is unfolding....all these details are necessary

Thses are the Subreports....but what is the Main report and its groupings and how is it linked to the subreports.

Also Where are the subreports placed in the main report....Specifically which sections!!!

All this detail is required to solve your problem

Jim Broadbent

 

[furlman41]

Okay, we advance further... =) I really appreciate your patience & help.

The main report takes in a parameter called "ClientID". Then from there, the sections are linked to the ClientID field.

Most subreports are linked to the parameter by the formula:
{Asset.ClientID} = {?Pm-Client.ClientID}

For other reports they are linked by similar formulas, such as:
{Medical.ClientID} = {?Pm-Client.ClientID} AND {Medical.Gender} = "Male"

Both types are generating the print error. It just depends on what section is right after the new page.. it ends up pulling it back to the previous page & still printing on the next page.

I have a large number of sections & subreports. Just to explain I have subreports located in Sections:
Dj,Dl,Dm,Dn,Do,Dp,Dq,Dr,Dv,Dw,Dy,Dz
I'd say 1 of every 2 or 3 sections contains a subreport which is linked back to the main parameter. However, the error only seems to appear on pages 2-3 & 3-4 of the report.

John Furlong

 

[furlman41]

One other thing i noticed about the problem.

After the report is run, for this example we'll say that there is a section on page 2 and repeating at the top of page 3.

If I advance to page 2 after the report is run, go to section expert and check ANY field (such as NewPageBefore) and then uncheck it and hit OK. Then advance to page 3, and page 3 is perfect. Then if i do the same thing on page 3 with any section, it reverts back to the screwed up display with a section repeating. It makes no sense to me & is extremely annoying. Does this explanation make sense to anyone?

John Furlong

 

[Ngolem]

as to your last comment....yes it does....it depends on how they interact....

But you are giving me this report one piece at a time....not the detail specific.

To have 10+ detail sections with multi subreport is very complicated...I still don't know how they interact or what is where....It is impossible to diagnose what is going on until ALL THE REPORT IS CLEARLY LAID OUT....sorry but you aren't doing that yet.

***********
I have a large number of sections & subreports. Just to explain I have subreports located in Sections:
Dj,Dl,Dm,Dn,Do,Dp,Dq,Dr,Dv,Dw,Dy,Dz
I'd say 1 of every 2 or 3 sections contains a subreport which is linked back to the main parameter. However, the error only seems to appear on pages 2-3 & 3-4 of the report.
***********

Details details....we need details....not mind readers here

Why are there 26 sub sections to the detail section??? HAving so many subreport must slow this report to a crawl.

Show us what goes on in each section....especially the non- subreport sections...

Is information shared between subreport and mainreport or is the subreport just displayed?

HOW are you supressing the subreport sections?? what method are you using?

Details....details....you cannot give too many...unless you do give them we cannot help you

Jim Broadbent

 

[HughFreiden]

Don't have an answer, but I have the exact same problem.

It appears to happen when you have suppressed all the subreport lines, YET, you are sharing needed variables between the subreport and main. Thereafter you suppress blank section in the section wizard and suppress blank reports in the format tab of the subreport menu.

This is my theory, but I may be wrong. I think the option to suppress blank subreports really only works if there is NO data in the subreport. If you have data in the subreport and it is ONLY manually supressed, then our error happens.
Hugh

 

[GJParker]

John

Jim Broadbent is right you really need to let us know how your main report is setup and how the subreports interact with it.

But are you sure that a subreport is required to show each peiec of information about a client ? If you show us how your data is structured we may be able to offer some alternatives to simplify your report.



Gary Parker
Systems Support Analyst
Manchester, England

 

[furlman41]

I contacted Crystal Reports with this problem a couple weeks ago, and after a couple hours of troubleshooting, the problem was with the software. The latest software, database, and developer patches fixed the problem. Hope this helps Hugh.

John Furlong

 

[furlman41]

If you are using Crystal Reports 9, then go to:

http://support.crystaldecisions.com/updates/default.asp?ref=default.asp_selectlist_hotfix

Then search for the following zip files which will allow you to download the most up-to-date monthly hot fixes.

cr90dbexwin_en.zip - database hot fix
cr90devwin_en.zip - developer hot fix
cr90mainwin_en.zip - main application hot fix

Good luck.

John Furlong

 

[HughFreiden]

I searched the crystal web site, and yes this exact same problem is listed in the monthly hot fix for April. The link in the previous thread should get you there. More specifically;
ADAPT00124904, Patch ID 35102213 and found in CR90MAINWIN_EN_200304

Loaded and all works OK.