RS2005 Drop-down list -- sql server reporting services

Terry
10/27/2005 11:54:04 AM

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!

[quoted text, click to view]

Renuka
3/13/2007 4:11:19 AM

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

Amarnath
3/13/2007 10:34:03 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : RS2005 Drop-down list