Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruchi_yahoo
Starting Member
5 Posts |
 Posted - 2010-10-12 : 06:02:35
|
| How to jump url conditionally in Reporting Services .I am using more then one Report and give link of one report in another but in many cases i want to skip one report but in other case i nedd this report .How to conditionaly jump url................ Plz Help Me.I m using sql server 2005 |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2010-10-12 : 11:49:24
|
| Your question isn't overly clear but if you're asking what I think you're asking then you want to link to one of a number or reports from within a 'master' report and whuich report you go to is based on the data. You can do this by building your url in your SQL code.This is the sort of thing you'd use to build a url:href="http://pbsnet/ReportServer?%2fFoldername%2fReportname&Parametername=' + fieldname + ' &rs%3aClearSession=true&rs%3aFormat=HTML4.0&rs%3aCommand=Render&rc%3aArea=Report&rc%3aLinkTarget=_top&rc%3aJavaScript=True&rc%3aToolbar=True&rc%3aParameters=FalseSo you can just use a CASE statement to build tyhe URL you need to use.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 03:15:50
|
| you can add an expression in jump to url property like below=IIF(yourcondition,first report url,second report url)if you dont want to navigate to report at all in any condition give Nothing instead of URL------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Reporting Services