x
login about faq Site discussion (meta-askssc)

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.6k 44 52 60

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 ♦♦
38.8k 55 69 104

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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1601
x486
x2

asked: Oct 18 '11 at 03:09 AM

Seen: 607 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.