report formatting

[johny.cbi]

When I run the report(8.1version) and view the data is sorts by sales.   

When I email the report it, it doesn't sort by sales.

Thanks for your ideas

[lindero]

do you execute the report in different output formats? There is a different rendering between layout based outputs (HTML, PDF, EXCEL, etc.) and query based outputs (CSV, XML). When you do a sort on the result page, it only works in layout based outputs. If you want to have a sorting in CSV or XML, you have to set it on the query level within the query explorer.

[johny.cbi]

I want the report out put format in HTML or PDF. when I run the report the report is showing the correct values with the sorting

the same report, when I mailed to the user the sorting order is not working either in HTML or in PDF

I tried with Query level sorting & report level sorting etc... still it is showing wrong values in the email

do you execute the report in different output formats? There is a different rendering between layout based outputs (HTML, PDF, EXCEL, etc.) and query based outputs (CSV, XML). When you do a sort on the result page, it only works in layout based outputs. If you want to have a sorting in CSV or XML, you have to set it on the query level within the query explorer.