Method Community

I was excited to descover it's possible to export a report in csv format from the Report Designer.

For some reason, however, the data gets cut off. For example, I created a Sales Order summary report. Any sales orders with less than 3 lines showed no lines. Any Sales Orders with more than three lines showed the lines less three. For example: one of the sales orders has 20 lines. The 20 lines show up in the print preview but not in the csv export. Only 17 lines show up in the csv file after exporting.

l.brandow:

For some reason, however, the data gets cut off.

This sounds like a limitation in the report designer - I know there is a limit to the amount of data it will pull in for the print preview window (100-200 rows I think) so you're probably running into a similar limitation.

~C