Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing report to text file
Message
From
23/10/2000 14:24:15
Dave Nantais
Light speed database solutions
Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00433029
Message ID:
00433052
Views:
12
>Hi,
>
>I've printed reports to text files for archival purposes in the past and for the life of me can't figure out why this isn't working:
>
>*****
>
>* tried this first - didn't work
>
>report form rec_summary to file ;
> "Balance:"+ DTOC(date())+".txt" ASCII
>
>*****
>*/////////////////////////////////////////
>*****
>
>* tried this next- didn't work
>
>local lddate, lcfilename
>
>select rsSystem
>lddate = rsSystem.proc_date
>
>lcfilename = 'Balance:'+ DTOC(lddate)+'.txt'
>
>report form rec_summary.frx to file (lcfilename) ASCII
>
>*****
>*/////////////////////////////////////////
>*****
>
>* tried this last - it worked!!
>
>report form rec_summary.frx to file test.txt ASCII
>
>*****
>
>The first two attempts did not create the text report file - nor did they throw me an error. The last attempt did work. Any idea why either of the first two didn't work?



THE '/' in the date function confuses the parser...
Use only filenames without '/' and you should not have a problem saving a variable type of filename...


lcFileName = "TestSample"
REPORT FORM MyReport.frx TO FILE (lcFileName) ASCII

this should work....
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform