Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing report to text file
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00433029
Message ID:
00433079
Views:
14
>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?

If you really want to have the date as the file name, use DTOS(DateVar) (yyyymmdd) for that part of the name. This will also give you the added benefit that a sorted directory will show you the files in the proper order.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform