I am trying to use dynamic addressing to schedule and burst a coordinated report. The report runs fine. I can schedule and burst it using standard methods. I can even get the dynamic addressing to work using a simple fex like what is listed below.

SET ASNAMES = ON
TABLE FILE RP_BUSINESSVIEW
PRINT
BUSNO AS 'VALUE'
BUSINESSEMAIL AS 'DEST'
ON TABLE PCHOLD
END

The above fex works, but this simple fex is not what I need. The list I need requires the fex to use several hold files. When the fex has the required code, with the exact same output fields, I get the ReportCaster error message below.

BTP1010 Schedule Executed On Demand at VESPER:8200
BTP1020 Starting task: Scheduled Vehicle Payments and Account Fees Report
BTP1020 Task type: MR Standard Report
BTP1020 Task domain: dscitscs/dscitscs.htm
BTP1020 Retrieving MR report: app/scheduled_payments_report
BTP1020 Connecting to server EDASECD with execution id gentrican
BTP1020 Executing focuses.
BTP1020 0 HOLDING PDF FILE ON PC DISK ...
BTP1020 Task finished.
BTP1010 Dynamically creating distribution information
BTP1010 padb/testdynamicaddresswithvariables: Unable to retrieve data for the distribution list

The required code to create the address list is basically the same code that is used for the header of the coordinated report, which works fine with no errors. When the real fex I need for the dynamic addressing is run on its own, there are no errors, and it produces the same type of output as the simple fex.

Does anyone have any clues as to what my issue might be? Are their nuances to dynamic addressing that may not be documented?

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

Is the last TABLE command, the one that created the dynamic list, exactly like the one you posted?
If not, could you post it?
If so, did you check whethere there might be an error which causes the HOLD file to be empty?

Let me preface this by saying it has been a while since I did any complicated RC work. That being said, why are you using

ON TABLE PCHOLD

instead of

ON TABLE HOLD

?

I am just following what I found when I searche for "dynamic address".

http://documentation.informati..._rc_dynamiclist8.htm

The following is a sample procedure for bursting. The column names and the order in which they are returned must be 'VALUE' and then 'DEST'.

SET ASNAMES=ON
TABLE FILE MYADDR
PRINT BURST_VALUE AS 'VALUE'
EMAIL_ADDRESS AS 'DEST'ON
ON TABLE PCHOLD
END

It creates what looks like xml output. This formating works when it is this simple.

Here is the code I want to use, but will not work. if I exit after the last hold file, it rows of data for each hold file.

