topic Re: Power BI Paginated Report with One column only in Report Server

Power BI Paginated Report with One column only

Anonymous — Mon, 12 Aug 2024 22:32:55 GMT

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.

Re: Power BI Paginated Report with One column only

Anonymous — Tue, 13 Aug 2024 01:49:41 GMT

Hi, Anonymous

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.

Re: Power BI Paginated Report with One column only

Anonymous — Tue, 13 Aug 2024 13:05:37 GMT

Anonymous 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!

Re: Power BI Paginated Report with One column only

Anonymous — Tue, 13 Aug 2024 14:33:29 GMT

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!