Crystal Reports Export to .csv comma delimited string inserting blank columns
I have a issue and need some expert help! I'm trying to export a .csv field directly from crystal reports and I keep getting blank columns in between my datasets. The report is one formula only in the details section, that contains a string separated by comma's like below. Any help or suggestions is greatly appreciated!
*Side note the requirements are an export directly to .csv so no export to data only then save to .csv will work.
Solution
Your approach implicitly converts numbers to text. This might results in extra commas due to thousand separators.
Instead, use explicit conversion such as
ToText({your number}, 2, "")
to avoid the extra commas.
- Crystal Report - shared numbervar
- Crystal Report: How to use the Operator 'in' with if conditions
- Crystal Report SP26 SetDataSource() Method failed in computers of clients in Visual Studio 2019
- Get sum of a field per page in crystal report
- When viewing a report inside an application, the parameter prompt redisplays when moving to the next page
- removing decimals in crystal reports for number field
- ASP.net: Crystal Reports - Subreport over multiple pages
- Crystal reports sort group-by in natural order
- How to find an SQL error in Crystal Reports?
- "Error applying transforms. Verify that the specified transform path are valid." when uninstalling
- Report formula for Over90Days
- SAP Crystal Reports & VS 2015
- This method(chr()) does not support unicode in crystal report.. so how to use unicode in crystal?
- How to open HANA DB report in Java?
- Why do I get a "Failed to export the report" error when I try to export a Crystal Report to an HTML file?
- Can I use Crystal Reports in Visual Studio 2022?
- Crystal Report throws 'Connection reset.' on document open
- Remove login requirements for Crystal Report
- Find instance of a formula on a report when it's been hidden
- Formula to change how a number is displayed in crystal reports
- Crystal report 2008: How to extract "Report Custom Function" content from the rpt file
- Intermittent Crystal Reports error "The request could not be submitted for background processing."
- Crystal Reports: "Failed to Save Document" after changing Datasource
- Crystal Report- how to round decimal in crystal report?
- How to group by one field and sort by another field with Crystal Report
- Crystal Report Running Total
- In Crystal Reports I have a Parameter field + 2 years
- In Crystal Reports, How do I count all the rows in the Details section and place that count in the header?
- Crystal Reports Error in ASP.NET Core MVC. Could Not Load File
- "Database logon failed" in Crystal Reports when using System DSN for MySQL Server