crystal-reportscrystal-reports-2008crystal-reports-2010crystal-reports-8.5
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.
- 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
- Is there a way how to fix the size of textboxes in crystal report?
- Crystal Reports Exception: The maximum report processing jobs limit configured by your system administrator has been reached
- How to find Datasource in Crystal reports
- Crystal Reports - Access All Rows Returned by a Query Instead of One at a Time
- How to implement Crystal Reports in Java EE
- Problem with visual basic 2022 and crystal report
- I am receiving a color formatting error when trying to run a Crystal Report in Personify
- Can I use Crystal Reports in Visual Studio 2022?
- Multi group with multi column in crystalreport
- How to add a JNDI to a Crystal report bean?
- Crystal Reports RecordSelectionFormula does not work
- Crystal Report Issue with IIS - ( bobj is undefined , Crystal report not displaying )
- Crystal Reports for VS 2008 - "The user function manager DLL (ufmanager.dll) could not be found."
- Crystal Reports 9 - Create parameter fields in batch instead of creating one by one
- How to use Interleaved 2 of 5 barcode font in Crystal Reports
- Crystal Report - Add bottom margin on all pages for the text object with 'can grow' parameter active
- IS NULL configuration assistance please