topic Re: PDF Publisher - To multiple email IDs with different data in QlikView

PDF Publisher - To multiple email IDs with different data

Mon, 26 Jan 2026 18:19:17 GMT

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

abc@com

Third Page (Employee Wise)

Som

Raman

abc@com

Please let us know if you need any more information.

Thanks,
Sijo Joseph

Re: PDF Publisher - To multiple email IDs with different data

ashfaq_haseeb — Tue, 10 Jun 2014 08:03:38 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

Tue, 10 Jun 2014 08:49:05 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

ashfaq_haseeb — Tue, 10 Jun 2014 08:52:07 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

Tue, 10 Jun 2014 09:13:03 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

ashfaq_haseeb — Tue, 10 Jun 2014 09:32:22 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

Tue, 10 Jun 2014 09:40:35 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

ashfaq_haseeb — Tue, 10 Jun 2014 09:45:21 GMT

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

Re: PDF Publisher - To multiple email IDs with different data

Tue, 10 Jun 2014 11:32:27 GMT

Thanks Ashfaq.

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

Re: PDF Publisher - To multiple email IDs with different data

ashfaq_haseeb — Tue, 10 Jun 2014 11:34:53 GMT

Hi for this type of heavy reporting.

I would recommend you to go with NPrinting.

Regards

ASHFAQ