x

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 '11 at 03:09 AM in Default

Mrs_Fatherjack gravatar image

Mrs_Fatherjack
4.7k 57 62 66

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 '11 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 '11 at 03:28 AM Mrs_Fatherjack
so the asp page is expecting parameters ... do you know what they are named?
Oct 18 '11 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 '11 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

http://urlpart/urlpart/mypage.asp?UName=Jack&City=London

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 '11 at 05:28 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

That's brilliant, thank you.
Oct 18 '11 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x535
x3

asked: Oct 18 '11 at 03:09 AM

Seen: 881 times

Last Updated: Oct 18 '11 at 03:32 AM