How do I set expression for a parmater in sql server reporting services?

Question

Hi All,

How do i set expression for a parameter in sql server reporting services r2?

Is it even possible?

The expression button is not even there.

Thanks.

score 2 · Accepted Answer · answered Aug 18 '11 at 06:19

I solved this through the web application, In the web application I use the report-viewer control to gain accesses to the parameters. With the parameters at hand I have complete control on what should be displayed (exression It's a workaround but it works.

score 1 · Answer 2 · answered Aug 17 '11 at 10:14

1

At design time in the parameters dialogue box just type in the expression for the default value if the button isn't there.

= Now()

If you mean at runtime, then no you can't.

answered Aug 17 '11 at 10:14

gbn

422,506
82
585
676

I tried =NOW() at the parameter prompt and it didn't evaluate the expression and just printed =NOW() as the parameter prompt – Aharon Muallem Aug 17 '11 at 12:11
At runtime, you can't do this, as per my last sentence above – gbn Aug 17 '11 at 12:39

How do I set expression for a parmater in sql server reporting services?

2 Answers2