Page 1 of 1
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Thu Dec 30, 2010 11:39 am
by BatutaBunsing
How do I supply the value for an SQL Parameter to a report when viewing it in the Designer?
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Fri Dec 31, 2010 2:30 am
by Alex K.
Hello,
If we understand you task correctly, you can use variable with "Request from User" options.
Please see the sample report in attachment.
Thank you.
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Fri Dec 31, 2010 11:03 am
by BatutaBunsing
I was able to accomplish this by specifying a default value (temporary) for the parameters which I have defined.
Nonetheless, the advice you gave also worked out fine.
Thank you.
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Mon Jan 03, 2011 12:43 am
by Alex K.
Hello,
Let us know if you need any additional help.
Thank you.
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Thu Apr 14, 2011 9:15 pm
by agriffiths
I have another question about the default values with the .Web Designer
If my SQL DataSource is "Select * FROM TableName WHERE ID = @ID"
I can set the Parameter for the Viewer but the Designer seems to only use the Default value
Is there a way to pass in the new parameter value to the designer preview?
Previewing Report in Designer With DataSource Containing SQL Parameter
Posted: Fri Apr 15, 2011 1:37 am
by Alex K.
Hello,
Alternatively, you can add a variable with the default value and put this variable into the parameter expression.
Thank you.