my subreport appears twice on my report

[tazibc]

can anyone one help my subreport appears twice in my report I have tried to fix it so it appreas once when I do this and save it it keeps on comming back pls help anyone...

I am using crystal 2008

 

[IanWaterman]

Where have you placed SubReport.

If in Report header or footer it will appear once.

If in page or group header/footer could appear multiple times.

Ian

 

[tazibc]

Hi Ian,

I have a subreport placed in RHk and RHL for eaxample I have suppressed each section in my subreport using this formula isnull({Weekday_Hub_Data.Arrivals, Vehicle Route ID})and
isnull ({Weekday_Hub_Data.Late Number Notified Y/N}) and
isnull ({@PDT})and
isnull ({@ADT})and
isnull ({@ATA})and
isnull ({@PTA})and
isnull({Weekday_Hub_Data.Late Trunk, Inbound/Outbound}) and
isnull({Weekday_Hub_Data.Late Trunk, (Free Text) Comment?})and
isnull({Weekday_Hub_Data.Late Trunk, Reason Code})and
isnull({Weekday_Hub_Data.Late Trunk, Impact})and
isnull({Weekday_Hub_Data.Late Trunk, Responsibility});

so effectively if there is no data the sections will not show. I did this because the suppress if no data in format subreport did not work for me. The problem is I keep geeting my subreport in RHK and RHL keep appearing twice is there something that I can do to show this report once per report pls help.

The thing is when I appear to fix it and it shows it once per report I save it and reopen the report and the subreport comes back twice again its killing me

 

[dgillz]

Why did you place the subreport in 2 different sections?

I know you are conditionally suppressing the sections, but we have no idea what the values of those fields are, let alone the referenced formulas in the suppression formula.

Is the suppression formula working? It is actually supressing one of these 2 sections in all cases? If the answer is no, its not the subreport, it is the suppression formula. As I said, the

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

Why did you place the subreport in 2 different sections?

I know you are conditionally suppressing the sections, but we have no idea what the values of those fields are, let alone the referenced formulas in the suppression formula.

Is the suppression formula working? It is actually supressing one of these 2 sections in all cases? If the answer is no, its not the subreport, it is the suppression formula. As I said, there is no way we can debug this without more info.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[lbass]

Please do not create multiple threads on the same topic.

-LB