Top N Record. How to control N through parameter

[baijuthakkar]

Hello everybody,
Can anybody help regarding controlling the TOP N Record through Parameter. Means if i select Record count = 10 then report will only list Top 10 Customer.

[baijuthakkar]

Hey no one came across this problem ...of controlling the TOP/Bottom Record through parameter. Its something like this...... I want Top 100 Customer based on sales. But what i need too is All Customer Based on sales. So instead of posting two report i can do the same two report into one if i can controll the number of records for TOP/BOTTOM through parameter

[baijuthakkar]

Hello everyone.....
If you dont understand the problem...please comeback and let me know....But atleast leave some feedback on this query. Common please share with me your years of experience.

[baijuthakkar]

hello K.BABU...common come up with some idea? cant you control the recordnumber or groupnumber function in special function throught parameter... someone should definately have clue to this problem...

[Madhi]

Use a Formula @Count having the code

Numbervar s;
whileprintingrecords;
s:=s+1;

Now goto section expert of details section and in the suppress option there is a button labelled x-2. click that button and write this code

if {@Count}>10 then true

[baijuthakkar]

First of all thanx Madhi for your help. Will this work for Group footer(GF) or group header (GH) too. As i have displayed my GF result and suppress the detail section. So what i want is to control the records in my group footer through parameter.

Thanx
Thakkar

[baijuthakkar]

Crystal Version X1 support this feature. controlling N through parameter. If any one have other ideas to do so in version 8.5 please let me know asap. My data is in Group Footer 4 i.e. i have 4 groups and displaying only the group footer 4.

Thanx
thakkar

[Madhi]

What are you showing at the group footer.
Can you post sample data?

[baijuthakkar]

What i have in detail is my sales data from the Month Table---->which is then group by product----->then by ------>department------>then by customer.
I am showing the Grand total of all the customer in the group footer.

something like this
GH3--CUSTOMER
GH2--Department 1
GH1--Product X
Detail section Month Jan --------1000 SUPPRESS
Month Feb-------- 2000 SUPPRESS
GF1 Total for Product X----------3000 SUPPRESS
GF2 Total for Department 1----3000 SUPPRESS
GF3 TOTAL FOR CUSTOMER Mr--3000 - Want to control no. of top
customer displayed through parameter


Hope you get hang of it what i want.


Thanx

Thakkar

[Madhi]

Try this

Place the fomula @count at GF3 and in the section suppress event write the code

if {@ParameterValue}< {@Count} then true

[baijuthakkar]

Thanx
Madhi its working the way i want to.
But on top of this one more help if you can. Actually it does read all the data and works while printing. so no improvement on performance side. Is it possible that only the data brought back from the server is the no. of records we selection and not all by default.