Previewing Report in Designer With DataSource Containing SQL Parameter

[BatutaBunsing]

How do I supply the value for an SQL Parameter to a report when viewing it in the Designer?

[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.

[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.

[Alex K.]

Hello,

Let us know if you need any additional help.

Thank you.

[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?

[Alex K.]

Hello,

Alternatively, you can add a variable with the default value and put this variable into the parameter expression.

Thank you.