Unable to remove header rows for excel export of report definition
Hello,
Our customer asked to remove the 2 rows of the header "Report Name" and "Filter Condition" during export of Excels Reports, but not while visualizing the report.
After many tries on report configuration, I wasn't able the completely remove those 2 rows yet.
The way I found is to customize the HTML rule "pzListViewExcelData", skipping the lines in which it appends those informations inside a <tr> row. Unluckily, this is a final version rule.
How can we request to get a "non-final" version of this rule? Or is there an OOTB way to get this requirement satisfied?
Our Pega version is 7.1.9
Thanks in advance,
Marco
Pegasystems Inc.
US
I don't think we have a solution for you. The checkbox to hide the filters will also hide the filters are runtime, so that sounds like it will not work for you. Even if it did, to make matters worse, there is a defect in some releases where, when you disable and hide the filters, it also hides the title as well. (It was not intended to do both).
Ironically enough, it sounds like with that defect in place, it's the behavior you're looking for. But ultimately still will not help you since it will affect the runtime display as well, and not just for exporting.
Reference this SA for more details.
https://pdn.pega.com/support-articles/unable-hide-report-filters-export-excel
Accenture SPA
IT
Hi Rett_Hean_GC,
first of all, thanks a lot for the answer.
As in previous message, I made a really simple change in the code of HTML rule "pzListViewExcelData" in a private ruleset which is perfectly doing my job.
There were already some conditions to skip inserting the header' <TR> rows; the only thing I did is to replace those conditions related to the "IF" statement with a "true", so they are always skipped.
Isn't there any way to get a "non-final" version of that rule in order to apply this change?
Pegasystems Inc.
US
Hi Marco,
No there is not a way to get a non-final version of this rule. The only way to get them modified is through HFixes. Even then, we will only HFix a rule if there is a defect to correct and a change that will not affect other customer's behavior [unless of course the change in behavior is to correct a defect].