Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Taking too long for parameter fields to appear

Status
Not open for further replies.

DianaStewart

Programmer
Apr 16, 2002
58
CA
I am using an Access 2000 database and running the report through a web browser simply by typing in the url of the report in the browser. I changed the connectivty from direct to odbc this improved the speed overall of the report but the only problem I have is that as soon as you type in the url of the report it takes a good 3 minutes for the first parameter field to appear on the screen.

In the Report\Record Secltion Formula I have this as my query:

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

I love Crystal Reports but this speed problem is a major drag.. can anyone please help me out?

Diana
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top