Forum Discussion
'Go to report' Action tab is missing in report builder application
I've updated my message with what my end result needs to do.
Summary of what I have:
I have a Data Summary Table in a paginated report, within that summary table I have a field labeled "Assigned Group". I want to make this field have an action where I can click on it and it will Drill down to all this items in another table with the "Assigned Group".
Anonymous wrote:
I have a Data Summary Table in a paginated report, within that summary table I have a field labeled "Assigned Group". I want to make this field have an action where I can click on it and it will Drill down to all this items in another table with the "Assigned Group".
So this sounds like a scenario that would work best by having 2 reports a summary report and a detail report. You could then setup a parameter in your detail report that accepts an "Assigned Group" as a value to filter that report. Then in the summary report you would setup a "Go to URL" action and use the fx button to create an expression that would combine the URL of the detailed report with the value of the "Assigned Group" from the current row in the summary report.
If you are using the Power BI Service you can find information on passing parameters in the URL here:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-parameters
If you are using the on-prem Report Server the way you pass parameters is slightly different. see:
https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver15