when exporting to csv, how to have the header print at intervals

[zencalc]

I'm using Crystal Decisions Knowledge Base article c2006981 to print the header only at the top of the page when exporting to csv. Which works great, by the way. But now, I also have to print a second header after every 10,000 records. The conditional formatting for detail sections doesn't work when exporting to csv, so that's out. Can anyone help on this?
thanks.
Brian

 

[synapsevampire]

Try inserting a group that also holds the header info which is suppressed based on a formula like:

recordnumber/10000 <> int(recordnumber/10000)

-k

 

[synapsevampire]

Sorry, I should have mentioned that the group is a faux group based on a formula, containing some sure thing to place all rows in it, as in:

if {table.field} <> &quot;I never exist&quot; then
1
else
0

-k

 

[Reebo99]

SV:

Suppressed items are exported to csv. It's part of the export limitations.

Zencalc:

The solution is to export to a format which supports suppression (like excel), then create your csv file. Alternatively, create a string formula of all your information like :

{field1}&&quot;,&quot;&{field2}&&quot;,&quot;.....etc. then export this to text. You would have to convert all your numbers using totext({numfield},(decimal places),&quot;(thousand separator)&quot;) and your date fields using totext({datefield},&quot;dd/MM/yyyy&quot;)

For more information on export limitations goto :

CR8.5

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr85_exportlimitations.zip.asp

CR9

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr9_exportlimitations.pdf.asp

Reebo
Scotland (Sunny with a Smile)

 

[zencalc]

yeah, that seems to be the dog of it... that almost all conditional formatting and suppression rules are negated when exporting to csv.
thanks.
Brian

 

[synapsevampire]

Ahhh, thanks Reebo, it seemed to simple.

Hmmmm, fugly solution...

Can you export to a text file and code the CSV delimiters and carriage returns? The documenmt says that suppression is part of the export for a text export.

-k