Top N

[unknownly]

Hi All,

Can we do Top N and Bottom N in the same report. Using CR 10 and Oracle 9i.

Currently, Iam doing this as 2 subreports and a main report

Main report show Top N
Subrpt 1 shows Bottom N
Subrpt3 shows Full report

which uses the same SQL 3 times. Is there any other way I can do this

TIA,
Sweetie

 

[IdoMillet]

You can use a suppress expression to show Top & Bottom N.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[unknownly]

How do we use the suppress logic? Top & BOttom N is done on the same group

TIA,
Sweeite

 

[IdoMillet]

Do you know what the suppress expression for a section is?

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[unknownly]

Yes, I know what is section suppress mean. But is Group sort for Top 10 or Bottom 10 can be done by section or for a report?

TIA,
Sweetie

 

[IdoMillet]

The group sort is done using ALL.
You then suppress the groups in the middle using a conditional expression of your choice. For example:

GroupNumber > 5 AND DistinctCount({Customer.Customer Name})- GroupNumber > 4

will show top and bottom 5.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[unknownly]

Cool, It worked. Thanks a ton..

This is where I was struck with the report

Sorted by ID( group1) and sorted Amt by Desc order
then in group section 1A suppressing if


@Group1a:
Groupnumber in [ 1 to 10] gives in TOP 10

Group section 1B suppressing

@group1b:
if lastrecord then
???? How do I say to print last 10 records for Bottom 10??


Thanks again,
Sweetie

 

[unknownly]

Facing another problem...thought I could trackle it so did not mention it before.

I did this on a new page. I will need to print the TOp 10 in one page and the Bottom 10 in a New page

TIA,
Sweetie

 

[IdoMillet]

Set the New Page Before expression of GH1 to

Groupnumber = 11

- Ido


view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[unknownly]

How can I get the whole full report printed starting on a new page after the TOp 10 and Bottom 10 report has been printed? Can this be done?


TIA,
Sweetie

 

[IdoMillet]

Yes. Insert an unlinked subreport in the report footer.

Please start new questions as a new thread.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com