The old reports are used by various users that don't want to have to dig into a file and put the desired query parameters into the raw SQL queries which makes sense since that is the whole point. However the only way I have been able to add user input parameters to my MS SQL reports has, while technically they 'work', resulted in a drastic increase in the time it takes to perform the required action.
Basically, if I hard code a parameter into the query it takes about a second, but if I "filter" the results using the parameter it has to return basically the entire table then grab the preferred portion... which results in increasing to 40-60 seconds depending on the report and the criteria/tables joined. So basically I'm wondering if any of you know of a way to directly use the parameters in the query itself. Basically like place a variable in the query so once you input the parameters I can use something along the lines of
where Table.Entry = Parameters!Param1.Value
Unfortunately that itself seems to just crap out when ran.
Anyways, if any of you have used the VS reporting tools or know of what I'm missing (I assume its simple and I'm just over looking something basic since I haven't used these tools much) I'd be appreciative. Thanks.