CSV Datasource
Posted: Mon Oct 31, 2011 6:56 am
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.
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.