Save As CSV doesn't include CheckBox value

Stimulsoft Reports.WEB discussion
Post Reply
james.crossley
Posts: 28
Joined: Sun Aug 07, 2011 8:53 pm
Location: Auckland

Save As CSV doesn't include CheckBox value

Post by james.crossley »

I have a simple customer listing report. Each line contains a CheckBox indicating whether the record is active. The report renders correctly in the Web and Flash viewers.

When the report data is exported to CSV, neither the checkbox value (true/false) nor the column header is exporter.

The Excel Value property allows me to do this for Excel but it doesn't apply to CSV exports.

Is there any way to workaround it?

I'm using Report.Web with FxViewer or WebViewer (v2013.2.1612.0)

Thanks
James
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Save As CSV doesn't include CheckBox value

Post by HighAley »

Hello, James.

The СheckИox is not exported to CSV-file because it's a graphical element like image or chart.
What do you want to see in the CSV-file?

Thank you.
james.crossley
Posts: 28
Joined: Sun Aug 07, 2011 8:53 pm
Location: Auckland

Re: Save As CSV doesn't include CheckBox value

Post by james.crossley »

Hi Aleksey

I understand that the checkbox is a graphical element but in my application it is important to be able to export a value in CSV. I think others would also find this useful. In a CSV file I would expect to see the *value* of the checkbox.

I suggest either;

1/ A value reflecting the CheckBox Values property in the designer. (E.g. true or false, yes or no, on or off, 1 or 0)

OR

2/ A new CheckBox property "CSV Value" similar to "Excel Value" in the designer which would allow the developer to add an expression.

In my opinion, 1/ would be fine.

Thanks for your consideration.
James
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Save As CSV doesn't include CheckBox value

Post by HighAley »

Hello.

We need some time to check out if it's possible to implement such feature.
We will let you know about the results.

Thank you.
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Re: Save As CSV doesn't include CheckBox value

Post by Ivan »

Hello,

We made some improvements in that direction and add support of checkboxes to CSV/DBF/XML exports.
If you need to modify the default "true"/"false" values, please change the following static properties:

Code: Select all

StiOptions.Export.CheckBoxTextForTrue;
StiOptions.Export.CheckBoxTextForFalse;
The patch will be available in the next prerelease build.

Thank you.
james.crossley
Posts: 28
Joined: Sun Aug 07, 2011 8:53 pm
Location: Auckland

Re: Save As CSV doesn't include CheckBox value

Post by james.crossley »

Hi Ivan

That's awesome.

Thanks very much for a quick response to a minor issue!

Cheers
James
Andrew
Posts: 4109
Joined: Fri Jun 09, 2006 3:58 am

Re: Save As CSV doesn't include CheckBox value

Post by Andrew »

Hello,

Thank you for your good words.

Please let us know about the result of testing when it will be possible.
Post Reply