Hi,
Reporting question again
(I consider reporting a very important part of the product).
We export reports to PDF, for example backup job history.
Problem: the number of records are limited in PDF , I think max 10k records.
For year reporting that’s a problem for us.
Is there a way to increase that limit?
Bart, is your requirement a wholesale dump of all that data? An honest question, who is really looking at a million records inside a report. Tell us more about the requirement, there are many ways to manipulate the data and provide what is required.
Who looks at it: auditors :)
The backup job summary report gives them the possibility to review if we did run all backups as foreseen. It’s even a legal requirement for some type of customers.
They won’t check all records, but they will look at random dates/times.
We have registry key to increase the limit. you can use maxRowsForHtmlPdfExport . Max value you can set for this key is 100k
oh, I had the setting configured already (years) ago, and I forgot about it.
Tnx!
btw, the option doesn’t work……….
btw, the option doesn’t work……….
@Bart , to confirm, the reg key didn’t work for you? I can unmark the Best Answer so we can keep assisting (just let me know).
To confirm, here are the full parameters for the older:
Key - MaxRowsForHtmlPdfExport
nder key - Webconsole
Type - Integer
min Value = -1
Max value = 100 000
I also found some detail from an older case stating that the html and pdf export has scale issues and it limited to 1000.
Let me talk to some folks internally and see if this key is still honored (the above incident was from 2017).
Hello Bart,
Additional setting MaxRowsForHtmlPdfExport is applicable only for web Job Summary report.
For Custom reports in CommandCenter or Webconsole, the limit is set to 10000.
https://documentation.commvault.com/11.22/essential/39321_exporting_and_saving_reports_on_web_console.html
If you need to view or process more than 10,000 rows of data, use CSV format. The CSV format has practically no row limit, while the PDF format and the HTML format cannot display more than 10,000 rows. Therefore, any report that you export to HTML or PDF format is limited to 10,000 rows of data.
Thanks,
Venkat
btw, the option doesn’t work……….
@Bart , to confirm, the reg key didn’t work for you? I can unmark the Best Answer so we can keep assisting (just let me know).
To confirm, here are the full parameters for the older:
Key - MaxRowsForHtmlPdfExport
nder key - Webconsole
Type - Integer
min Value = -1
Max value = 100 000
I also found some detail from an older case stating that the html and pdf export has scale issues and it limited to 1000.
Let me talk to some folks internally and see if this key is still honored (the above incident was from 2017).
indeed, that didn’t work. I had it set already from a case a couple of years ago. I increased that, but the report didn’t change.
Hey @Bart , following up to see if you saw @Jupalli ‘s response. Let me know if that answers your concern and I’ll adjust the Best Answer for you.
Thanks!