Solved

SSRS "Jump to Report"

Posted on 2011-03-22
5
364 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now