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
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