Year To Date / Month To Date Subreports - how to hide when no data in?

[StevenK]

I've set up a report to detail Month-To-Date and Year-To-Date purchase order lines against a selected range of suppliers.
In my main report I show the details against the supplier - I then have two subreports. The first subreport has two parameters for MonthStartDate and MonthEndDate which lists the purchase lines for the month's date range as indicated.
The second subreport has two parameters for YearStartDate and YearEndDate which lists the purchase lines for the year's date range as indicated.
This all seems to work well (with the main report and two subreports being linked through supplier ID such that against each supplier we get details of purchase lines for the current month and year to date).
My problem arises that there are some old supplier details on file and this results in some supplier details being output where there are no relevent month-to-date and/or year-to-date purchase lines.

How can I only output those suppliers where I have data in both of the associated subreports ?

I don't want details of suppliers that have no purchase details against them.

The two subreports are in separate detail sections - can these be suppressed if there is no data in the subreports ?
Thus far, I've made the bands as small (height wise) as possible.

Can I suppress the details in the main report (supplier details) when there is no data in the two subreports ?

Any help / pointers would be appreciated.

Thanks in advance
Steve

 

[Madawc]

You can't directly suppres a subreport based on the output of that subreport. Crystal's unbreakable processing sequence makes decisions about section suppression before it performs any subreports the section may contain.

There is a work-round, details at thread782-477236 I think it would apply to your problem, which is a little more complex but not different in kind.

Madawc Williams
East Anglia
Great Britain