>>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