Microsoft Dynamics AX (Archived)

Export Report to CSV

(0) Share

Report

Posted on by Elda Mataj

190

Hello everybody,

I have a requirement where I need to export a report in CSV, but I want the fields to be separated by semicolon(;).

I have done this up to now:

str csvName;

csvName = strfmt("test");

controller.parmReportContract().parmReportExecutionInfo(new SrsPrintMngmtExecutionInfo());

controller.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);

controller.parmReportContract().parmPrintSettings().fileFormat(SRSFileFormat::CSV);

controller.parmReportContract().parmPrintSettings().overwriteFile(true);

controller.parmReportContract().parmPrintSettings().fileName();

controller.parmReportContract().parmPrintSettings().fileName(csvFileName);

controller.startOperation();

It saves the report in CSV, but the fields are separeted with comma. Istead i need the fields to be separated with semicolon(;).

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Eva Shehu!

I think this is a default settings of reporting service.

Maybe this link will be helpful: https://social.technet.microsoft.com/Forums/sqlserver/en-US/82216397-8757-460b-b7a0-b39e3c2880c9/ssrs-how-to-export-to-a-semicolon-delimited-file?forum=sqlreportingservices

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,040 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

SSRS supports it, therefore it might be doable.

One option is changing the default delimited in DeviceInfo section of RSReportServer.config. SSRS documentation, namely CSV Device Information Settings, tells you that must change FieldDelimiter.

If you want to do just in some cases, you need the ability to set this value in AX in printer settings. It's not supported in AX 2012, but you could add the support by yourself. I'm looking at the code in D365FO, but I'll assume it's the same in AX 2012.

deviceInfo() method of SRSPrintDestinationSettings class constructs DeviceInfo (XML snippet) with information about print format. It doesn't set anything specific to CSV, but you can change it. Therefore you could add a new member variable for field delimiter, an accessor method allowing to set the value and then add FieldDelimiter element with the right value in deviceInfo().

I didn't test it, but I think it should work.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Eva,

Can you tell what exact data needs to be exported as CSV? You can probably use Data Import Export Framework as alternative. This tool is created for import and export data in specific formats.

Was this reply helpful? Yes No
Elda Mataj 190 on at

Like (0)

Report
Copy link

Link copied!

Thank-you for your answer @Martin Dráb.

I am trying to set the field delimiter in this way.

Firstly, In class declaration of SRSPrintDestinationSettings Class, i have declared fieldDelimiter variable, as:

Delimiter fieldDelimiter

Then, in SRSPrintDestinationSettings Class, I have created 2 new methods:

1) FieldDelimiter method as below:

public Delimiter fieldDelimiter(Delimiter _fieldDelimiter = fieldDelimiter)

{

fieldDelimiter = _fieldDelimiter;

return fieldDelimiter;

}

2) csvFile method, as below:

public void csvFile()

{

CommaTextIo commaTextIo;

commaTextIo = new CommaTextIo(fileName, "W");

commaTextIo.outFieldDelimiter("fieldDelimiter");

}

Then, on deviceInfo method, I have called csvFile method:

case SRSReportFielFormat::CSV:

this.csvFile();

On reportController, I set the value of fieldDelimiter method, as below:

controller.parmReportContract().parmPrintSettings().fieldDelimiter(;);

But still the fields are separated with comma(,), not semicolon(;).

Can anyone give any suggestion, why it still separates the fields with comma(,)?

Thank -you!

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

My solution is about using SSRS, not CommaTextIo, therefore you're doing something else than what I suggested.

Even if you want to use CommaTextIo (although I have no idea how), notice that you csvFile() method merely creates an instance but never uses it, therefore it has no effect at all. And you what you pass to outFieldDelimiter() is text "fieldDelimiter", not the variable.

Was this reply helpful? Yes No