Don't want the header and footer on every page when exproting

[snuss]

I am exproting a pretty simple report to a Character-separated values format with : as the separator and " as the delimter. and then changing the file name to a .txt file.


My header is in the Report Header, and footer in Report footer.

but when exported it looks like this.

H;504624;20060703;R;2;"MURDOCK, JERRY";0.00;"T:1"
H;504624;20060703;R;3;"WICHITA CHILDRENS THEATRE & DA";0.00;"T:2"
H;504624;20060703;R;4;"MARLOWE, CURTIS/LINDA";24.95;"T:3"
H;504624;20060703;R;5;"Zz TJADEN, RHONDA";0.00;"T:4"


but i am wanting it to look like this

H;504624;20060703;R
1;"Deleted Subscriber";-2570.93;
2;"MURDOCK, JERRY";0;"66215"
3;"WICHITA CHILDRENS THEATRE & DA";0;"67211"
T:45440

I did some searching and did not find anything, sorry if this is a simple question but I am pretty new to Crystal Reports! I'm an Access junkie.... but I am using v.8.5.0.218


Thanks in advance for any help given!

 

[paulmarr]

One way of accomplishing an export without the header/footer information is to export to Excel (Data Only) - untick the Export Page Header and Footer Box.

Then save the Excel file as a csv - and specify what you want to use as the delimiter.

Cheers
paulmarr

 

[kskid]

Creater a fake Page header

//@FakePH
WhileReadingRecords;
1

Insert a Group on @FakePH. If you have other groups, then move FakePH to Group Header 1.

Move your column titles from the Page Header to the FakePH group header.

Suppress Page header

Export to csv

-lw

 

[snuss]

thanks for all the info!!

just one question, how do you create a fake page header. i did it in formula fields, but that won't let me add my column titles to it...

thanks!
stacie

 

[kskid]

Did you insert a group on @FakePH?

Click on Insert->Group and select @fakeph from the dropdown list

Your report canvas should look like this

Report Header (suppressed)
Page Header (suppressed)
Group Header 1 - @fakePH (place you titles here)
Detail
Group Footer 1 (suppressed)
Report Footer (suppressed)
Page Footer (suppressed)

 

[lbass]

Comment: When you insert the group you also have to set the group options to "Repeat group header on each page". If you inserted the group without setting this, go to report->change group expert->options->repeat group header on each page.

-LB

 

[snuss]

you guys have been great!!! I am soo close!!! i'm doing this so i can make an automated process so i don't have to upload this file every morning!

i'm this far now...this is what it looks like when I export it thru Character-seperated values

H;504624;20060706;R;2;"MURDOCK, JERRY";0.00;"66215"
3;"WICHITA CHILDRENS THEATRE & DA";0.00;"67211"
4;"MARLOWE, CURTIS/LINDA";24.95;"67220"
5;"Zz TJADEN, RHONDA";0.00;"67217"
45491;"ROGERS, RICH/WILMA";94.85;"65714"
45493;"CHO, JUNGHUN";62.90;"21076";"T:45490"

but i don't want the header and footer in Character-seperated values i want it too look like this

H;504624;20060706;R
2;"MURDOCK, JERRY";0.00;"66215"
3;"WICHITA CHILDRENS THEATRE & DA";0.00;"67211"
4;"MARLOWE, CURTIS/LINDA";24.95;"67220"
5;"Zz TJADEN, RHONDA";0.00;"67217"
45491;"ROGERS, RICH/WILMA";94.85;"65714"
45493;"CHO, JUNGHUN";62.90;"21076";
T:45490

is there any way to exlude my group header and group footer from the csv? and for it not to be on the same line as the data, but have the header the line above and the footer a line below?

thanks everyone very much!!

 

[snuss]

*edit*


the problem is that is combining the header record with the first detail record and the last detail record with the footer record.

THANKS!