This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 70%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
I am trying to pass a field value in one report to a parm value in another report using a url in the Action feature. The field on first report should be hyperlink. I test everything with values hard coded in the url and the second report runs with no problem. If I change the hard coded value to be the expression from the first report, the second report opens saying 'no data available'. The following is my url expression where the shopper code is the field defined as an expression:
https://myreporturl?rp:FromDimDate=2022-07-31&rp:ToDimDate=2022-12-31&rp:DimShopperCode=Lookup(Fields!Shopper_Code.Value &CStr(Fields!Date_BK.Value),Fields!Shopper_Code.Value & CStr(Fields!Date_BK.Value), Fields!Shopper_Code.Value, "Shopper_dataset")
Is this written correctly?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @142041
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya
Hi @142041
If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
Hi @142041
I tested that parameter values can only be specified values, expressions cannot be used.
For the use of passing parameters in a URL, you can check out this link: Pass a Report Parameter Within a URL.
Best regards,
Aniya
I have seen a lot of posts indicating that you can put expressions in the url to pass parameter values between reports. For some reason, I can't get this to work however. Thanks
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Hi @142041
I'm sorry I haven't tried to apply expressions to URLs, I searched briefly before and found no relevant cases, and the test was unsuccessful. I will continue the research and I would be very grateful if you could give me some cases.
Best regards,
Aniya
I have seen threads like this one indicating that it is possible to use expressions. Thanks
Hi @142041
I'm sorry I misunderstood what you mean, I thought you meant to use the expression when using the URL to access the report, but you mean to use "action->go to url" in the field attribute? The javascript statement is used in the link you gave. I don't know much about it.
But I think since you need to jump to another report, why not use "action->go to report"? This operation will make it easier to set parameters to run another report. You can see this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-hyperlink-to-a-url-report-builder-and-ssrs?view=sql-server-ver16#-add-drillthrough-to-another-report.
If the answer is helpful, please click "Accept Answer" and upvote it. If you have any questions, please feel free to let me know.
Best regards,
Aniya