How to Use Globals Collection in Query

[thermidor]

Hi All,

I am new to SSRS. Can someone tell me how to use values from the Globals Collection in a query? I want to capture the UserID and use that as a filter in a sql where clause.

TIA,
Sven

 

[xlbo]

In the parameters property of the dataset

Select the field you want to restrict then go to the expression editor and use it in there...


Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question