danparker276
Top achievements
Rank 2
Rank 2
danparker276
asked on 06 Apr 2011, 02:25 AM
I'm wondering the best way to do this. Also I'm using silverlight report viewer so I can't give the reports the dataset.
I basically want to make the selectCommand dynamic like
Select a,b,c from tableA where d=1
if @paramter1="Z" then add " and z=1 " to the query
Select a,b,c from tableA where d=1 and z=1
I could do this by stored procedure, but I'd rather not add another stored procedure to my database.
I could use filters, but I'm going to get too many rows back.
Can I make another SQL DataSource and bind it to my Report based on a parameter I send in?
Can I use iff() in the selectCommand ?
Using a stored procedure will work ok for me. Just wondering if there's another way.
I basically want to make the selectCommand dynamic like
Select a,b,c from tableA where d=1
if @paramter1="Z" then add " and z=1 " to the query
Select a,b,c from tableA where d=1 and z=1
I could do this by stored procedure, but I'd rather not add another stored procedure to my database.
I could use filters, but I'm going to get too many rows back.
Can I make another SQL DataSource and bind it to my Report based on a parameter I send in?
Can I use iff() in the selectCommand ?
Using a stored procedure will work ok for me. Just wondering if there's another way.
1 Answer, 1 is accepted
0
danparker276
Top achievements
Rank 2
Rank 2
answered on 06 Apr 2011, 07:56 PM
Actually probably using a user function to change the datasource will work. I'll look into that.