Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
SSRS reports in Dashboard,crm 2011

Proposed SSRS reports in Dashboard,crm 2011

  • Thursday, May 03, 2012 8:27 AM
     
     
    Sign In to Vote
    0

    hi all,

    I have display the ssrs report in dashboard but i need to hide the menu.see the figure below

    Gangadhar

     

All Replies

  • Thursday, May 03, 2012 9:07 AM
     
     Proposed
    Sign In to Vote
    0

    Hi Gangadhar,

    Are you opening this report in an IFrame in dashboard component.

    In IFrame, embed the link of the report as:

    http://crm2011.crm.ashishmahajan.com/ReportServer/Page/ReportViewer.aspx?%2fAshishMahajan_MSCRM%2fCustomReports%2fMovies+By+Movie+Series&rs:Command=Render

    The link will have the path to your reporting server something as http://crm2011.crm.ashishmahajan.com/ReportServer/Pages/ReportViewer.aspx? and then your report.

    For that you first upload/deploy report to reporting server and then add the path in IFrame inside dashboard component.

    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.

    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

     
  • Tuesday, May 08, 2012 1:27 PM
     
     
    Sign In to Vote
    0
    Hi Gangadhar,
                            
    If the response answered your question and you are satisfied, please mark the response as an answer and also vote as helpful. This will help others to search on similar problems.
                            
    Thanks in advance.

    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

     
  • Wednesday, May 16, 2012 7:27 AM
     
     
    Sign In to Vote
    0

    Hi Ashish,

    I am also facing the same issue, &rs:Command=Render has no effect and one more thing URL which you suggested in your post has missing Keyword ItemPath.

    so is there any other way to do this???

     
  • Wednesday, May 16, 2012 12:31 PM
    Moderator
     
     
    Sign In to Vote
    0
    It is not possible to hide that menu if you are embedding the CRM report inside a dashboard. You could instead have your dashboard point directly to the report in SSRS so the CRM menu will not be there. You would need to make sure that the CRM report is published for outside use (you can do that by opening the report and then Actions --> Publish for external use). Then find the URL in SSRS and use that URL instead.

    Gonzalo | gonzaloruizcrm.blogspot.com

     
  • Wednesday, May 16, 2012 1:14 PM
     
     
    Sign In to Vote
    0
    Actually I am using Filteredview because report would be displayed according to user role, in report server data source property i am using Dynamics CRM Sql.when i run that report directly from report server it ask for credentials but when run from crm it get the credentials from crm and display that report now if i run that report directly which you suggested me then my question is how will i pass current user credentials.if there is any workaround or if i am doing something wrong please tell me thanks.
     
  • Wednesday, May 16, 2012 1:33 PM
    Moderator
     
     
    Sign In to Vote
    0

    You can publish the report so that you can access it directly from SSRS without having to authenticate to CRM (regardless of whether you use filteredviews or fetchXML).

    Did you try what I suggested earlier about publishing for external use? All you need to do is edit your report and select Actions --> Publish for external use.

    Then you can access your report via

    http://<SSRSServerName>/Reports

    Then browse your organization and the report you have published for external use should be available and will not require any credentials

    Gonzalo | gonzaloruizcrm.blogspot.com

     
  • Thursday, May 17, 2012 6:37 AM
     
     
    Sign In to Vote
    0
    I have tried what you suggested, it worked fine when run from CRM Admin account (same account is used for installing sql) but when i login CRM from some other user it gives me sql permission denied error for that user and I think it's logical because that particular user account is not part of sql user group.what should i do?????