Hey all, I built my SQL query elsewhere and want to pass parameters to it with @param style. I inserted it in "Select Statement" window and created parameters in reporting with values, yet it doesnt map. If I do it with built-in query builder, it maps and works, simply because in next page it allows you to put the parameter location like @param will be equal to '= Parameters.slevel.Value'
But I can't use built-in query builder in this project, how can I make this work?
Thanks!
I am not sure if I understand the problem correctly, maybe you can send us a video that demonstrates the issue? Basically, you can use a parameter for the SQL statement, the approach is described in the Change Connection String dynamically through a report parameter KB article.