Upon reading Chapter 4 - Filtering Data with Parameters, I wanted to get any ideas on how to increase performance when running a report that has 4 parameters, only 1 of which is dynamic.
The report allows the user to pick any combination of 4 parameters such as work order number, activity(this prompt is dynamic), start date and end date.
Let's say the user is selecting only on work order number and leaving the other parameters blank. Because there is a dynamic prompt on activity (which the user left blank) is my report running slow because it is going out to the database? If that is the case, is there something on the front end so that it can ignore going out to the database when it is not necessary since that parameter was left blank? Thanks in advance!!
I should probably mention that my report contains 6 subreports as well.
Edited by sandy - 23 Aug 2007 at 9:38am
IP Logged
