CR 10 Slow in Retreiving records

[fredong]

I am using CR 10 and the report is run through a backend procedure for Aging. When I ran t the proc through the backend with the paramters it took less then a minute to retrieve 1 year of data. However, when I run through CR 10 developer version it took basically took more than 2 hours to retrieve the records. The backend of the database is SQL Anywhere v 9.0. Please help. Thanks.

 

[synapsevampire]

If it's a stored procedure, then it seems odd that the time woudl be widly differnt unless you're retrieving houdreds of thousands of rows and perhaps formulas and filtering are slowing things locally.

How many rows does it return?

Are you doing anything locally?

Use a subreport?

If you simply add the SP as the data source through teh Crystal GUI, and just place a field in the details it *should* be fast.

Anotehr option might be to try using a Command Object (listed under the data source as Add Command) and executing the SP through it, not sure what the suntax is for executing SQL Anywhere SPs, perhaps:

execute sp_name 'parm1', 'parm2'

Anyway, that might prove faster.

If not, post some details.

-k

 

[fredong]

It returned 60,000 rows

On the report there are 4 groupings and detail section is suppressed. There are about 10 formulas. On the Record Selection formul choose Group I have Amount group by invoice that is <> 0.

Subreport is not an option for me

Adding the SP as a data source and I have place 3 fields on a blan report. It is like watching ice melting to retrieve the each record.


Command object I have not try yet -- I will try it

Anothe thing a out SQL anywhere is that running the SP from the backend the rows did not retrieve all at one time. I have to scroll down to fetch the rows.

Let me if the informaton is sufficient. Thanks.

 

[synapsevampire]

Well yhou shouldn't be using a GROUP SELCTION FORMULA, thsi should be done in the SP.

I can see how it might be slow as a result.

The last post was a tad disjointed, please identify:

"Adding the SP as a data source and I have place 3 fields on a blan report. It is like watching ice melting to retrieve the each record."

Is this when it retrieved 60K rows?

That's not much...

Are you using the exact same parms as you do when you run it in the external tool and it's quick?

-k

 

[fredong]

this is when I retrieve 60 K records on the report and I am using the same parms just like the backend. This is on a blank report. Is this something that Crystal has a problem retreiving 60 k records from a proc and it talk so slow without any groupings or formulas? Any ideas. Thanks