CSV supported AX SSRS reports

CSV supported AX SSRS reports

It’s a common ask that user wants to export csv file from the report generated. The immediate feedback would be extra columns or columns which shows something like textbox1 or textbox2…

It’s better to develop CSV supported report at start itself to avoid the modification later.

What does CSV prints?

All fields in your rdl which has Data Element Output as Auto or Output

The column will have values of the field where as column header will have value of “DataElementName” or “Name” property of the textbox field.

How does CSV Work?

CSV just prints the value of each text box as columns in excel headed by text box name as column header.

The column headers which we use in report does also considered to be label as values text box name as textbox control name. Which creates unnecessary columns in csv output.

Anything CSV does not print?

Yes . All fields in your rdl which has Data Element Output as NoOutput.

And Now How to Make SSRS Report CSV Supported
·         Give valid name for the text box which has values instead of default naming like textbox1, textbox2 etc.
·         All textboxes which prints the label should have data element output property as NoOutput
·         All textboxes which prints the totals , title should be set to property NoOutput.