Page 1 of 1

CSV Datasource

Posted: Mon Oct 31, 2011 6:56 am
by flo78
Hello,

I am using a csv file as datasource. Delimiter symbol is semicolon. Could you tell me how to escape this symbol when it appears as part of a string value.
In your documentation you tell to frame it with double quotes. Doing so, the report recognizes that the semicolon is part of the string, but shows it as ";" and not only as ;

Another question:
One column in the csv file is a path to an image file. I have an Image control in the report whose hyperlink property is set to this value.
But the link always has to be written as an absolute path, which is a problem because I want to copy the report into various folders and don't want to adapt the path each time. Report, csv and images always are in the same folder. Is it possible to use a relative path (= only the name of the image file) ?

Thank you very much.

CSV Datasource

Posted: Mon Oct 31, 2011 11:03 am
by flo78
OK, the thing with the path is nonsense. Of course a relative path refers to the location of the Designer.exe and not to the path of the mrt-file.
But still I don't know how to escape semicolons...

CSV Datasource

Posted: Tue Nov 01, 2011 2:35 am
by Ivan
Hello,

Please check the sample in attachment.

Thank you.

CSV Datasource

Posted: Wed Nov 02, 2011 2:59 am
by flo78
OK, you have to put the whole string between double quotes, not only the semicolon itself.

Thank you!

CSV Datasource

Posted: Wed Nov 02, 2011 3:50 am
by Alex K.
Hello,

Let us know if you need any additional help.

Thank you.