Running Reports Online - WAY TOO SLOW

[DianaStewart]

I am running a report by typing in the url in the browser. I am using Access 2000 as a backend. The database contains 30000 records. A majority of the fields are indexed. My report contains 3 parameter fields, Name, Date1 and Date2...

Here is what I have in my Record Selection forumla editor:

{DB1.Date} >= {?Date1} and {DB1.Date} <= {?Date2} and {DB2.Name} = {?Name}

It takes excatly 2 minutes for the parameter fields to appear online and then takes a good 15 minutes to run the report... this is way too long ...


I am actually quite disappointed with Crystal Reports, this seems to be a very common problem... How can you ask a customer to stay onlione for 15 minutes waiting, waiting and waiting...

Any suggestions?

 

[TedLiu]

in crystal designer mode, u can preview report, how long it takes? and also in the status bar u should can see how many records go through, see if the total number same as all your records, if it's same, means no problem, if it's much bigger amount, then still sql wrong.

 

[DianaStewart]

The problem is viewing the report through the browser it takes the parameter fields too long to appear on the screen..

 

[synapsevampire]

Hmmm, do you have parameters with a large amount of stored values (a pre filled picklist) in them?

How many parameters?

I have a few reports with 10 parameters with prefilled values that pop the active-X control very quickly.

What viewer are you using?

Is this Crystal Enterprise, or how are these reports invoked???

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[DianaStewart]

I have three parameter fields: Start, End and Name
Start and End are pointing to the dtpicker where I can select the dates from the control and the name parameter is pointing to a list of names entered into the parameter..

{Table1.Name} = {?Name}
and {Table1.Date1} >= {?Start}
and {Table1.Date1} <= {?End}

I am simply typing in the url of the report and then it loads up..

Ex:

http://webserver/folder1/test.rpt