Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are having an issue with reports (700+) being generated and sent to all of the users in a group as a zip file. Most of these reports are blank, excluding the header row. The group of individuals is about 16 users and their reports are the only ones with actual data. Those users all have filters assigned to them so they should only receive their individual report as an Excel file. I've been trying to solution this for several months now.
REPORT:
-Cycle on Sales Person's Name (Field)
-No filters
TASK:
-Report selected
-No filters
-Group of users (each user has a filter of the field with their name)
-Email with 'Selected Users' as the email to and 'Selected Attachments' as the attachment
Hi, I tried to replicate your issue and I couldn't. It works for me as expected, which leads me to the conclusion that you are setting something wrong up.
Here are the steps to replicate what I have done and I believe this is what you are trying to do. (screenshots done only for NPrinting settings)
Now - this is the logic you seem to follow but somewhere on the way you are doing something different. I suggest you recreate this easy sample and see the results. If you get different results you may want to post them here with screenshots of your steps. Pay attention to all small details
My screenshots were taken on April 2020 version but November 2019 will work the same with this scenario.
Questions:
If there are other scenarios in your workflow I suggest you use it the sample data to recreate is and share it here. It is much easier to work with dummy than speculate on the real data.
cheers
Lech
Hi, I tried to replicate your issue and I couldn't. It works for me as expected, which leads me to the conclusion that you are setting something wrong up.
Here are the steps to replicate what I have done and I believe this is what you are trying to do. (screenshots done only for NPrinting settings)
Now - this is the logic you seem to follow but somewhere on the way you are doing something different. I suggest you recreate this easy sample and see the results. If you get different results you may want to post them here with screenshots of your steps. Pay attention to all small details
My screenshots were taken on April 2020 version but November 2019 will work the same with this scenario.
Questions:
If there are other scenarios in your workflow I suggest you use it the sample data to recreate is and share it here. It is much easier to work with dummy than speculate on the real data.
cheers
Lech
Yesterday I completely rebuilt everything and found the issue. The user filter was not working at all. Therefore an individual would receive all of the reports, not just theirs. I had rebuilt the report and task previously, but not the filter.
Question: @Lech_Miszkiewicz is there a way to have the Excel (or other file type) sent as just the file vs a .zip?
Hi,
With "Enable cycle option on" the only output you can get at the moment is .zip.
This is however known limitation and I hope Qlik will bring in possibility of changing it so the bundle of reports gets sent as actual individual files (not a zip bundle).