AC3.6 - how to script printing a report to a file?

[siep]

I need to have some reports available for users who have no access to AssetCenter. I'm thinking of writing a script that prints these reports to a file when certain records are updated. The function AmActionPrintTo allows you to specify a printer, but how do you specify a file? (actually I prefer to have these reports available as Excel or .csv files. My users wouldn't need Chrystal Reports. But I don't see an easy way to do it.)

 

[Jasonic]

Siep

You can write to a file from with AssetCenter, therefore you could, and I often do, write csv files for users so they can use the data extracted to build their reports without needing to use AssetCenter.

Email me with more details and I'll take a look it.

thomaj3@hotmail.com

Jason Thomas
AssetCenter Consultant
Jason Thomas Consultancy Limited

 

[siep]

Thanks Jason, but there are a lot of reports, and some of them are rather complex. I've got one script that does produce a csv-file, but it was a lot of work to get it correct. But this morning I did find a tool (freeware) which looks promising on

http://www.rainforestnet.com/crexport-download.htm.

It makes it possible to access Crystal Reports with an extensive commandline. I'm thinking of installing Crystal, the reports and this tool on a server, and scheduling it, bypassing AssetCenter alltogether.