ReportCaster for EXL2K template file?

May 18, 2006, 10:20 AM

I'm new to ReportCaster. I have a report that generates a EXL2K template file and saves it to another server location. I also want to have this report scheduled and the output sent via E-mail. When I try to use ReportCaster the job completes (the file is saved to the other server location) but then the ReportCaster log says in its last two lines:

    BTP1020         SET DISTRIBUTE=OFF
    BTP1010         No report to distribute.

What an I doing wrong?

FILEDEF OQUNITS DISK "&FULLPATH|\&FNAME"
TABLE FILE AKHOLD
SUM
  GROSS_SALES AS 'Gross Sales'
  NET_SALES AS 'Net Sales'
BY  LOOKUP1 AS 'Month Lookup Value'
BY  LOOKUP2 AS 'Week Lookup Value'
BY  CUBE_EXECUTIVEVPLEVEL1 AS 'Market Unit'
BY  FOCUSPRODUCT AS 'Product'
BY  TMONTH AS 'Month Ending'
BY  TWEEK AS 'Week Ending'
ON TABLE SET PAGE-NUM OFF
ON TABLE SET NODATA 0
ON TABLE SET BYDISPLAY ON
ON TABLE SET HOLDMISS ON
ON TABLE SET EMPTYREPORT ON
ON TABLE NOTOTAL
ON TABLE SUBHEAD
"&DATEMDYY &TOD"
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='LETTER',
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
  TITLETEXT=&TITLETEXT,
$
ENDSTYLE
ON TABLE HOLD AS OQUNITS FORMAT EXL2K TEMPLATE 'Mktg_Wkly' SHEETNUMBER 1
END

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

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

May 18, 2006, 10:33 AM

Matthew

Okay ..... but how do I then take this hold file and distribute it via E-mail with ReportCaster? I want both the file to be saved (hold file) and the file to be ditributed. Is there an better way to accomplish this? recipients are not licensed WF users so I cannot use the MRE library.

PROD: WebFOCUS 7.1.4 on Win 2003/Microsoft-IIS 6.0/ServletExec 4.2/JAVA version 1.5.0_09
DEV: WebFOCUS 7.6.1 on Win 2003/Microsoft-IIS 6.0/ServletExec 4.2/JAVA version 1.5.0_09
LOCAL: WebFOCUS 7.6.2 on Win XP SP2/Apache Tomcat 5.5.17/JAVA version 1.5.0_09

May 18, 2006, 10:52 AM

Prarie

You will have to have another task that sends the file you have created. Go into Report Caster..under Task Type, pick File and then put the path to the file and e-mail it as you would a regular report.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

May 18, 2006, 11:06 AM

Matthew

My main FEX creates a filename (based on the date the file was created) that changes each time the file is created. Is there a way to use a variable for the file path and name?

path,name is like ...\2006\05-May\Actuals-05-May-05-18-06.xls

All the date components of the above path and name are built in the FEX abd change to the date the file is run.

May 18, 2006, 01:59 PM

Prarie

I have never worked with Templates and don't know if you can just directly send them in Reportcaster without going thru the HOLD process...Anyone out there that can help him?

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

May 19, 2006, 02:45 PM

Matthew

Here is how I have solved this for now. I take the original file that I created on the other server and use DOS commands to copy it to a static filename on the Reportcaster server. I can then add a recportcaster task to send this file at the completion of each job. It is not perfect, but it works.

!COPY "&FULLPATH|\&FNAME" "E:\IBI\APPS\MKTG\TEMPMKTG.XLS"

The recipients will need to manage their files as each week when they recieve a file it will be named the exact same name every time.

If anyone has a way that I can send a file whose name changes programatically each run, I would appreciate the advice.