?
Solved

SSRS "Jump to Report"

Posted on 2011-03-22
5
Medium Priority
?
376 Views
Last Modified: 2012-06-27
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
Comment
Question by:Gray5452
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 3

Accepted Solution

by:
Emenizer earned 2000 total points
ID: 35196825
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
 
LVL 3

Expert Comment

by:Emenizer
ID: 35196829
i.e. 'IIF'
Or, maybe even better, work with 'Switch' in the expression.
0
 

Author Comment

by:Gray5452
ID: 35198016
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 35452397
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question