Forum Discussion
'Go to report' Action tab is missing in report builder application
Super UserThe "go to Report" action is a Visual Studio feature as it lists other reports in the same project. Power BI Report Builder does not have the concept of projects. But at the end of the day 'go to report" was just variation of the "go to URL" option so you should be able to deploy your target report then copy it's URL and paste it into the "go to URL" option.
Anonymous wrote:
I would also like to refer to other tables within the same report if possible, whichever option gets me to the end result.
I think this is possibly handled by the "go to bookmark" option, but you have not described what you want the "end result" to be so it's hard to say for sure.
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".
- d_gosbell
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