Forum Discussion
Report Builder page break on parameter
Hello,
I've embeded a paginated report made in Report Builder in a Power BI report.
I call the page with the Report Builder from a table of values in another page: right clic on a line, extract to the report builder embeded sheet, the client id of the line is passed, and everything is just fine.
The need is finally not to pass one client ref, but a list of ref = all visible lines from the table is the list of clients I have to pass to the report builder page (the table can be filtered, when user have his filter OK, he wants to have them on the report builder paginated report)
I have two problems, haven't found a solution so I write for help:
1) how can I send multiple lines from a table as a parameter? = send multiple client ID so the report builder creates one page per client? I've tried control-clic to select the lines, but then the extract option disappears. Can we maybe add some checkboxes on the table?? Or maybe I have to apply the filters of the table on the power BI page?
2) My paginated report has several datasets. Let's say that I want to list the name of client's kids, and the list of purchase of this client in my store. So I have 2 separate datasets: one for kids, one for purchase. How can I page break after these two info for each client? using a list to page break works for one dataset, but I need two. Any ideas?
Many thanks, regards,
Marge
Hi Anonymous ,
1.For viewing a report with parameters, refer to Report parameters in Power BI Report Builder - Power BI | Microsoft Docs.
2.The page break includes the following properties:
-
BreakLocation provides the location of the break for the page break enabled report element: at the start, end, or start and end. On groups, BreakLocation can be located between groups.
-
Disabled indicates whether a page break is applied to the report element. If this property evaluates to True, the page break is ignored. This property is used to dynamically disable page breaks based on expressions when the report is run.
-
ResetPageNumber indicates whether the page number should be reset to 1 when a page break occurs. If this property evaluates to True, the page number is reset.
You can add a page breaks to data regions, to rectangles or to a table or to a group of rows in a matrix or list. Please refer to Add a page break to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Docs.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
1 Reply
Hi Anonymous ,
1.For viewing a report with parameters, refer to Report parameters in Power BI Report Builder - Power BI | Microsoft Docs.
2.The page break includes the following properties:
-
BreakLocation provides the location of the break for the page break enabled report element: at the start, end, or start and end. On groups, BreakLocation can be located between groups.
-
Disabled indicates whether a page break is applied to the report element. If this property evaluates to True, the page break is ignored. This property is used to dynamically disable page breaks based on expressions when the report is run.
-
ResetPageNumber indicates whether the page number should be reset to 1 when a page break occurs. If this property evaluates to True, the page number is reset.
You can add a page breaks to data regions, to rectangles or to a table or to a group of rows in a matrix or list. Please refer to Add a page break to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Docs.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-