nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Format issue when creating CSV reports.

rem955

Hello. My report has a money field in it. The format is in such a way that it is unreadable by Excel for numbers over 999.##. It will separate the 3rd and 4th digits from the right with a space, and I imagine that it will do that for every three digits. I am not using any special formatting on this field other than specifying it is a decimal. Any ideas?

Find more posts tagged with

Comments

mwilliams

Are you exporting to CSV from the viewer? Can you attach a sample design I can run where I'll see this issue and can test on it? Thanks!

rem955

No, this is from the BirtEngine directly to a file using CSVRenderOption. This is work related, so I doubt sending actual actual code would be a good idea. I want to guess my solution is coming up with a format that puts all the digits together, instead of using a comma every three digits. Wouldn't the file renderer be responsible for replacing the commas with white space?

mwilliams

What is your BIRT version? Are you able to reproduce this issue with the sample database? If so, can you attach the design? Thanks!