Data formatting in One Identity Reports

Hello everyone, I have designed a report where I am extracting data from the Person table based upon a SQL query and subscribed that report via IT shop in XLSX format.

Everything is working fine except the way data is being displayed in the excel report.


Initially I was getting header line after every 20 rows, then I found a way to remove it from the properties by changing "Print on" option to "Only first page". But the issue is now I am getting an empty row instead of that header line.

Is there any other option to remove the  repetitive header line?

Best regards,

Daniel

Parents Reply
  • Hi Markus,

    Setting unlimitedHeight to true just shrinks the blank row to the point where its hard to tell if there is any blank row unless you see the row count column.

    But still the blank row is there, is there any property just to make this header row  to appear only on the first page or we have to rely on these workarounds?

    Best regards,

    Daniel

Children