Answered by:
Unable to view reports in Report Manager

Question
-
Hi all,
i am new to ssrs i need help form you,i have two questions
1)i have uploaded one report to Report manager
Here i want to see report if i click on report it shows as a following image
How can i see the reports here ?
2)i want to allow the users to only for view the reports ,if i give any role the users able to create new folder as well as new data sources
how can restrict the users ?
if any one know please help me
Thanks in Advance
srikanth
Tuesday, May 15, 2012 8:39 AM
Answers
-
Hi Srikanth,
Question 1: Publish a report to the report server from Report Builder
According to the screenshot, you are publishing a Report Parts (.rsc) file not a report definition (.rdl) file to the report server. Report parts are specific report items of a report, so it cannot be viewed like a report. We can create and store Report Parts on a report server and include them in other reports.
To deploy a report to a report server, please refer to the steps below:- Click the Report Builder symbol, select “Save As”.
- In the coming window, select the proper report server, highlight the target folder, and then click “OK”.
Question 2: Assign the Item-level roles on Report Manager
Reporting Services uses role-based security to grant user access to a report server. For a report server that runs in native mode, there are two types of roles: Item-level roles and System-level roles.
The Item-level roles are used to view, add, and manage report server content, subscriptions, report processing, and report history. We can assign Item-level roles on the root node (the Home folder) or on specific folders or items. In this issue, you can try Syed’s suggestion to assign Item-level role to specific user on specific items. Additionally, you can also custom Item-level roles by using specific Item-level tasks based on your requirement.
References:
If you have any questions, please feel free to let me know.
Regards,
Mike Yin- Marked as answer by sunny0817 Thursday, May 17, 2012 7:33 AM
Thursday, May 17, 2012 6:19 AM
All replies
-
Hi There
Please follow these steps it might work for you
1. Start Report Manager by going to http:/yourdmain/Reports
2. Click Site Settings.
3. Click Security.
4.If a role assignment already exists for the user or group for which you want to configure Report, click Edit.
Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: <domain>\<account>.
5. Select System User, and then click OK.
6. Click Home.
7. Click the Properties tab.
8. Click the Security tab.
9. If a role assignment already exists for the user or group for which you want to configure Report server access, click Edit. Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: <domain>\<account>.
10. Select appropriate access, and then click Apply.
If you would like you user to give just report viewing access please just give them browser role to the report folders it will restrict them just to view the report not anything else
Please let me know if you have any questions
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
- Proposed as answer by Amit Srivastava Tuesday, May 15, 2012 10:46 AM
Tuesday, May 15, 2012 10:26 AM -
hi
just give that particular folder to browser permission in reportserver.
indu
Tuesday, May 15, 2012 11:11 AM -
Hi There
you have to go to home first and give the browser permission there as well. please read my post above
Please let me know if you have any questions
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Tuesday, May 15, 2012 11:13 AM -
Hi guys,
Thanks for your response
if i publish the report using report builder i unable view the report in report manager but if i deploy the report using business intelligence studio i am
able to view the report ,guys can you explain what is the difference between two deployment.
Thanks in advance
srikanth
Tuesday, May 15, 2012 1:40 PM -
Hi Srikanth,
Question 1: Publish a report to the report server from Report Builder
According to the screenshot, you are publishing a Report Parts (.rsc) file not a report definition (.rdl) file to the report server. Report parts are specific report items of a report, so it cannot be viewed like a report. We can create and store Report Parts on a report server and include them in other reports.
To deploy a report to a report server, please refer to the steps below:- Click the Report Builder symbol, select “Save As”.
- In the coming window, select the proper report server, highlight the target folder, and then click “OK”.
Question 2: Assign the Item-level roles on Report Manager
Reporting Services uses role-based security to grant user access to a report server. For a report server that runs in native mode, there are two types of roles: Item-level roles and System-level roles.
The Item-level roles are used to view, add, and manage report server content, subscriptions, report processing, and report history. We can assign Item-level roles on the root node (the Home folder) or on specific folders or items. In this issue, you can try Syed’s suggestion to assign Item-level role to specific user on specific items. Additionally, you can also custom Item-level roles by using specific Item-level tasks based on your requirement.
References:
If you have any questions, please feel free to let me know.
Regards,
Mike Yin- Marked as answer by sunny0817 Thursday, May 17, 2012 7:33 AM
Thursday, May 17, 2012 6:19 AM