• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

SSRS "Jump to Report"

I have a dataset that returns 4 media channels that I need to be able to drill into....So:

Channel1
Channel2
Channel3
Channel4

will each b sitting there underlined ready to have ther subreport shown,,,

how do I go to one of four reports based on which of the four valuse the user chooses..I can't just put a 'jump to report' on the text box in the tablix object bc it could be 1 of 4 reports...

Love you guys and gals and feel free to ask for clarifacation if i am not clear...

Peace, Gray

0
Gray5452
Asked:
Gray5452
  • 2
1 Solution
 
EmenizerCommented:
Depending on how many types of Channels you have (limited amount or variable) you could go for 'jump to report' with an expression OR in case of a lot of channels / variable amount of channels: make the jump to report table driven.
The first one will be to most straight forward.
In the expression you can work with if-else statements and jump to the correct report according to the channel.
0
 
EmenizerCommented:
i.e. 'IIF'
Or, maybe even better, work with 'Switch' in the expression.
0
 
Gray5452Author Commented:
Thanks Emenizer, its 4 stations so a Case statement would be ideal and I've considered a very-nested IIF scenario...Is a Case statemnt available in expression lingo?
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now