| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-02-07 : 10:43:54
|
| When deploying reports to the ReportServer, my subreport seems to be showing under the contents tab. Is there a way to hide subreports so that the user only sees the main report? If yes, please let me know where to do this, either in the Report Design or Reporting Security.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 12:32:47
|
| Why are you allowing your users to get to ReportServer? Don't you have a custom web app built in front of the reports and just have links to the ones that you want them to see?Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-02-07 : 12:37:30
|
| I meant to the Reports page. Like this: http://<server>/ReportsThat's what I'm using. Not sure what other users do, but I just use the Reports web page for this. Is this not a good idea? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 12:43:32
|
| That's Report Manager. We don't allow our users to get to that either. We have a page in our web app that displays the links to the reports. Due to our security architecture, we then had to use MS' Report Viewer. Most others won't need to use this. So on the web page, you'd have links to the reports via the URL Access way. I'd read up on URL Access in SQL Server Reporting Services Books Online.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-02-07 : 13:42:19
|
| Thanks for the information. I will read up on that. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-07 : 13:57:37
|
You definately don't want those users looking around the report manager, since security as well as data sources are on the report manager web page as well. What you can do is provide them with a stripped down version by just creating a page as tara has suggested to those links. Besides, what happens when your company decides report server is the tool the company will use for 10 other applications. You dont want your users to go looking through 100 different reports for 10+ applications. The only person who can see the report manager page in the company I work for is me :). Your front end application could also have some tab layout or page showing the various kinds of reports. You can then open the report in a frame and have the MS report open in the lower frame. That way you can eliminate the options at the top of RS.Good luck,Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-02-07 : 14:55:53
|
| Yeah that is what I was afraid of. Also some reports, only certain people have access to. I'm curious though, can't you set the security in the Report Manager so that only users see the reports and not folders or datasources? Also can't you set the security so that they can't go to the Site Setting section and only admins are able to go there? For security reason, it might not be a good idea to have direct access to the Report page as suggested by you or Tara though. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-07 : 14:58:34
|
quote:
Originally posted by chriskhan2000
Yeah that is what I was afraid of. Also some reports, only certain people have access to. I'm curious though, can't you set the security in the Report Manager so that only users see the reports and not folders or datasources? Also can't you set the security so that they can't go to the Site Setting section and only admins are able to go there? For security reason, it might not be a good idea to have direct access to the Report page as suggested by you or Tara though.
Yes you can but you will have a lot to manage when it comes to security permissions. For instance, in RS you can define "groups" of people to view specific reports, however you will need to manage those groups. Which may eventually change over time...Ya life really is difficult :( why cant we all just follow the rules.Then again it comes back to knowledge being the most dangerous thing on this earth!
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 13:13:16
|
| Can any one of you suggest me a link or a book to read about how to provide the integartion of RS with the front end applciation.A code snippet will also do. Thanks.--King |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-28 : 13:15:49
|
| SQL Server Reporting Services Books Online is what I would read to learn about this. Do you have this installed?Tara |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 14:10:40
|
| Thanks.The thing is we are still in the research phase and i was looking at reporting options. but i can read around online.I have a quick question do you think its possible to have an asp 3.0 application which does teh authentication part ( only authorize users are able to see the reports and only the required reports)Also the application invokes the reports and display them in the brwoser if you could give an outline how to do this i would higly appreciate that.THANKS.-King |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-28 : 14:15:06
|
| Yes it is possible. You would use the URL method to pull up reports. This is described in detail in Books Online, which should be available for online viewing in MSDN.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-28 : 14:16:03
|
quote:
Originally posted by kingreen
Thanks.The thing is we are still in the research phase and i was looking at reporting options. but i can read around online.I have a quick question do you think its possible to have an asp 3.0 application which does teh authentication part ( only authorize users are able to see the reports and only the required reports)Also the application invokes the reports and display them in the brwoser if you could give an outline how to do this i would higly appreciate that.THANKS.-King
Well RS runs through a browser much like sharepoint, have you used sharepoint in the past? For security reasons you need to add / modify groups to view specific reports (this is all done in the report manager). As for your front end interface you can strip RS down to the HTML OWC and slap it into a web frame, that way your users ONLY see the actual report and nothing else including the security settings etc. If you don't do this you have to properly secure the rs page for each individual user.Your authentication can be done through your asp 3.0 application, however that would be handled on the client end. Your report will run either way, but you will have to handle the security on your own.As for books, I wouldn't spend a dime, I wasted money on 2 useless RS books. Just research online, MS's site has some examples, and their are a few experts in here.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 14:39:40
|
| Thanks a lot guys,you have been great help.Two more question .....what do you mean when you say "Your authentication can be done through your asp 3.0 application, however that would be handled on the client end. Your report will run either way, but you will have to handle the security on your own"i thought was once you authenticate user using asp that would be all and would have the access to the right reports ??? isnt that the case or i need to pass some kind of authentication (username/pass) to the server for groups ???Also when we do HTML OWC does the report becomes static or its generated every time the asp link is clicked (i mean updated report)??THANKS--King |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-28 : 14:43:06
|
quote:
Originally posted by kingreen
Thanks a lot guys,you have been great help.Two more question .....what do you mean when you say "Your authentication can be done through your asp 3.0 application, however that would be handled on the client end. Your report will run either way, but you will have to handle the security on your own"i thought was once you authenticate user using asp that would be all and would have the access to the right reports ??? isnt that the case or i need to pass some kind of authentication (username/pass) to the server for groups ???Also when we do HTML OWC does the report becomes static or its generated every time the asp link is clicked (i mean updated report)??THANKS--King
The report is updated every time you run, it makes a trip down to the db refreshes the data and outputs. You can also manually refresh the report by clicking the refresh icon on the RS toolbar.What I mean by authentication is it sounds like your application handles various users / groups differently no ? Meaning certain users are only allowed to view reports, in addition, accounting sees all the money reports and engineering has no access to it. If this is the case you have 2 options:1) Handle it in RS by creating groups (Accounting / Engineering in my the case given above) with permissions for the specific reports. These groups are just your NT user names.2) Handle it from the client end (application / web page) check whose trying to run what and allow / disallow.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 15:13:51
|
Hi Jon,Thanks for your prompt reply.The thing is in our application the content should change based on login. Each user will have its own set of data but the type of report remains the same so i guess i would be going with the second option.Also sorry for asking again and again but i am totally new to rs thats why ?what i am planning to do is on the asp page htere would be a link to the page where i;ll have the HTML owc content. The question i have is when i click on the link which takes me to the HTML owc content page would the content be refreshed automatically for me or i have to do something in the report manager for it to happen whenever the link is clicked.Thanks |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 15:26:14
|
| To be precise i am planning to send the username as one of the parameters to the report and then get the reports based on the parameter passed.so that each time the report generated is diffenet depending on the user logged in.Thanks.--King |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-28 : 15:29:13
|
Yes it will refresh automatically.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-02-28 : 15:30:29
|
quote:
Originally posted by kingreen
To be precise i am planning to send the username as one of the parameters to the report and then get the reports based on the parameter passed.so that each time the report generated is diffenet depending on the user logged in.Thanks.--King
I dont know if I like the sounds of that, I would think the data is dependant on the user right? So why doesnt your stored procedures handle this ? Your stored procedure is capable of ensuring specific rights to specific individuals. If the user does not have the rights he / she cannot retrieve the data.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 15:41:49
|
| Thats right jon. The data is dependent on the user. so you mean to say that i pass the user name to a stored procedure and use this procedure to popluate the reports ??? |
|
|
|
kingreen
Starting Member
12 Posts |
Posted - 2005-02-28 : 15:47:05
|
| Also can i provide links in the reports to the other reports or subreports ( in the html format )?Thanks |
|
|
|
Next Page
|
Deploying Reports