Hi,

We are using CR 2008.

I have a report which we export as a csv file (~ seperated).
We have a header and footer in the report footer and page footer respectively. When the report returns data everything is fine.

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

But when the report doesn't have any data it's returning a line of all ~ (seperator character).

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

In this case I'd like to get...

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 '~' inbetween 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....