I do have multiple burst values and multiple attachments(all images) for each burst value.
How can I distribute attachments(all images) to corresponding email addresses on the basis of burst values.
Can anybody help?

This message has been edited. Last edited by: Prash1983,

Do a search for "Dynamic Distribution"

In our organization, a persons email address has 2 formats:

• FirstName.LastName@okdhs.org
  
• UserId@okdhs.org

As long as UserId is the primary sort value in the report I want to Distribute, I can run a fex similar to the following to create a Dynamic Distribution List.

 TABLE FILE XXXXXX
   SUM COMPUTE DEST/A16=USERID || '@okdhs.org';
    BY USERID AS 'VALUE'
    ON TABLE PCHOLD
 END

XXXXXX is the file used to generate the report.

Hi,
I think I didn't explain the problem clearly.
Dynamic distribution is not a problem here.
I was looking for some help on sending images as attachments alongwith the bursted report I send.

Does anybody have any idea about sending attachments with the report?

Hi Prash,

Have you tried creating two tasks in your schedule ? one task would have a task type of file, and would point to your image file. The other task would run your burst report.

If your choice of image file is dynamic, you could have one task run a fex that picks the image up and displays it in a report. The other task would run your burst report.

Cheers,

Kerry

I think the requirement I talked about was not feasible. It is because I get compound report and it cannot be bursted (as per my knowledge).

I then modified the code to insert the image in the report itself along with other information I send, and it works!!
I just used
' | ATTACHMENT_LINK (field name)
|| ' width="100" height="100"> '
and the image gets inserted in my excel report.
Thanks anyways kerry!!