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
Solved

SSRS "Jump to Report"

Posted on 2011-03-22
5
369 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
  • 2
5 Comments
 
LVL 3

Accepted Solution

by:
Emenizer earned 500 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 100

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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS 2012 URL 11 66
SSRS Columns as Rows in a Table 14 53
SSRS report parameters set after publishing to report manager 1 63
SSRS - Date Report Options 2 27
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 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