Question
Excel from Scheduler with Filter Criteria as "None"
Hi,
I have scheduled a report in report broser which has some filter criteria in that. While getting a mail with Excel attachment, in that attached Excel, Filters are always displayed as "None"
Do someone help me in getting out of this issue?.
Using Version: 7.1.6
When I try to export it manually, it is bringing up Filters with Value which I have given in the report as shown [Filters: <<SomeValueAppliedInFilter>> ]
Are the results of the exported report actually filtered? I.e., is it just the report header that says "Filters: None"?
Does this happen when you execute the scheduled task for the report from the DesignerStudio>Reporting>Components>Scheduled Tasks landing page?
Yes on Run Immediately and in addition on the every mail attachment from Scheduler as well if we schedule it any time.
There are a couple of support articles about the same issue when exporting to PDF, for different versions:
https://pdn.pega.com/support-articles/exported-pdf-not-showing-filter-i…
https://pdn.pega.com/support-articles/exported-pdf-does-not-show-filter…
I believe the wrapper activity that is at issue also applies to Excel, so there's a good chance this patch would fix your issue as well. If neither of the versions (7.1.7, 7.1.8) apply to you, you will need to make a support request to have the patch ported.
The answer is helpful and this issue is fixed in P.7.2.x
Hello,
It is similar to exporting excel, the same file will be attached to the email when scheduled. Can you check what does it show, when you do an export to excel manually?
Which version of Pega are you using?