Fastreport 2025.1 VCL: CSV file with too much separators
Hello,
I tried to save a report with TfrxExportCsv filter and Option DataOnly = True. The report looks like this
and the CSV like this
Is there a possibility to avoid the amount of separators? (Only one separator between each field)
Thanks
Gerd
Comments
Hello!
You can use the recommendations from this article.
https://www.fast-report.com/public_download/docs/FRVCL/online/en/FastReportVCL/UserManual/en-US/Report_viewing_printing_and_export/Report_Design_References.html
These recommendations are also suitable for CVS - the same agorhythm is used.
This did not help really. As you can see in the report there are reasons, why the text's are not all in some columns. It's not a reason of small differences of the left position.
However, in order to avoid unnecessary separators, it is necessary to align the columns with the data. You can check this yourself on demo reports, for example, at the top of the export output without settings, there are extra separators, at the bottom, the width of the first two headings is equal to the width of the data columns, there are no extra dividers in the first two columns.
In this case CSV-Export makes only sense with simple list report. In that moment where you have a more complex report it's impossible to align all data from different chapters.
Is there an event which I can catch to implement a script and how must the script look to replace double delimiters?
Have you followed the recommendations from the articles above? what was your result after that? The number of separators should have been greatly reduced.
Can you send me a CSV screenshot of what you got after following the recommendations?
You can try to align the elements to the grid in the OnBeforeExport event, you will get 11 of them, judging by the table below.
Sorry, but have you seen the screenshot of my report?
OK, I can bring the first two chapters to same left position. But then it's not so easy to read. There is an background why the lines under "Used equipment" more right. And also that there is a difference between first chapter and "Calculation setting". In first chapter I need more space for the data, in "Calculation setting" I need mor spave for the titles.
Latest with chapter "Measuring data" I have 11 columns and with the lines between 21.
After that I have additional grids (not shown in the screenshot) with 8 and 15 columns. The column width are optimized to show all data. It's not possible to bring all of them to same left position.
If there is no possibility that FR handles the columns per band/chapter, is there a possibility to reduce the separators per script?