-* ----------------------------------------------------------------------------------------------------
-* upcoming payments report - header
-* created by gje 2012-04-12
-* provides the header information for this coordinated report
-* creates a list of dealers
-* who have upcoming payments in the next 60 days
-* or have overdue and upcoming account charges
-* ----------------------------------------------------------------------------------------------------
-*-INCLUDE TRACE_FOC_NORUN
-DEFAULT &NUMBEROFDAYS = 60;
-PROMPT &NUMBEROFDAYS.(7,14,30,60).Number of Days.
-DEFAULT ®IONNAME = '''South Central''';
-DEFAULT &MARKETNAME = '''Jackson''';
-SET &TODAYSDATE = &YYMD;
-*-SET &TODAYSDATE = 20120401;
-SET &STARTDATE = DATECVT(DATEMOV(DATECVT(&TODAYSDATE,'I8YYMD','YYMD'), 'BOW'),'YYMD','I8YYMD');
-SET &ENDDATE = DATECVT(DATEADD(DATECVT(&STARTDATE,'I8YYMD','YYMD'),'D', &NUMBEROFDAYS),'YYMD','I8YYMD');
-SET &PRINTSTARTDATE = DATETRAN(DATECVT(&STARTDATE, 'I8YYMD', 'YYMD') , '(MDYY)', '(Dtrdxr)', 'EN', 30, 'A30');
-SET &PRINTENDDATE = DATETRAN(DATECVT(&ENDDATE, 'I8YYMD', 'YYMD'), '(MDYY)', '(Dtrdxr)', 'EN', 30, 'A30');
-SET &PRINTDATERANGE = SQUEEZ( 100, &PRINTSTARTDATE || ' - ' | &PRINTENDDATE, 'A100');
SET NODATA = ' ';
-* ----------------------------------------------------------------------------------------------------
-* create hold upcoming payment detail (H_UPDTL)
-* ----------------------------------------------------------------------------------------------------
JOIN CLEAR *
JOIN
INNER RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSID IN RP_BUSINESSVIEW TO MULTIPLE
FLOORPLAN.FLOORPLAN.BUYERBUSINESSID IN FLOORPLAN TAG FP AS FP
END
JOIN
INNER FP.FLOORPLAN.FLOORPLANID IN RP_BUSINESSVIEW TO UNIQUE
CURTAILMENT.CURTAILMENT.FLOORPLANID IN CURTAILMENT TAG CRTLMT AS CRTLMT
END
JOIN
INNER FP.FLOORPLAN.FLOORPLANID IN RP_BUSINESSVIEW TO UNIQUE
FLOORPLANCACHE.FLOORPLANCACHE.FLOORPLANID IN FLOORPLANCACHE TAG FPC AS FPC
END
JOIN
INNER CRTLMT.CURTAILMENT.TERMPLANPERIODID IN RP_BUSINESSVIEW TO UNIQUE
TERMPLANPERIOD.TERMPLANPERIOD.TERMPLANPERIODID IN TERMPLANPERIOD TAG TPP AS TPP
END
-* ----------------------------------------------------------------------------------------------------
TABLE FILE RP_BUSINESSVIEW
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSID
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSNO
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMEACTUAL
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMENUMBERUPPER
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMENUMBER
BY RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSEMAIL
WHERE FP.FLOORPLAN.FLOORPLANSTATUSID EQ 1;
WHERE CRTLMT.CURTAILMENT.ISVOIDED EQ 0;
WHERE CRTLMT.CURTAILMENT.ISWAIVED EQ 0;
WHERE CRTLMT.CURTAILMENT.PAYOFFFINANCIALRECORDID EQ '';
WHERE CRTLMT.CURTAILMENT.EXPECTEDPRINCIPALPAYMENT GT 0;
WHERE ( CRTLMT.CURTAILMENT.DUEDATE GE &STARTDATE ) AND ( CRTLMT.CURTAILMENT.DUEDATE LT &ENDDATE );
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.ISDELINQUENTDEFAULT EQ 'N';
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION EQ ®IONNAME.(OR(FIND RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION,RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION IN rp_businessview)).Region.;
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH EQ &MARKETNAME.(OR(FIND RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH,RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH IN rp_businessview)).Market.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS H_UPDTL FORMAT FOCUS
END
-* ----------------------------------------------------------------------------------------------------
-* create hold overdue and upcoming payment detail (H_ACTFEE)
-* ----------------------------------------------------------------------------------------------------
JOIN CLEAR *
JOIN
INNER RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSID IN RP_BUSINESSVIEW TO MULTIPLE
FINANCIALRECORD.FINANCIALRECORD.RESPONSIBLEBUSINESSID IN FINANCIALRECORD TAG FR
AS FR
END
JOIN
INNER FR.FINANCIALRECORD.FINANCIALRECORDID IN RP_BUSINESSVIEW TO UNIQUE
FINANCIALRECORDCACHE.FINANCIALRECORDCACHE.FINANCIALRECORDID
IN FINANCIALRECORDCACHE TAG FRC AS FRC
END
JOIN
INNER FR.FINANCIALRECORD.FEETYPEID IN RP_BUSINESSVIEW TO UNIQUE
FEETYPE.FEETYPE.ID IN FEETYPE TAG FT AS FT
END
-* ----------------------------------------------------------------------------------------------------
TABLE FILE RP_BUSINESSVIEW
PRINT
FR.FINANCIALRECORD.DESCRIPTION AS 'Description'
COMPUTE OVERDUE/A7 = IF FR.FINANCIALRECORD.EFFECTIVEDATE LT &YYMD THEN 'Yes' ELSE 'No'; AS 'Over,Due'
FR.FINANCIALRECORD.AMOUNTAPPLIED/P21.2CM AS 'Fee'
FRC.FINANCIALRECORDCACHE.BALANCE/P21.2CM AS 'Balance'
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSNO
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSID
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMEACTUAL
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMENUMBERUPPER
BY LOWEST RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSNAMENUMBER
BY RP_BUSINESSVIEW.RP_BUSINESSVIEW.BUSINESSEMAIL
BY TOTAL COMPUTE DUEDATE/MDYY = HDATE(FR.FINANCIALRECORD.EFFECTIVEDATE, 'YYMD'); AS 'Due Date'
BY LOWEST FT.FEETYPE.TYPE AS 'Fee Type'
WHERE FR.FINANCIALRECORD.FLOORPLANID EQ '';
WHERE FR.FINANCIALRECORD.FINANCIALCONTEXTTYPEID NE 9;
WHERE FRC.FINANCIALRECORDCACHE.BALANCE GT 0;
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.ISDELINQUENTDEFAULT EQ 'N';
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION EQ ®IONNAME.(OR(FIND RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION,RP_BUSINESSVIEW.RP_BUSINESSVIEW.REGION IN rp_businessview)).Region.;
WHERE RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH EQ &MARKETNAME.(OR(FIND RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH,RP_BUSINESSVIEW.RP_BUSINESSVIEW.BRANCH IN rp_businessview)).Market.;
ON TABLE NOTOTAL
ON TABLE HOLD AS H_ACTFEE FORMAT FOCUS
END
-* ----------------------------------------------------------------------------------------------------
-* creates hold upcoming payment and account fee (H_ACTFEE)
-* this creates the list fo dealers who either have a upcoming payment
-* or an overdue or upcoming account fee
-* ----------------------------------------------------------------------------------------------------
MATCH FILE H_UPDTL
BY H_UPDTL.SEG01.BUSNO
BY H_UPDTL.SEG01.BUSINESSID
BY H_UPDTL.SEG01.BUSINESSNAMEACTUAL
BY H_UPDTL.SEG01.BUSINESSNAMENUMBERUPPER
BY H_UPDTL.SEG01.BUSINESSEMAIL
RUN
FILE H_ACTFEE
BY H_ACTFEE.SEG01.BUSNO
BY H_ACTFEE.SEG01.BUSINESSID
BY H_ACTFEE.SEG01.BUSINESSNAMEACTUAL
BY H_ACTFEE.SEG01.BUSINESSNAMENUMBERUPPER
BY H_ACTFEE.SEG01.BUSINESSEMAIL
AFTER MATCH HOLD AS H_UCPFEE OLD-OR-NEW
END
-* ----------------------------------------------------------------------------------------------------
-* creates output for each dealer for header
-* ----------------------------------------------------------------------------------------------------
SET ASNAMES = ON
TABLE FILE H_UCPFEE
PRINT
H_UCPFEE.H_UCPFEE.BUSNO AS 'VALUE'
COMPUTE DEST/A100 = 'gentrican@discoverdsc.com'; AS 'DEST'
WHERE H_UCPFEE.H_UCPFEE.BUSNO EQ 11723 OR 20887 OR 47733;
ON TABLE PCHOLD
END

