Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Designing a crystal report

Hi All,

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.



Former Member


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?

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question