Designing a crystal report
I have designed a crystal report in the following manner
1.the report is grouping the data by column1 and then by column 2 i.e
2.the db object conatins nearly 70000 rows of data.
3.when the report is run it is not displaying data rather it runs for some time,later a run time error is thrown
Can some one suggest me a solution.
Graham Cunningham replied
1) Copy the SQL Query that Crystal Reports is generating from the Database Menu > Show SQL Query
Try running that query in a querying tool that matches your database connection method, odbc, oledb, etc... Are results returned from that tool?
2) Are there timeout limits on the database?
3) Can you limit the number of records returned to the report through record selection and does it run to completion? If so keep increasing the number of records returned until it fails
4) What is the error message you are receiving?