can 2 people view the same report using different parameters at the same time?

Hi, I am using sql server 2005 entreprise edition. I am just wondering when I have a report with parameters and the report uses stored procedure to retrieve the result set for use in the report, if two people from different places are trying to view the report at the same time, and each of them use different set of parameters.
Will they be able to view their report correctly?
Yes, each user will have different session and in each session report will be executes with user's parameters and users will see different report outputs.|||Hi Alexandre,
Sorry to bother you, this might sound stupid but if different users generate the report that will pass the parameters to a stored proc in master, then run different actions stored in the stored proc to return the result set tot he report, will it affect the report output?
Thanks
|||

When two different users run report on report server or stored proc on sql server, those runs will be in two different contexts, so unless you have some shared global variables in your report or stored procs, the executions will be independant.

By shared global variables I mean something like global variables in VB.NEt code embedded or called from report expressions. In the case of SQL stored procs this could be a global temp table used to store intermediate computation results. If you have nothing like this, then you should be fine, two executions will not collide.

|||

Is there a way to store temp data in user's session variable in report server or is there a way to store user specific data in report server?

For example, I have 3 textboxes (1, 2, 3). Textbox 1 allow user to search for country (say type in A), then the country search result will be display into textbox 2. Now, user can choose which country they want from textbox 2 by ticking the country multi select dropdown and the selected country will be display in textbox 3.

Now, if user go back to textbox 1 and search for another country (say type in B), textbox 2 will be refresh and shows list of country starts with B with previous selected country still in textbox 3. How can I achieve that?

Can I access to the request object or the server object in report server so I can save/store the selected country into user session/request object?