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:
00433064
Views:
15
>>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?
>
>Are you sure you want to have : in a file name? :)

lcFileName='Balance_'+chrtran(dtoc(date),'/','_')+'.txt'
File would be in a current directory, since you haven't specified full path.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform