To add a report drillthrough action to your report

Question

To add a report drillthrough action to your report

tuktukg

SSC Enthusiast

Points: 139
More actions
June 5, 2015 at 10:53 am

#298735

Hey there,
I have a Supervisor report with a tablix that shows details for a supervisors list of agents. i've created column with a "go to Agent Report"
I've create the Agent Report which contains a pAgent parameter. How do i set the action to pass the Agent Name from the tablix on the Sup reprot to be the pAgent on the parameter?
Please let me know if you need more data. I appreciate the help.
T

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

If you're using text box properties > action > go to report you have the option to include parameters.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

tuktukg SSC Enthusiast Points: 139 More actions · Answer 2

gotcha.....but how do i set the parameter to be the correct agentname on that row then pass it to the agent report?

T

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

tuktukg (6/5/2015)
gotcha.....but how do i set the parameter to be the correct agentname on that row then pass it to the agent report?
T

Perhaps I'm missing your question and don't have SSRS handy to provide an example but it should be pretty simple.

Say your report is returning a column that has the field value [agentname]. You click on that field and set the action to "Open new report". Then, while still in the Action window, you point to a report that accepts a parameter called @agentname. You then set the Action to go to that report. In the Action window you click "Add Parameter". You set the name @agentname and, for the value, you add [agentname] (the square brackets represent the name of a field).

If a user runs that report they'll see the names, "Sally Smith", "John Brown", "Jerry Jones"... When they click the row containing "Sally Smith" it will pass that as the value of @agentname to your other report.

hmmmmm.... perhaps this is what you are trying to figure out....

Because there can be more than one agent with the same name you may want to pass a unique identifier, say AgentID (oor whatever your primary key is named) but you don't want it to appear in the report as a column. You could include AgentID as a column but make the column hidden. The user wont see it but it's still included and is available to add as a field for the value of your parameter. Then when the user selects "Sally Smith" it will pass the @AgentID for her. In this case you would have to have your sub report accept @AgentID and build your logic around that.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001