Question
Cognizant
IN
Last activity: 26 May 2017 7:19 EDT
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?.
Pegasystems Inc.
IN
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?
Cognizant
IN
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>> ]
Pegasystems Inc.
US
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?
Cognizant
IN
Yes on Run Immediately and in addition on the every mail attachment from Scheduler as well if we schedule it any time.
Pegasystems Inc.
US
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-information
https://pdn.pega.com/support-articles/exported-pdf-does-not-show-filter-information
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.
Cognizant
IN
The answer is helpful and this issue is fixed in P.7.2.x