Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PDF Publisher - To multiple email IDs with different data

Hi All,

We have requirement to generate a PDF (using Publisher) and send the details to the respective managers with their reportees.Sample  data given below . Manager Wise and then each page containing the details of the employee. Details of the report given below

Employee Name

Manager

Time Booked in Hours

ManagerEmail ID

Arun

Suresh

100

xys@com

Sinu

Suresh

120

xys@com

Vikas

Raman

90

abc@com

Som

Raman

80

abc@com

We want to send the details for Manager Suresh the below details  to his email id xys@com

FirstPage

Employee Name

Manager

Time Booked in Hours

ManagerEmail ID

Arun

Suresh

100

xys@com

Sinu

Suresh

120

xys@com

Second Page (Employee Wise)

Arun

Suresh

100

xys@com

   

Third Page (Employee Wise)

Sinu

Suresh

120

xys@com

 


and for Manager Manager Suresh the below details  to his email id abc@com

First Page

Employee Name

Manager

Time Booked in Hours

ManagerEmail ID

Vikas

Raman

90

abc@com

Som

Raman

80

abc@com

Second Page (Employee Wise)

Vikas

Raman

90

abc@com

Third Page (Employee Wise)

Som

Raman

80

abc@com

Please let us know if you need any more information.


Thanks,
Sijo Joseph

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi

For this you have to create two reports

1) Normal report as it is while distribution distribute it via Loop and reduce in manager field.

2) create same report as above then go to page and page setting then banding click on loop page over possible value and select here employee name. While distributing just distribute this report via loop and reduce in manager filed.

hope it help.

Regards

ASHFAQ

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

Hi

For this you have to create two reports

1) Normal report as it is while distribution distribute it via Loop and reduce in manager field.

2) create same report as above then go to page and page setting then banding click on loop page over possible value and select here employee name. While distributing just distribute this report via loop and reduce in manager filed.

hope it help.

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Thanks for details and it is working fine in our sample dashboard.

We have implemented the same code in our original dashboard and it is running for more than two and half hours and it is making our QMC to fail.

Is there any code correction/or any other thing we neeed to take care.

Thanks,

Sijo Joseph

ashfaq_haseeb
Champion III
Champion III

Hi,

How many rows do you have?

I mean employee and manger roughly.

can you post document or task logs to analyze it further.

Regards

ASHFAQ

Not applicable
Author

Hi,

Is is having 75000 employees and  160 managers.

I have tried by selecting one employee and run the job to PDF  generation, still it is conitinuing to run (over 30 mins).

I will upload the logs as soons it fails or complete the job.

Thanks.

Sijo Joseph

ashfaq_haseeb
Champion III
Champion III

Hi,

This is huge I'm not sure will this work.

It has to generate 7500 pages.

Just to know do you have PDF distributor licence with you?

you can check the same by going to Licence tab and select QlikView  publisher.

and make sure below line is available in your LEF content

PDF_GENERATION;YES;;

Regards

ASHFAQ

Not applicable
Author

Hi,

I have checked and we are having the PDF_GENERATION;YES;;

I have selected one employee and run the report directly from the dashboard and it working fine with one employee. I have saved the dashboard with the selection and run the job. But still it is not completing even after long time.

I believe this has to work faster as only one employee has selected. Do you think is there any thing we are missing?

Thanks,

Sijo Joseph

ashfaq_haseeb
Champion III
Champion III

Hi your saved selection will not work here.

I believe you have to open document while distributing document in QEMC and select one employee.

Regards

ASHFAQ

Not applicable
Author

Thanks Ashfaq.

I have made the selection inside the QMC and it has worked fine.

ashfaq_haseeb
Champion III
Champion III

Hi for this type of heavy reporting.

I would recommend you to go with NPrinting.

Regards

ASHFAQ