RS2005 Drop-down list

This there a way to increase the time it takes when users select items from
the drop-down list.
Please note that the drop-down list is setup to extract data items from
backend database (from query). (also, using multi-value selections)When I run the report in Visual Studio, it quick and runs as expected.
However, when the report is deployed and ran, its seems to be slow.
Thanks!
"Terry" wrote:
> This there a way to increase the time it takes when users select items from
> the drop-down list.
> Please note that the drop-down list is setup to extract data items from
> backend database (from query). (also, using multi-value selections)
>|||Hi everybody,
i'm just started using the Reporting services...
I want to display all the staff name in a dropdown list or combo box.
and based on the staff name the report is displayed...
can any one help me..
Thankx in advance
ren
From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Many ways you can do this.
1. Write your own custom code so that depending on the user you can display
reports.
2. If you are storing all your staff name in a table you can query the table
for the dropdown and once it is selected, the name is passed to a stored
procedure and the stored procedure runs the query depending on the staff.
e.g. some staff should not see somethings etc...
Let me know where you store your staff names..
Amarnath, MCTS.
"Renuka" wrote:
> Hi everybody,
> i'm just started using the Reporting services...
> I want to display all the staff name in a dropdown list or combo box.
> and based on the staff name the report is displayed...
> can any one help me..
> Thankx in advance
> renu
> From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

RS Instance Footprint

Hi!
Does anyone know the footprint of an RS instance? Does it increase proportionally with every instance or is there some shared pool? If I have 10 instances of RS is it really like having a full 10 separate RS running or are they all pooling?

Thanks

With the exception of the ReportServer/ReportServerTempDB databases, there are no shared resources. From a memory perspective, the OS may share code pages between processes just like it does for any other process. A good portion of the code running in Reporting Services is CLR code, so that complicates code sharing to some extent since the code is JIT'ed per-process.

|||Ouch! So every instance is actually a full instance eating up tons of RAM. Oh well, I was working on a 1 instance solution anyways, thanks.