Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smithouse
Starting Member
1 Post |
 Posted - 2005-09-28 : 18:15:54
|
| I'm building an ASP.Net application and am planning to use RS as the report engine. I'm just learning RS, so I don't know all of its capabilities. Can I call a report from my application and somehow pass the current user's username, which will then be passed to the report's DataSource?I want to do this because the database will store data for 20 different facilities but each user will only be able to see his facility's data. I don't want to have to create 20 different versions of each report in order to restrict the data.I'm not asking for all the details on how to do it at this point, just if it can be done. Well, maybe a few details would be helpful to focus my research.Thanks |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-09-29 : 03:17:30
|
| That's a good question, I'd be interested in the answer to this too.I suspect that one option is to send the user name in the URL so that it can be passed to the sproc generating the data, though there may well be other options such as using cookiessteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-09-29 : 11:33:55
|
What you have described is nothing new, and of course it is possible in reporting services. The reporting services engine accepts table direct / stored procedure type datasets. A stored procedure allows for parameters. The parameter can be placed into the url and read into the dataset and the actual report.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Can RS do this?