November 09, 2007, 03:54 AM
Tony ACWM,
If you updated your signature with the release info you gave above
and your platform we might be able to advise on an alternative that would be available to that platform.
T
November 09, 2007, 01:46 PM
iraI have successfully ftp'd a dynamically created filename that contains the the current date & time portion as the filename. Granted my distribution method was ftp differs than email, but the concept would be the same.
goto
http://techsupport.informationbuilders.com/sps/1096.2092.htmlIra
WF 5.3.6 AIX 533 WINDOWS XP (Development)
7.6.x (Test) Windows
5.3.x Production....
November 09, 2007, 03:56 PM
susannahas a feeble excuse for an idea,
you could in your style sheet
,TITLETEXT='My Title &YYMD' ,
or put any form of edited &var in as titletext so that at least the TAB on the excelsheet would have the proper date on it. That works in email.
I can only get emailed .xls to title themselves whatever the fex is named. so... somehow i think you've gotta copy the fex to something temporary with todays date in the fexname,
and somehow get that scheduled.
then nuke it.
Somebody smarter will come along figure out how to do that.
I have now *completely* forgotten what i logged on to look up...happens every time.
November 17, 2007, 04:19 PM
FrankDutchI might have a solution
You can create the report with a not printed first by field and use that byfield as the burst value
The mail address you use must be in a dynamic list.
The burst value will now be put in the attachment file name.
So in coding...
DEFINE FILE CAR
DUMMYBURST=&YYMD;
END
TABLE FILE CAR
PRINT COUNTRY
BY DUMMYBURST NOPRINT
ON TABLE PCHOLD FORMAT PDF
...
END
For the DYNAMIC address list
SET ASNAMES = ON
DEFINE FILE CAR
BURST_VALUE WITH COUNTRY=&YYMD;
EMAIL_ADDRESS WITH COUNTRY='myadress@company.com';
END
TABLE FILE filename
PRINT BURST_VALUE AS 'VALUE'
EMAIL_ADDRESS AS 'DEST'
WHERE COUNTRY EQ 'ITALY';
ON TABLE PCHOLD
END
or use a flat file with the mail addresses....
I hope this works, could not test it at home.