Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
From a report report created within QlikView, using the QlikView publisher it can be generated as pdf using QEMC.
However as an example if a Table in the report has no data, we do not want to generate the PDF and send it to users. We only want to generate the PDF if there is data in some table.
Please advise how this could be achieved.
Regards,
Santosh
Santosh, we faced a similar situation and what we did is we removed users that did not had any data from the field in the application that had the users to send the reports to.
Hope that helps.
Thanks Daniel for the response. Your solution should help us. Could you please clarify on the below to apply this solution
- How is the user list controlled, is it through section access?.
- If not, please advise how the user list is configured in Management Console?
Rajendra
User list is in the QVW file.
Thanks again Daniel,
Could you please elaborate further on this. How the user list is loaded and then the same list is associated in the distribution list in QEMC. In our case, the users for whom the pdf is generated are not part of the data.
Just use the loop field in document function to distribute.
Daniel,
Below are steps followed:
In the qvw file:
1. Created an inline table with user_name and email_id columns (in lower case)
2. This table would get populated based on the condition (currently records are available for use in loop and distribute). That is if this table is empty, non of the users will be provided with the pdf.
Now on QEMC, the settings are as below:
1. Distribute->Loop Field in Document->Loop and Distribute
Field containing recipient information: 'email_id'
Check user identity on: EmailAddress
2. Destination->Target type: E-mail is checked
3. FileType -> Output Document Type -> PDF report from source document: selected 'Report name create in qvw file'
4. Notify-> Notification E-mail -> Send notification e-mail to recipients is checked.
Is there any step which I am missing as the pdf are not generated with the Loop Field in Document option
As per the log below is the warning: email id assigned in the inline table is a valid one.
Warning: Dynamic distribution returned no recipients using "EmailAddress" using parameter "UserEmailID".
I believe the solution is now working, As the distribution was of a different task which was reloading the data again was clearing the user list from the inline table. Thereby, pdf files were not generated.
Thanks for your help. You response was very helpful in resolving the issue.