Hey!
I'm creating a Dynamic distribution list as mentioned in the Manual

================ Excel file data =======================================
richaabc@abc.com,England,$
richa@abc.com,Australia,$
robert@abc.com,France,$
vivek@abc.com,Italy,$

================ MFD code ===========================================
FILENAME=PTT_TEST_DL, SUFFIX=COM
DATASET='PPMC/PTT_TEST_DL1.TXT'
SEGNAME=PTT_TEST_DL, SEGTYPE=S1, $
FIELDNAME=DEST_VALUE, ALIAS=DEST_VALUE, FORMAT=A50, $
FIELDNAME=BURST_VALUE, ALIAS=BURST_VALUE, FORMAT=A50, $



================ Distribution list fex code =============================

TABLE FILE PTT_TEST_DL
ON TABLE SET ASNAMES ON
PRINT BURST_VALUE AS 'VALUE'
DEST_VALUE AS 'DEST'
ON TABLE PCHOLD
END

=========== Webfocus Procedure ========================================
TABLE FILE CAR
ON TABLE SET ASNAMES ON
SUM
CAR
MODEL
DEALER_COST
RETAIL_COST
BY COUNTRY AS 'VALUE'
END
=========== Scheduler Log =============================================
Schedule Executed On Demand at ercpmdcov1:15095
Starting task: CAR PTT Test
Task type: MR Standard Report
Task domain: ppmclwwe/ppmclwwe.htm
Retrieving MR report: app/car_test_dl
Connecting to server EDASERVE with execution id a496549
Executing focexec.
0 HOLDING HTML FILE ON PC DISK ...
Task finished.
Dynamically creating distribution information
ppmc/test_dl: Unable to retrieve data for the distribution list


Any idea where things are going wrong here???
I have opened a Case too with IBI and they are still researching, so thought of asking in the forum as well.
Please let me know....

Thanks
Richa

Where is the script that should create the distribtion list located?

We have this in the EDA and not in the MRE
and we do this

TABLE FILE NK_PRRESOURCE
PRINT
     PRID AS 'VALUE'
     PREMAIL AS 'DEST'
     PREXPIRATION
WHERE     PRISOPEN NE 0;
ON TABLE NOTOTAL
ON TABLE HOLD AS NIKUMAIL
END
-* first in an hold file to be sure the fieldnames are correct
TABLE FILE NIKUMAIL
PRINT
     VALUE
     DEST
ON TABLE PCHOLD

END

can you see what you get if you run the report on screen?

it should be somtehing like this

- <column_desc>
  <col colnum="c0" fieldname="VALUE" alias="E01" datatype="integer" width="11" focus_format="I11" description="" accept="" help_message="" title="" within="" property="" reference="" valign="right" /> 
  <col colnum="c1" fieldname="DEST" alias="E02" datatype="char" width="64" focus_format="A64V" description="" accept="" help_message="" title="" within="" property="" reference="" valign="left" /> 
  </column_desc>
- <table>
- <tr linetype="data" linenum="1">

Hi - my files are exactly the same.
There seem to be no difference.

First,you should add

SET ASNAMES=ON

on the top of your distribution list fex code.
Second, you should configure your application path in the server profile(edasprof.prf).