Report Consolidation

[pooja]

we have three individual reports with same propmts, same logic but just a
different in filter.Ex- Report_3months, Report_6months & Report_9months. we have
been asked to consolidate these 3-reports in one. please share some ideas how we should proceed.

thanks in advacne,

[Lynn]

Add a prompt control so the user can select 3 months, 6 months, or 9 months (e.g., value prompt with static choices).

Then modify the filter expression so it handles the selection along with the corresponding dates such as:

( ?TimeFrame? = '3 Months' and [ReportDate] between current_date and _add_months(current_date,3) )
or
( ?TimeFrame? = '6 Months' and [ReportDate] between current_date and _add_months(current_date,6) )
or
( ?TimeFrame? = '9 Months' and [ReportDate] between current_date and _add_months(current_date,9) )

[pooja]

here is ths situation:

these three reports has 2-prompts in common
1- start_date & end_date prompt &
2- dept_type prompt

only difference in month filter, where we have data item on each report;
[service_month] = 90_days
[service_month] = 180_days &
[service_month] = 270_days .

please share some ideas.


thanks again,

[Lynn]

Um, did you not care for my suggestion and are seeking other ideas or did you not understand how to apply it?

In case it is the latter, then create a prompt with static choices and name the parameter TimeFrame. The static choice use and display values can be the same: 3 Months, 6 Months and 9 Months. This should allow selection of a single value.

In order for one report to act three different ways then you must select which of the three ways it ought to be.

Modify the filter that looks at month as follows:

( ?TimeFrame? = '3 Months' and [service_month] = 90_days )
or
( ?TimeFrame? = '6 Months' and [service_month] = 180_days )
or
( ?TimeFrame? = '9 Months' and [service_month] = 270_days )

The filter should limit the data to the desired set because only one of the TimeFrame options is selected and only that part of the clause will evaluate to true, then the "real" filtering of service_month values comes along for the ride.

[MFGF]

Thanks Lynn.  Top advice! :)

[pooja]

Thank you So much, Lynn,
Its working PERFECT...

thanks again

[Lynn]

Great! Glad it worked out :)