question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

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
sql-server-2008ssrsurl
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
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.
0 Likes 0 ·
so the asp page is expecting parameters ... do you know what they are named?
0 Likes 0 ·
Again, the page hasn't actually been created yet, I'm just trying to get my head round the 'how to' at the mo.
0 Likes 0 ·

1 Answer

·
Fatherjack avatar image
Fatherjack answered
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`
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

That's brilliant, thank you.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.