Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subreport appears twice on my report

Status
Not open for further replies.

tazibc

Instructor
Oct 5, 2007
66
GB
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
 
If you place it in two sections, it will appear twice. The question then is why you think it will not--you haven't explained that to us.

-LB
 
If your Crystal version is 9 or above, you can use the 'suppress if blank' option in the main-report section.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Ibass sorry I need to clarify that the sub report in RHk and RHL are differnt reports all together and not the same subreport. The report in these headers keep on appearing twice on page 1 and page 2
 
Have you verified that you have the reports placed in Report Header sections and NOT in page header or group header sections? Otherwise, since the report headers only execute once, I would guess that your report has become corrupted. I would try adding them to a new report and see if the problem is corrected.

I am unclear why the subreport would be blank or how the suppression of a blank subreport is related to the issue of multiple displays.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top