subreports
3 TopicsIdeas for adding headers and footers to subreports in Power BI Paginated
Hello, As far as I know, by design it is not possible to display headers and footers of the subreports in the main report in Power BI Paginated Report builder. I need to display different footer and header information on each page based on the subreport which is being shown on this page ( the order and number of the displayed subreports can change, since we use multi-value parameters to select reports for viewing). Any ideas how this can be achieved? Maybe it is possible to pass the information on which subreport is currently being displayed to the header/footer and then use it to show/hide the needed text? Will appreciate any ideas!1.7KViews0likes4CommentsCannot connect subReport in Power Bi Report Builder
I have 2 files of Power Bi Report Builder. One of them is the main report and another one is a subreport to the main one. Both files use the same datasource. I put them in same location in my local drive but I cannot connect subreport to the main one. Any ideas or suggestions for this? I tried to check but nothing solves the problem277Views0likes0Commentserror running a paginated report with subreports in the on-premise reportViewer.aspx control
Power BI Report server version: Version 1.3.6816.37243 (August 2018) I have a paginated SSRS report that reads the report server database's catalog in order to list reports available to be run. When a user clicks a row the action for the textbox uses this piece of code to show the report in the Catalog.Path in the server's reportViewer: =Globals!ReportServerUrl + "/ReportServer/Pages/ReportViewer.aspx?%20" + Fields!Path.Value + "&rs:Command=Render" This works great for all standard paginated reports. But, I just created one with a subreport and it is throwing the following error: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.UriFormatException: Invalid URI: A Dos path must be rooted, for example, 'c:\'. I can run the report by directly clicking it on the report server, but when it is run through the reportViewer.aspx control it fails. Any ideas?Solved1.7KViews0likes2Comments