Using Report URL within the Report

[rcymozart]

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

[Bruce L-C [MVP]]

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

"rcymozart" <rcym...@gmail.com> wrote in message
news:1118779730.0...@g43g2000cwa.googlegroups.com...

[rcymozart]

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

[Wayne Snyder]

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

"Bruce L-C [MVP]" <bruce_l...@hotmail.com> wrote in message
news:uSYOtCSc...@tk2msftngp13.phx.gbl...