Hyperlink from report through to .aspx page

Question

User375242171 posted

I have a report which consists of fields:
 
Productid   GenericName   BrandName   Cost    CurrentSP   Margin
34234         sdfgfd            sgsdfgdg

 

This report has been created in Report Builder 3. I want a user to be able to click on the ProductID in the report and then be transferred to the corresponding product details page within a .aspx page. I have attempted to put this url within the Action field in Text Box Properties.

http://phoenix/Webpages/Products/ProductsSummary.aspx?prodid=

However when i click the Hyperlink on the report its taking me to a listed page with the products rather than the specified page:

e.g.
http://phoenix/Webpages/Products/ProductsSummary.aspx?prodid=554

My collegue has developed the asp.net page. He has tried to use the code below to enable this tow work.but its just doing the same thing.

  If Session("productUniqueIdValue") <> "" Then
                hiddenProductUniqueIdLabel.Text = Session("productUniqueIdValue")
            Else
                hiddenProductUniqueIdLabel.Text = Request.QueryString("produniqueid")
            End If

 

Any idea to this solution. Thanks for your help in advance.

Regards

Answer 1

User191633014 posted

 

try:

hiddenProductUniqueIdLabel.Text = Request.QueryString("prodid")

Answer 2

User1471008070 posted

Hi,

Based on your information, I think we can achieve this requirement in report level, add an action of Go to URL to the ProductID textbox, to the expression please type in ="http://phoenix/Webpages/Products/ProductsSummary.aspx?prodid=" & Fields!ProductID.value

Note: Fields!ProductID.value is the field name in ProductID textbox.

You can get some reference from this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1f57ca89-430e-463b-a684-c95c1b8d70f6/ 

Thanks,
Challen Fu