The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Is it possible to create a paginated report in Power BI Report Builder with only one column only? The report will look like a form that needs to be printed. A sample of what it would like is below:
There are a lot of fields and go beyond one page. I am also having issues with adding page break. Do I need to use a List?
Thank you.
Solved! Go to Solution.
Hi, @npine
According to your description, I use the following data set to create the form in your description:
Add our data set in the Report builder:
We can add a custom table:
In the table definition, enter the name of the first column:
In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:
We run our paginated report and see the following results:
Another problem you mentioned is that you have too many fields and it exceeds one page. Then you can consider the following two methods:
Reduce the fields used in the custom table
Add a parameter filter. This is the most common method. The following demonstrates the use of this method:
First, add a parameter dataset, which contains the fields we need to add as parameters:
Bind this parameter to our dataset1 to complete the filtering effect:
The results are as follows:
The above are the methods that can be implemented currently.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think the table with rows might be a challenge since the output I'm looking for needs to print with no repeating values e.g. names, salespersonid etc.. When previewed it should only show something like below:
For what I am working on there are more field names that need to be added that's why it goes over one page. It's really like a printout of a form that I'm trying to achieve. Apologies if I was not clear enough with my problem description.
Thank you again for your response and help!
Hi, @npine
According to your description, I use the following data set to create the form in your description:
Add our data set in the Report builder:
We can add a custom table:
In the table definition, enter the name of the first column:
In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:
We run our paginated report and see the following results:
Another problem you mentioned is that you have too many fields and it exceeds one page. Then you can consider the following two methods:
Reduce the fields used in the custom table
Add a parameter filter. This is the most common method. The following demonstrates the use of this method:
First, add a parameter dataset, which contains the fields we need to add as parameters:
Bind this parameter to our dataset1 to complete the filtering effect:
The results are as follows:
The above are the methods that can be implemented currently.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-jianpeng-msft Thank you so much for the help! I initially started with a table and tried to add a row at the bottom but it did not insert the row proplery like yours did. With your screenschots and description I was able to add row below within group in the right order. Thank you!
I do have a parameter, several actually. Even with filter the output still goes beyond one page and it cuts off where the page ends and starts on the next page. How can I insert a page break?
Thank you so much again!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.