Hyperlink to new report and passing filter criteria? 1

[MSIsam]

I have a requirement from our business partners that after a prompted report is run, that a there is a hyperlink to a new report. When the user clicks on the new report, the report is executed with the filter criteria for the original report.
Environment: MSI 7.2.4 (NO OLAP services)

For example:
Report A is a sales report (Grid) that prompts on Company and Month

User selects the AACME company for JANUARY and FEBRUARY

Report A results:

[B]Company  MONTH  SALES[/B]
AACME      JAN    100
AACME      FEB    200

This report would have a hyperlink somewhere/anywhere on it.

Clicking on the hyperlink would run Report B automatically with the company and month filters from report A applied.

Report B results:

[B]Division       Week  Inventory[/B]
AACME shirts        1       1000
AACME shirts        2       2000
AACME shirts        3       3000
AACME shirts        4       4000
AACME pants         1       1000
AACME pants         2       2000
AACME pants         3       3000
AACME pants         4       4000
[B][COLOR=red](SHOWN AS PIE CHART)[/B][/color]

I have done something sililar to this using Business Objects and would like to know how it can be done using MSI 7.2.4. I used hyperlinks here for an example but the solution just needs to meet the requirement - run report B (or C, D, etc.) with user defined filter criteria from report A.

Any help would be greatly appreciated

 

[sunnyphoenixier]

Have you considered using drill to template option? It will allow you to keep the same filter/prompt selections with another totally different set of metrics.

Let me know if you think this may work for you and you need further information.

Phoenixier

 

[MSIsam]

Thanks sunnyphoenixier,
I was not familiar with this option. It obviously looks like a good fit and I will research.

Thanks Again