Reporting Services passing in URL

I wonder if anyone can help me.

I have a need to link to a new web page from a reporting services 2008 report. I have added the URL so that the new window opens up fine, but I also need to pass in various parameters, eg. the Report Number and the Row Identifier, so that when data is changed in this new window it accurately updates the record that it was linked to in the report and I can't see how to do that when it's not linked to a report.

Please let me know if you need any further information.

Many thanks

more ▼

asked Oct 18, 2011 at 03:09 AM in Default

avatar image

5.3k 66 69 77

where is the target URL pointing - to a static html page, and asp page or another report?? Do you know what the URL needs to look like (IE what is the format of one that works?) You can set the function of the URL to be knownURL & paramValue & paramValue and it should work. It will get complex with the need to use TSQL to pass values to .net to build an HTTP URL so double single quotes and so on will look complex

Oct 18, 2011 at 03:14 AM Fatherjack ♦♦

To a static asp page. Currently don't know what the final form is going to look like, I'm trying to prototype a theory at the moment.

Oct 18, 2011 at 03:28 AM Mrs_Fatherjack

so the asp page is expecting parameters ... do you know what they are named?

Oct 18, 2011 at 03:55 AM Fatherjack ♦♦

Again, the page hasn't actually been created yet, I'm just trying to get my head round the 'how to' at the mo.

Oct 18, 2011 at 04:09 AM Mrs_Fatherjack
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

an asp page that has parameters that are passed in the URL will take the form of

eg say the page has a parameter of UName that is used to build a greating to the user and another of City to know what weather details to provide


You need to construct this within the expression that controls the URL using the .Net syntax. So, if you have the URL and parameter values from your datasource you might have to do something like

= URL.value & "?UName=" & UName.value & "&City=" & City.value

more ▼

answered Oct 18, 2011 at 05:28 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

That's brilliant, thank you.

Oct 18, 2011 at 05:51 AM Mrs_Fatherjack
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 18, 2011 at 03:09 AM

Seen: 1186 times

Last Updated: Oct 18, 2011 at 03:32 AM

Copyright 2018 Redgate Software. Privacy Policy