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?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.