Using Report URL within the Report

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
Tue Jun 14 15:35:59 CDT 2005

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" <rcymozart@gmail.com> wrote in message
news:1118779730.006507.111630@g43g2000cwa.googlegroups.com...
>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
>

rcymozart
Tue Jun 14 15:53:29 CDT 2005

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
Tue Jun 14 18:33:48 CDT 2005

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_lcNOSPAM@hotmail.com> wrote in message
news:uSYOtCScFHA.2756@tk2msftngp13.phx.gbl...
> 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" <rcymozart@gmail.com> wrote in message
> news:1118779730.006507.111630@g43g2000cwa.googlegroups.com...
>>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
>>
>
>