As far as im aware, Crystal isnt really designed for this.

 

On the last section of the report, i've setup the selection expert so that it adds a new page after the report completes, and i've set it to 'Not on last record' so the report doesnt show.

 

That all works fine, problem is that some text though is still slipping through such as some text and other blurb.

 

So basically, I wanted to unconditally suppress about 3 or for sections but wanted to know the formula how to do it.

 

So my question basically is, can I supress multiple sections in one part of the report only, and what the code is!

 

Many thanks in advance!

Let me see if I understand your question.

You have a report with something like:

Report Header

Pager Header

Group header1

Group header2

Details

Group footer2

Groupfooter1

Report footer

page footer

 

and you always want to suppress maybe group header1 and group footer2?

Since you say "unconditionally suppress" you do not need a formula. Use the Section Expert, pick the section you want to suppress and then check Hide (drill down OK) or Suppress (No drill-down) depending on which one you want the report to do.

 

Are we on the right track?

 

Hope this helps

 

 

Thanks for your responses.

 

To Clarify...

 

The report im writing is a quote, so it pulls the details out from the database and generates a nicely layed out report for the client to see. It then *must* display 3 or 4 pages of legal terms and conditions afterwards.

 

So to do that, I had it where the report footers had the text and the section expert to 'new page after' on the last part of the report (so the T's & C's would appear on the next page), now this partly works - it goes to the next page and you can see the T&C - however part of the report appears. Which is what I want to suppress, but only on the sections where T&C's are.

 

So from someone viewing the reports perspective they see:

 

Cover sheet (header)

Quote (Details et al)

T&C (footer).

 

Hopefully this clears it up a bit.

Sorry but I still need a little more clarity in what exactly is the problem.

You state "it goes to the next page and you can see the T&C - however part of the report appears." The entire thing is a report so I do not know what you mean by this. Is it details data, page header information or something else that is appearing. Where is it appearing? Only on the first page, on each of the pages displaying your T&C text? IN preview mode use the section identifiers displaying on the left hand side of your screen to help you figure out what section(s) this unwanted data is coming from. It may help you figure this out.

Andrew needs to suppress his page header on all pages after the last detail record runs (which is also set to start a new page on lastrecord).

Please correct me if I am wrong andrew.

Thanks.

 

Go to the Report Section, for the section you want, the page header and click the button for formulas...x-2 and put in you formula.

 

sorry, didn't read the request that DBlank asked.  Since it is after the last detail, in the same spot described, just enter OnLastRecord... this returns 'true' if the last record has been hit.  True-Suppress the section... it is kindof backwards, but it works

 

Hope this helps.

 

So with the formula, can I do an If statment? (sorry for the basic questions but im still getting used to using crystal reports).

 

 

Something like

if OnLastRecord = true then

{

[reportsectionx].suppress = true;

[reportsectiony].suppress = true;

}

else

end

 

(replacing [reportsection] for the sections actual name)

 

I know the syntax isnt correct, but am I on the right lines here?

 

 

Hope this helps

 

Yes but you will need to code in those respective sections,you can do it in two ways

 

Right Click Section X then Select Section Expert

 

or

 

Go to Reports Menu and Select Section Expert then select section X

 

Then in Common Tab of Section Expert

 

Click X+2 against Suppress(No drilldown) and enter the code below

 

 

 

 

 

Cheers

Rahul