tlhawkins
Posts: 16
|
| Posted: 12/27/2006, 4:17 PM |
|
Hello,
This is the first time I've needed to make a report with CCS. I have the report working how I want with all the search fields. The only problem is that the report takes very very long to run and is completely useless without filling in at least one of the search fields. So loading the page the first time sends the server CPU to 100% for about 30 seconds, then after entering search criteria it works smoothly.
My solution was to hide the report unless there were form variables available. So I used:
datasourcename.Visible = False
I added this code to the Datasource's Before Select Event.
That made the report not show, but the query still ran taking all the time and CPU that it would if it had shown.
There must be a better way of doing this where I can stop the database from being queried if the page is being loaded for the first time.
Thanks
|
 |
 |
carlosespada
Posts: 5
|
| Posted: 12/27/2006, 6:04 PM |
|
Try setting one of the parameters to NULL default or to -1 on the reports data source. This will prevent any data fro loading on initialization.
_________________
Skysoft Incorporated- A Professional Software Development Company |
|
|
|
tlhawkins
Posts: 16
|
| Posted: 12/27/2006, 9:07 PM |
|
I got that to work to NOT display the report... but for some reason it wouldn't then use the value I selected on the form... crazyiness... so, right now I'm just adding a URL variable on that keeps it from displaying the report but still lets me use the form.
Thanks for the help
|
|
|
|
|
