Stuck on Drill Downs, please help. -- sql server reporting services

BLAW
9/30/2007 12:00:00 AM

I have two reports that I created, one using the wizard which simply
has some Account Name, Parent Account and Opportunity Revenue. I'll
call this the Report #1. I want a user to be able to click one of the
Account Names and have it open a second report that lists details on
the opportunity. I'll call this the drill down Report #2. Sounds
simply and I know "just add a parameter value" is the answer but I am
lost in what parts each specific report needs to have.

Report #1
Account Name
Parent Account Name
Expected Revenue

Report #2
Account Name
Parent Account Name
Expected Revenue
Other details on the report

QUESTION #1: I am a beginner, but lost. Does the Report #1 need to
have a Report Parameter and pass it to Report #2, or does the Report
#2 only need the parameter... or do both?

QUESTION#2: Assuming Report #2 need to accept a report parameter value
in order to display the correct data, does it need a filter as well?

I'll likely have more questions, I'm just stuck on a few things.

Jeje
9/30/2007 12:00:00 AM

the second report will have 1 parameter "Account Name"
this parameter will be used in the SQL query to filter the rows from the
database for the selected account only.

now the report 1... you go in the navigation property page of the object
where the end user will click to drill
select the report 2 as the destination, open the parameters mapping and type
the name of the parameter creating in the step 1 and associate it to the
account name field of the report 1.

and it's all. the target report is not a parameter (could be but you don't
need it for the moment)
when the user see the report 1 and click, the report 2 is opened and
filtered to the right account name

take a look at the adventure works samples to see how to do this.

[quoted text, click to view]

BLAW
9/30/2007 5:36:00 PM

Thanks Jeje, as soon as I get through a couple of tasks, I'll be right
on it.

BLAW
10/1/2007 12:00:00 AM

Is there any special field placements on the 2nd report I need to do,
in other words how does the 2nd report know which field to filter on?
I am using VS2005 and I have added a parameter that appears at the top
of the preview tab, but when I actually select an Account Name it does
not filter the report? Does the report have to be published?

BLAW
10/1/2007 12:00:00 AM

Publishing does not do it, when I select the Account Name using the
parameter filter I still get all of my Opportunities and all Accounts
in view.

Mike G.
10/1/2007 3:38:51 PM

Sounds like you may want to read up on the differences between a report
parameter (which it sounds like you're using) and a query parameter (which
it sounds like you're not using):

http://msdn2.microsoft.com/en-us/library/aa337287.aspx
and
http://msdn2.microsoft.com/en-us/library/aa337223.aspx

Report params allow the user to pass in data to the report. Query params are
what's used to drive the filter against the database...

Mike G.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Stuck on Drill Downs, please help.