sql server reporting services: Using Report URL within the Report -- sql server reporting services

You're in the

sql server reporting services

group:

Using Report URL within the Report

rcymozart
6/14/2005 1:08:50 PM

sql server reporting services:

I have a report that I need to check the actual URL to determine some
hyperlinks within the report. Reason being is that we have two
identical copies of a single report for security purposes. This report
have links that need to be different depending on where the report is.
Instead of having two copies of the same report, I'd like to code the
logic into the report itself.

Is there a way to do this:

IIF(Report.URL = "x", "a", "b")

???

The "Report.URL" part is what I'm looking for.

Thanks,

Robert

Re: Using Report URL within the Report

rcymozart
6/14/2005 1:53:29 PM

That's almost what I'm looking for. The Globals!ReportServerURL helps
a little. What I need is to say if the report is in folder "a" on the
server, make the URL to jump to "x", otherwise make the URL "y".

The above helps me construct a URL for the report by hand, but I need
to compare it to the URL of the report itself.

Further scanning the Globals variables that your post pointed out to
me, it looks like Globals!ReportFolder is what I need. I'll test that
and see if it does the trick.

Thanks,

Robert

Re: Using Report URL within the Report

Bruce L-C [MVP]
6/14/2005 3:35:59 PM

You want to use the jump to URL (right click on field or textbox or
whatever, properties, advanced properties, navigation tab).

=Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" &
Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value

For your case you would have everything after the equal sign twice,
modifying it appropriately.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Using Report URL within the Report

Wayne Snyder
6/14/2005 7:33:48 PM

Take a look at the Instr function to see if 'a' is in the ReportServerURL,
nest this within and IIF

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn