I would like to use the MDX Sample reports as an example, and in particular
the FOODMART SALES report. As I view the report I select the
Product Family: DRINK , then the report is displayed and I click
Beverages >>> Drinks>> Flavoured Drinks that results with Excellent ,
Fabulous, etc..

I would like to click on Excellent or any one of the listed result set
under Flavoured Drinks to become the parameter for a URL based report that
would be generated based on the parameter passed as a result of clicking on
it. In other words If there is deployed report that lists all stored and
quantities sold, cost and profit of Brand Name we click on in the Food MArt
Sales report ( = Fields!Brand_Name.Value = "Excellent") flavoured drink.

What I am asking is exactly similar to the other Microsoft sample reports
that "TERITORY SALES" where clicking on lets say Territory:"Australia" >>
Sales Person: "Lynn Tsolias" >> CLICK ON Order Number: "SO5414" would
generated Sales Order detailed report of "SO5414"

Thanks in advance

--
Message posted via http://www.sqlmonster.com

If I understand what you want to do, this MSDN Paper has such a sample
report: "FoodmartDrillThrough", from which the "FoodmartDrilledTo"
report URL can be launched:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/olapasandrs.asp
...
Using the Reporting Services "Drill-through" Action
In the first example, we'll create a report action that is triggered
when a user selects a bar on a chart. The report for this example is
included in the file FoodmartDrillThrough.rdl. If you preview this
report, you'll find that the report contains a chart that displays the
sales for the selected product and time period for each city. If you
select any of the bars that represent the sales of a city, a report
action of type "drillthrough" is executed. This process opens the
FoodmartDrilledTo report that displays how each promotion contributed to
the overall sales of the selected product. The report parameters from
the initial report are passed to the second report and are displayed at
the top of the report for reference.

To see how this capability was added to the report, select the chart for
editing and right-click on the [Measures].[Unit Sales] data field.
Select the "Action" tab. This should indicate that the "Jump to Report"
property is set to the FoodmartDrilledTo report, and by viewing the
parameters option, you should notice that the "pTime" and "pProduct"
parameters of the second report are set to the value of the parameters
in the initial report. Finally, the last parameter listed, "pCity", is
set to the current value of the City field in the dataset.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Also the Reporting Services newsgroup is
microsoft.public.sqlserver.reportingsvcs
You might try over there.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"James Woo via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Thanks Deepak,
I already posted the same question on the RS group.
I will read the white paper, that you refered me to, hope it answers my
question.
James

--
Message posted via http://www.sqlmonster.com