Can export to XLS but NOT to CSV

[jmueller]

Hello everyone,

I have a problem that I have to believe has a simple resolution... hope someone can help me:

Quick overview of what i'm trying to do: I am trying to export "monthly statement" information to a CSV file where we would then send the CSV to a company for printing of the statements.

My crystal report has one detail line. On this detail line is the customers header info (i.e. name, address, etc) and a SUBREPORT that prints each open invoice and payments made towards the invoice for the customer. SOOO, for every invoice record, the header information gets printed again. Like such:

CUSTOMER NAME, ADDRESS, INVOICE #1, INV AMT, INV BALANCE
CUSTOMER NAME, ADDRESS, INVOICE #1, PMT AMT, INV BALANCE
CUSTOEMR NAME, ADDRESS, INVOICE #2, INV AMT, INV BALANCE

When printing to an XLS, it works fine. BUT, when printing to a CSV or anything other than an XLS, it only prints the Header info (Customer name & Address) and cuts off the invoice information. BUT IT DOES repeat the header info as many times as there are open invoices for the customer... so it's like it's seeing the invoices, just not printing them.

Anybody have any ideas?

Thank You!

Jack

 

[RWahlert]

Why are you running a subreport? This may be why you cannot export to the CSV format. You should be able to return all the data you need without the suberport. Does your table contain both invoice and payment data? You should look into doing everything in one report.

 

[kskid]

As far as repeating the header with each row, see

http://support.businessobjects.com/library/kbase/articles/c2014451.asp

-lw

 

[jmueller]

Thanks for replying!

To RWahlert, I didn't write the report and am not well-versed in crystal to say the least, but I imagine the sub-report was created because of the one-to-many relation. For each invoice, their can be multiple payments and/or credits applied.

Also, thanks kskid for the link. I'll try it out.