4 Replies Latest reply: Jun 8, 2012 4:40 AM by Kiruthigadevi Subramaniam RSS

    publishing pdfs to different regional mail ids

    Kiruthigadevi Subramaniam

      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

       

       

       

        • publishing pdfs to different regional mail ids
          Miguel Angel Baeyens de Arce

          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

            • Re: publishing pdfs to different regional mail ids
              Kiruthigadevi Subramaniam

              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

               

               

                • publishing pdfs to different regional mail ids
                  Miguel Angel Baeyens de Arce

                  Hi,

                   

                  Try this in the task:

                  • Set Reduce by Region, using "Reduce By Field Value".
                  • Use the "Reduced Document Name" textbox to configure the name of the report (for example, using the value of the field Region).
                  • Then go to the tab "Distribute" in the same task, select "Loop Field in Document", click on "Open Document" and select your field "Email Address" and set "Check user identity on" "Email Address", and click on "Target Type:" "E-Mail".
                  • Finally, in File Type, click on "PDF Report from Source Document" and select the report ID you want to send by emailfrom your QVW.

                  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