Designing a crystal report

[Former Member]

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

column1

column2

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.

Regards

babu

[former_member260594 · Accepted solution]

Babu,

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?

[Former Member]

Hi babu,

To proceed further with your query can you please provide following information.

1. What is the exact error message are you getting?

2. Which version of the Crystal Report are you using?

3. What type of database are you you using?

Thanks,

Sumit Kanhe

[Former Member]

Crystal vesion: 11.0.0

Database : Oracle 9.2

Errormessay : It's showing severerror and giving some timeout error(similar to any ASP or JSP page error)

Regards,

babu

[Former Member]

Are you reporting off one table? Or multiple tables?

If multiple tables - how are they linked?

70000 records should be no problem for CR. Two tables (or more) that are not linked could be the cause.

[Former Member]

The query is retreiving the data from the stored procedure,where internally view is used for retreiving data

Regards,

babu