I'm using CR8 with a datasource of a View from SQL Server and Visual Basic 6 as the GUI.
When launching a Crystal Report from a Visual Basic program, the main page displays very quickly (about 20 seconds for about 1200 records).
But when I want to switch from page 1 to page 2, etc., it takes a long time (about 20 seconds) and seems to be executing the query again against the backend database.
Is there some setting I can change to speed up performance between switching pages or would the crviewer be a quicker alternative?
I can also post the View I'm using if that would help.
Thanks in advance.
When launching a Crystal Report from a Visual Basic program, the main page displays very quickly (about 20 seconds for about 1200 records).
But when I want to switch from page 1 to page 2, etc., it takes a long time (about 20 seconds) and seems to be executing the query again against the backend database.
Is there some setting I can change to speed up performance between switching pages or would the crviewer be a quicker alternative?
I can also post the View I'm using if that would help.
Thanks in advance.