seperating 20% records

[suresh.cgmohan]

hi guys,

i am using cr11 and vb6.

in my cryatal report, first 20% of the table records should be presented.
how is it possible? i don't know how many records are present in table. in this case how can i take 20% of the items.
please give me a solution for this.

Thanks in advance

Regards
Suresh

[shakti5385]

Do you want to take only 20% of the record form the table then make a SQL query that give you only 20% or record from the table.
How to use the SQL query in the CR? For this see the crystal report tutorial at my signature.