Exporting to rtf problem;

[davefm1]

Hi
I am exporting a crystal report to rtf. the report has two report headers a,b for pages 1 and 2 and there page headers A,B,and C.

The page header A starts at page three. However, when exported page 3 doesn't show the page header and all other pages 4-17 show page headers over written by detail section.

Each page header has a section field assoicated with it called section with a value of 2,3,4 for the correct page header. i use a suppression formual to select the correct page header.

For page header A
iif({rpt_this_report.section}<>2,true,false)

What I'm wondering is there any way to keep the first page header on page three and the rest of the pages it belongs on with out it being over writen by corect detail detail section. Yes three are three detail sections A, B, C

Any help would be appreciated.
Dave

 

[HowardHammerman]

Does the report display correctly within Crystal but get confused when you export it or is it not correct in Crystal.

If the problem is in exporting, welcome to the club. Crystal is simply not great at exporting to *.rtf. It is better (somewhat) at exporting to *.pdf.

If the problem is within Crystal, you would use the section expert to conditionally suppress sections based on the page number. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[kenhamady]

I am not sure I understand your structure, but part of the problem may be that Crystal leaves the pagination up to the receiving application, so what you expect to occur on a certain page in Crystal, isn't there in another application. Just out of curiosity, does it do a better job if you export it to WORD? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[davefm1]

Thanks Ken & Howard for responding.

1. The report looks great in crystal on the web and prints great from the web as a crystal report.
2. We dicided to export in rft because of to many problems with word exporting.

3. I presently have the 2 report headers and the first page header and all pages details sections from over writing one another. However, the second and third page headers are conditional meaning one or the other still over write the detail section. I will try exporting to PDF before, I try changeing the 2nd and 3rd page headers to group headers.

4. How do you set group header to repeat forr each new page only.

Thanks Dave

 

[kenhamady]

You get the group header to repeat by using the Change Group Expert. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[davefm1]

Ken;

When I set new page before to a formula for group header
IIF(Previous ({rpt_report_complete.section})={rpt_report_complete.section},false,true) the rest of the page is blank and detail section shows up on next page, not with page header.

I also set the supress formula box to IIF(Previous ({rpt_report_complete.section})<>3,false,true)

Any insight to removeing the blank section under group headerso deatail section fills in would be help full.

Dave

 

[kenhamady]

I still suggest that you see if WORD exports behave differently. That will tell you if the problem is with CR or with the RTF format.

Why are you using a conditional page break to check for a change of your group field? Can't you simply check New Page Before on the Group Header for the field &quot;secton&quot;? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[davefm1]

Hi Ken;

I have tryed exporting to word it is a lot worst then rtf.
there is a new exporting patch DBEXDRVR.zip which will make word look as good as rtf. But first I have to fix the report in rtf.

The condition page break for section 3 or 4 is to show only one of those section base on the fiscal year.

So I have 2 report headers and 1 page header that will always show. Then either section 3 or 4.

1. I have been tryed to use three different page headers but that dosent't work.Because, the fist still shows up on top of the second page header with the detail sectiuon overlaying the second page header.

2. I try useing group headers with supress formula box to. IIF(Previous ({rpt_report_complete.section})<>3,false,true)
so only one section will be displayed.

3.The problem with this right now is that the page header shows up on the first page of section 3 but not on the second page still shows up on top of group header for the first page of section 3 the second page has know groupheader just detail section and the last page just a group header no detail section in crstal reports.

If i export I still have page header on top of ever page of section 3 along with those above.

Any suggestion.

Thanks Dave

 

[kenhamady]

I am afraid that for me to troubleshoot this question further would require more effort than I can devote to a Tek-Tips thread. You might want to consider getting an expert to look at the report. There are several experts here (you can tell by looking at our signatures) who are also available for rent. Please make contact outside of TT, since recruiting is not allowed here. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com