CSV Export Issue....no data still exports as row of delimiters?

[noona23]

Hi,

We are using CR 2008.

I have a report which we export as a csv file (~ seperated).

It's a simple,unformatted report with report header, detail and report footer sections.

We have a header and footer in the report footer and page footer respectively. When the report returns data everything is fine. It exports to the file correctly.

Header1
Field1~Field2~Field3~Field4.......~field20
Field1~Field2~Field3~Field4.......~field20
Footer1

When the report doesn't contain any data the CR view looks fine:

Header1
Footer1

But the csv export returns a line of all ~ (seperator character).

Header1
~~~~~~~~~~~~~~~~~~
Header2

In this case I'd like to get what we see in the CR.

Header1
Header2

In Detail section I've set suppress Blank Section but that's not working.

I've also tried to set up a formula to concatenate all the fields using '~' in between the fields and then tried a regular text export but that's behaving flaky with respect to the length of the detail record (sometimes it gets chopped off...sometimes it just appears in the export as blank).

Anyone ever run into this issue before?

Thanks in advance....

 

[kray4660]

Not sure what is going on, by any chance you have suppressed fields in the detail (i.e, data is there, you just can't see it).

 

[Madawc]

Export to CSV ignores conditional suppression, which I assume you must be using.

You could do a single large field with delimiters and then export it as text. Adjust the 'characters per inch' to 20 or 25 to avoid truncation, if the line is long.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP