Multiple instance parameters

bmuskie

Hi,

I have a MySql long query (with subqueries insides) and need to evaluate 2 input parameters ( "date_fm" and "date_to") couple times.

Currently, I created multiple parameters (date_fm1, date_fm2, date_fm3, date_to1, date_to2, date_to3) under the Dataset and pointed to report's parameters accordingly.

The problem is the query will contain 6 "?" instead of a meaningful word. So, that caused a bit difficult when debugging the query because I really don't know the "?" is belongs to the "date_fm" or "date_to" (unless I go back parameter page and count for the "?" ) .

I've also tried to use the sql variable inside the query so I could refer it after. But for some reason, the query will run deadly slow if I use this approach.

I just wanted to know if this is already the proper way to handle it or there is some other alternative method?

Thanks!