Hello!
Im trying to export my reports to .csv, but cant seem to format export output the way I want.
My problems are:
1. Reportheader and reportfooter appears on every row, eventhough I specifically set them not to.
2. åäö-characters gets all messed up and instead looks like this: ö
This is my code for setting up the export:
exportOptions.ExportDestinationType = ExportDestinationType.NoDestination;
exportOptions.ExportDestinationOptions = new DiskFileDestinationOptions();
exportOptions.ExportFormatType = ExportFormatType.CharacterSeparatedValues;
CharacterSeparatedValuesFormatOptions characterSeparatedValuesOptions = ExportOptions.CreateCharacterSeparatedValuesFormatOptions();
characterSeparatedValuesOptions.ExportMode = CsvExportMode.Standard;
characterSeparatedValuesOptions.GroupSectionsOption = CsvExportSectionsOption.ExportIsolated;
characterSeparatedValuesOptions.ReportSectionsOption = CsvExportSectionsOption.ExportIsolated;
characterSeparatedValuesOptions.Delimiter = ",";
exportOptions.ExportFormatOptions = characterSeparatedValuesOptions;
Report.ExportToDisk(ExportFormatType.CharacterSeparatedValues, "testing.csv");
Does anyone have an idea how I solve these two issues?
edit: I´m using CR2008.
Edited by livez - 19 May 2009 at 12:19am
IP Logged
