locked
Unable to view reports in Report Manager RRS feed

  • 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:

    1. Click the Report Builder symbol, select “Save As”.
    2. 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.

    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:

    1. Click the Report Builder symbol, select “Save As”.
    2. 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