Paginated Report Issue

[prashanthjjk]

Hi, 

I am using a powerbi data source to build a paginated report but Paginated report is omitting few blank rows(ones which has incomplete data in a row) but it looks fine in powerbi report with both blanks and non blanks.

Paginated report is only considering complete data in a row but not all the records

Any solution for this?

[Anonymous · Accepted solution]

Hi @prashanthjjk 

The following is for your reference:

If null values or null fields are displayed in the chart of a paged report, the chart may not behave as expected. Null values are handled differently depending on the chart type.

• If the chart type is a linear chart type, null values are displayed as spaces or "gaps" in the chart. To display null values, you must add a null placeholder. For more details, you can read related document link: Add empty points to a chart in a paginated report - Microsoft Report Builder & Power BI Report Build...

• If the chart type is a non-linear chart type, such as polar, pie, doughnut, funnel, or pyramid charts, the null value will be omitted from the display on the chart. 

• If the chart type is a shape chart, the null value is omitted.

For more details, you can read related document link: Empty and null data points in paginated report charts - Microsoft Report Builder & Power BI Report B...

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.