Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am using QV11 publisher,
I have created a task in the publisher which creates a Region_Sales.pdf into a folder after each reload of the task,
if i want the indivudual region sales as Region1_sales.pdf,Region2_Sales.pdf after each reload,I am not getting it,
I tried with "banding loop" for Region in the page setting and report settings of the edit report ,but still it is created as a single Region_Sales.pdf with all Regions with in the application??
I can use "reduce" in the publisher to reduce,
but I need to create as many task to reduce to each region ,so I have created a macro in my application to loop through different regions
and create an individual pdf for individual region,
Iam not sure it is correct or not,just cpied from our community and tried but its not working 😞
I have attached the demo application,please do let me know if any one knowssssssss
Kind Regards,
Keeruthii
Hi,
In Publisher, you can loop a field to distribute by email to different users even without reducing data, if that's the case. The only thing you need is to include those email addresses in the script using any valid source (INLINE, excel file, database table...). You only need one task to do that, instead of creating as many tasks as possible recipients.
Hope that helps.
Miguel
Miguel,Thanks for your timings
actually,I have added the mail ids in an excel and called those inside the application and its working fine but my problem is to generate individual pdf to individual region in a single task?
although if I loop and band the field "Region",I can still be able to see all the Regions in my report 😞
eg of my scenario:
Region Email Address
Region1 email1
Region2 email2
My Requirement :
I need to send as Region1.pdf to email1 and
Region2.pdf to email2 after each reload with out creating 2 different tasks
Thanks again
Hi,
Try this in the task:
Apply to save settings and run the task: it should reload first, then reduce and create as many PDF files as regions and recipients, then send them by email, in the same task.
Hope that helps.
Miguel
Miguel,
Thanks again
When i tried what you suggested,Iam getting a warning as below:
"Warning : Dynamic distribution returned no receipients using "EmailAddress" using parameter "EmailAddress"
actually I kept all the email_id's under the column "EmailAddress" in the excel and called this inside the application
do i need to change some thing in the email column,pleae do let me know