Note that I am using a compute in the last part for email output, because I do not want it to actually send out emails to customers now, so I send it to myself. This is the test phase.

I really can't see anything wrong with your code.

However I would do the following:
- No ; in a -DEFAULT statement
- No ; in the SET NODATA statement
- It is not necessary to HOLD FORMAT FOCUS: it just adds time
- Before the last TABLE I would issue JOIN CLEAR *
- Before the last TABLE I would issue SET HOLDLIST=PRINTONLY

Good luck

I adding the JOIN CLEAR and SET HOLDLIST. No change.

I do not understand what you mean with the below. Can you clarify?

- No ; in a -DEFAULT statement
- No ; in the SET NODATA statement

A closing semicolon is required syntax in the dialog manager directive -SET (needed because -SET can span multiple lines).

It is optional in -DEFAULT.

It is not part of the syntax of the Focus reporting language command SET, so
SET NODATA = ' ';
is incorrect code.

Can someone explain why PCHOLD (rather than HOLD) is required? Is it that the distribution server is the client ("PC"), and is calling a WF server to execute the request and return a dataset for RC to process?

Jack,

Exactly.

GJE,

Ok. So let's debug.

Can you create your H_UCPFEE file in a directory, then run your RC using only the last TABLE?
If that works, then go back one step. Create the files used in the MATCH, then run the MATCH and the last TABLE in the RC and so on.

OK. Got you on the SET with no dash and the semicolon. I revised that. No change.

Can you explain more about creating my H_UCPFEE in a directory? Do you mean create a permanent hold file with the data and then running the last TABLE against the FOCUS data?

Yes. Exactly.
Then if this works, go back one step, etc...

I have already tried to get this to work from a very simple hold file. I could never get it to work, even though the output looked exactly the same as the simple fex. Very strange.

I assume that BUSNO has a format of I5.
Could you try to create your permanent data file like this:

  
SET ASNAMES = ON
DEFINE FILE H_UCPEE
ABUSNO/A5=EDIT(BUSNO);
END
TABLE FILE H_UCPFEE
PRINT
ABUSNO AS 'VALUE'
COMPUTE DEST/A100 = 'gentrican@discoverdsc.com'; AS 'DEST'
WHERE H_UCPFEE.H_UCPFEE.BUSNO EQ 11723 OR 20887 OR 47733;
ON TABLE HOLD AS HGJE
END

Then in RC issue:

  
TABLE FILE HGJE
PRINT VALUE DEST
ON TABLE PCHOLD
END

If this doesn't work... "Houston, we have a problem!"

BUSNO has a format of I11, therefore when it is converted it has leading zeroes. I can try your solution after I deal with some tickets that I have. Maybe tomorrow.

[CLOSED] At this time I have not resolved this issue, but I have to move on to more pressing items and will come back to it.