I need to create dynamic address list for bursting in ReportCaster. I have data in SQL 2005 table where I have Job_Number and PM_Email_Addr fields, so according to
http://documentation.informationbuilders.com/masterinde..._rc_dynamiclist8.htm
in my case it should be

 SET ASNAMES=ON
TABLE FILE JOBSUMMARY
PRINT JOB_NUMBER AS 'VALUE'      
      PM_EMAIL_ADDR AS 'DEST'
ON TABLE PCHOLD
END 

What should I do next? How I make ReportCaster aware that it should be using this info? Should I Edit ReportCaster Schedule / Distribution tab / select Type 'Dynamic Address' / click next to 'To' field and select Dynamic Address Procedure (where I have the above code)?
Thanks

You've got it.

Seva,

How did you create the master file with the email address and burst value and where did you save the file? Does it matter what directory?
I want to do something similar.

Thanks!

Slim,
You need a file that contains pairs of values.
One field, called VALUE contains the values of the outer sortfield of your report, the one that you will code BY sortfield PAGE-BREAK.
The other field called DEST contains the corresponding e-mail address.
Write a simple focexec like the one below. Enter its name in the "To" field of the Distribution information of your RC.

  
TABLE FILE EMAIL
PRINT DEST
BY VALUE
ON TABLE PCHOLD
END

That's it. Good luck!

Slim

You do not have to save the file. It is a DYNAMIC list and not a static list.
The PCHOLD creates a kind of XML file.