Paginated Report Issue

prashanthjjk — Thu, 20 Jun 2024 17:36:24 GMT

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?

Re: Paginated Report Issue

Anonymous — Fri, 21 Jun 2024 02:38:35 GMT

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 Builder | Microsoft Learn

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 Builder | Microsoft Learn

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.

topic Re: Paginated Report Issue in Report Server

Paginated Report Issue

Re: Paginated Report Issue