Problem in Processing Records.

[npkapasi]

there are say 5000 recoreds on server whihc keep on growing.I want to display only one recored out of 5000 on client side based on certain value passed.Report is working and it displays only one record but it process and fatch all 5000 records on client side which takes lots of time.it displays Record 1/5000 insted Record 1/1.

Can you suggest something for this problem.

 

[kenhamady]

What type of database are you reading?

What is your record selection formula?
What is your Group selection formula?
(See the report menu in Crystal)
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[MalcolmW]

One other question - is your datasource a table, view, or stored procedure? Malcolm

 

[npkapasi]

First of all i like to thank you for replying.I am using SQL server 7.0 as a database and i am rading from group of tables with self and outer joins.There are lots of subreports used in the report.There is no Record selection and group selection formula used but from Visual Basic
I have used this code.

*****************************
FORMULA = "{tbljobhdr.jobid} = '" + jobid.Text + "'"
JobticketRpt.SelectionFormula = FORMULA
*****************************

let me know if you have more doubts.

 

[kenhamady]

Yikes!
Unless you have a record selection formula, you will return every record in the main reports tables. This formula is your criteria. Which record out of the 5000 do you want, the one where the value matches the value passed? Define that in the selection formula. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)