Question How can export a Report directly from QAD to Excel?

[vinhng]

I want to export a Report directly from QAD to Excel, do you have solution for this?
or do you know any solutions we can export QAD to Text file and then the Text to Excel?
Please let us know.

Thanks

 

[joey.jeremiah]

you might want to have a look at the free docxfactory project.

 

[mayank]

Hello Vinhng,

you can use the below query to export the data in Excel from the table . you have to modify the report to create the data in excel.

Output to "test.xls".
For each cm_mstr :

put unformatted
cm_addr "~011"
cm_sort "~011"
cm_ar_acct "~011" skip.
end.
output close.

Best Regards,

Mayank Sharma

 

[dulecki]

User Interface?

In character, I've saved as a text file and opened in Excel. Then you need to import.

In .Net, you can run reports and send them to Excel as an ouput. There are some exceptions to this.

Good luck.