none
Hiding a Report's toolbar

All replies

  • Friday, August 16, 2013 11:26 AM
  • Hi B sreenivasulu,

    Unfortunately the reports will be included in the Dashboard and there is no option to add Custom JS there.

    Friday, August 16, 2013 1:32 PM
  • Hi,

    Is your report rendering properly? I think command should be &rs:Command=Render&rc:Toolbar=false at the end.

    Try the below blog.

    http://nishantrana.wordpress.com/2012/10/20/hiding-tool-bar-from-the-ssrs-report-while-using-them-in-dashboard-crm-2011/

    http://msdn.microsoft.com/en-us/library/ms152835.aspx

    Hope this helps!

    Friday, August 16, 2013 6:57 PM
  • Hey KalimK,

    thanks for the answer. I tried with the parameters you suggested, but they had the  same effect. The report is still showing with the bar.

    I am starting to think I am running the report from Report Manager instead of Report Server. Is there a way to check who's who?

    Monday, August 19, 2013 7:17 AM
  • You may want to look at using the Publish Report for External Use.  That publishes the report as a regular RDL file in SSRS and can be accessed using traditional SSRS query string parameters.
    Monday, August 19, 2013 6:02 PM
  • Hey Chris,

    I tried your suggestion, but with no luck. I also tried importing the report directly into Report Server, but that did not help.

    Tuesday, August 20, 2013 7:21 AM
  • The part missing about the post above regarding rc:Toolbar=false is that it is using a standard SSRS reports and report viewer (not the CRM Report Viewer).  It's a fiddly process, but here are the steps:

    1. Publish Report for External Use (note you will have to setup the report to RunAs a windows account - see step 3)
    2. Find the published report on your SSRS server - http://SSRSReportServer/Reports (look for the folder "MyOrg_MSCRM")
    3. Find the MSCRM_DataSource in the folder and change it to run with "Credentials stored securely in the report server"  (a CRM User's windows account that has permission to access the CRM database - see example connection string below)
    4. Run the Report and copy the URL: http://SSRSReportServer/Reports/Pages/Report.aspx?ItemPath=%2fMyOrg_MSCRM%2fTestReport&ViewMode=Detail
    5. Reconstruct the URL using the SSRS Report Viewer (Note, I'm passing a report param called "LastName"): http://SSRSReportServer/ReportServer/Pages/ReportViewer.aspx?%2fMyOrg_MSCRM%2fTestReport&Lastname=sny&rc:Toolbar=false

    Sample SSRS Connection String:

    Workstation ID=NewCRMServer.Microsoft.Crm.Setup.Server;Data Source=MySQLServer01;Initial Catalog=MyOrg_MSCRM;Connection Timeout=60;Integrated Security=SSPI

    Tuesday, August 20, 2013 2:21 PM
  • When I open the MyOrg_MSCRM folder I can only see the reports, there is no MSCRM_DataSource folder.

    Am i looking in the right place?

    Wednesday, August 21, 2013 7:23 AM
  • Hi ,

    Make sure the view is "Details View" from the navigation bar.

    Thanks!

    Wednesday, August 21, 2013 7:41 AM
  • It is still showing the same data
    Wednesday, August 21, 2013 8:38 AM
  • Were you able to find the MSCRM_DataSource object (not folder)?  Take a look at this picture.  Are you clicking the Details View button?  Once you do, you should see the CRM datasources
    Wednesday, August 21, 2013 1:23 PM
  • Hej Chris,

    Sadly it is still showing the same data.

    Monday, August 26, 2013 1:49 PM