No reports shown in the report area RRS feed

All replies

  • Hello,


    Further to my investigations, I have re-published the CRM reports as explain in Chapter - 24 of CRM 3.0 Implementation guide.


    Still, I can't view a list of CRM reports in the Report area.


    Thanks & Regards,

    Ajay Chawla.


    Tuesday, August 5, 2008 12:29 PM
  • BTW.. how did you deploy your reports?  You cannot deploy the CRM reports from your Visual Studio directly.  You have to deploy the reports by going to the report area, click New, and then upload the report. 


    To ensure the report will be displayed in the report area, you have to add "Reports area" in the "Displayed In" textbox under the Categorization.


    Tuesday, August 5, 2008 3:05 PM
  • Hello Jude,


    I haven't used Visual Studio because these are the default CRM reports. I used publishReports.exe to re-publish reports.

    Untill now, I haven't tried to create new report using New button.


    When I tried to re-import existing report for example: Account Distribution.rdl using New button. It failed with below error.


    -----------------------------------------Error Message----------------------------------------

    Microsoft CRM unhandled Error Details:

    Server Error in '/' Application.


    Exception of type Microsoft.Crm.CrmException was thrown.

    Description: An unhandled exception occured during the execution of the current web request. Please review the stack traace for more information about the error and where it originated in the code.


    Stack Trace:

    [CrmException: Exception of type Microsoft.Crm.CrmException was thrown.]

      Microsoft.Crm.Application.Platform.Report.InternalCreate(String xml) +722

      Microsoft.Crm.Application.Platform.Entity.Create() +109

      Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId) +405

      Microsoft.Crm.Application.Forms.EndUserForm.Initialize(Entity entity) +56

      Microsoft.Crm.Application.Forms.EndUserForm.Execute(Entitiy entity) +13

      Microsoft.Crm.Web.Tools.ReportProperty.ReportPropertyPage.ConfigureForm() +208

      Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +30

      System.Web.UI.Control.PreRenderRecursiveInternal() +62

      System.Web.UI.Page.ProcessRequestMain() +1499




    Hope this error might give any clue.

    Please help.

    Thanks & Regards,

    Ajay Chawla.


    Wednesday, August 6, 2008 5:03 AM
  • Hello Imran,


    (http://support.microsoft.com/kb/946585) This link is meant for CRM 4.0. We have CRM 3.0.

    But I am sure that 'NT Authority\Network Service' account has db_owner & public roles on below listed databases.






    Additionally, the Network Service account has 'RSExecRole' role on ReportServer & ReportServerTempDB databases.


    Also, I went thru the below article and adjusted the connection string but still no luck.



    Any other ideas please.


    Thanks & Regards,

    Ajay Chawla.

    Wednesday, August 6, 2008 9:29 AM
  • Hello,


    Further to my investigations, I discovered that crm server was renamed in the past.

    Hence according to the CRM implementation guide, I performed below steps

    1. Used sp_dropserver and sp_addserver procedures to change the server name

    2. Renamed the user account IUSR_<old_hostname> to IUSR_<new_hostname>

    3. Renamed the user account IWAM_<old_hostname> to IWAM_<new_hostname>

    4. Used IIS Admin script (adsutil.vbs) to re-associate user accounts with IIS.


    restarted the server.


    But still, no luck..

    Am I suppose to change other bits in IIS or SQL server DB engine or Reporting engine?


    Thanks & Regards,

    Ajay Chawla.

    Friday, August 8, 2008 6:18 AM
  • Hello,


    We have CRM 3.0 with SQL 2005 server (on same machine) under Windows 2000 Domain Controller.

    Can anybody please tell under which account below services should be running?

    1. SQL Server service

    2. SQL Reporting service

    3. Web service identity account (ASP.NET service account)

    4. All CRM services


    Thanks in Advance.

    Ajay Chawla.


    Monday, August 11, 2008 7:15 AM