Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
No reports shown in the report area RRS feed

 > 

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    http://support.microsoft.com/kb/946585

     

    http://dmcrm.blogspot.com/2008/01/reports-not-fully-working-after.html

     

     

    For More see MS CRM Support section

    http://support.microsoft.com/ph/12976

     

    Regards,
    Imran

    http://microsoftcrm3.blogspot.com

     

    Wednesday, August 6, 2008 8:09 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    <org_name>_MSCRM

    <org_name>_METABASE

    ReportServer

    ReportServerTempDB

     

    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.

    http://support.microsoft.com/kb/946289/

     

    Any other ideas please.

     

    Thanks & Regards,

    Ajay Chawla.

    Wednesday, August 6, 2008 9:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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