Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |
Sinu | Suresh | 120 | |
Vikas | Raman | 90 | |
Som | Raman | 80 |
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 | |
Sinu | Suresh | 120 |
Second Page (Employee Wise)
Arun | Suresh | 100 |
Third Page (Employee Wise)
Sinu | Suresh | 120 |
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 | |
Som | Raman | 80 |
Second Page (Employee Wise)
Vikas | Raman | 90 |
Third Page (Employee Wise)
Som | Raman | 80 |
Please let us know if you need any more information.
Thanks,
Sijo Joseph
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
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
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
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
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
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
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
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
Thanks Ashfaq.
I have made the selection inside the QMC and it has worked fine.
Hi for this type of heavy reporting.
I would recommend you to go with NPrinting.
Regards
ASHFAQ