Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue with paginated report

Hi All,

 

I have a hierarchical style report build in report builder using grouping based on parent sector and child sector

 

I have child sector repeated I enabled the property

 

Now the repetition is turned off but I see empty row can someone please suggest how can we resolve the issue.

 

Thank you in advance

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Blank is generally considered a valid data row if it exists in your data.  In your visual's properties there is a section for filtering. Have you tried filtering blank/empty data records?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

       

      Thanks for the reply sorry if I am confusion the row is not a blank row as mentioned I have a child sector where the value Broadline Retail is being repeated for every Id so I wanted to merge and display once for all the Id's 

      After enabling the property Hide Duplicates now the Broadline Retail is merged and displayed once but I see a empty row instead of repetition.