Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 3.0 Reporting Issue RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have a strange question that I am hoping this forum can help. We have an installation of Microsoft CRM 3.0 on a Windows Server 2003 server and a SQL 2005 backend. The question that I have is when task or activities are completed there is a time/date stamp that is associated with those completion dates and times. When I use Reporting Services to pull the data out of CRM to help our end users consume the data the times are accurate. When i use Microsoft Excel 2007 to connect to the CRM database and build pivot tables into the data all the times are 5 hours ahead of when they are completed. We are in the Central Time Zone and can't figure out why the times are listed as 5 hours ahead. I have checked the server and CRM times and they all match and are current. Does anyone have any ideas of why this would be happening and what steps I could use to correct it?

    Tuesday, April 21, 2009 1:28 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Donna's answer is correct -

    The field 'createdon' (for example) if retrieved from the filtered view (e.g. filteredaccount, filteredcontact will be adjusted to local timezone (based on the user's settings) -

    The same field retrieved from the base table (e.g. accountbase, contactbase) or 'non-filtered view'  (e.g. account, contact) will return the time/date as stored on the server (in GMT/UTC time)  (in Eastern US time, it's 5 hours ahead of local time - not counting daylight savings time adjustment.)

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    • Marked as answer by Noalie Tuesday, April 21, 2009 2:17 AM
    Tuesday, April 21, 2009 1:55 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Ensure you are running your report against filtered views and not the base tables.

    Best Regards, Donna
    Tuesday, April 21, 2009 1:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you for the response. How can you ensure that you are running the report against the filtered views and not the base tables when you are just using a connection string from Excel. I do believe that I am running it on the base tables.
    Tuesday, April 21, 2009 1:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Donna's answer is correct -

    The field 'createdon' (for example) if retrieved from the filtered view (e.g. filteredaccount, filteredcontact will be adjusted to local timezone (based on the user's settings) -

    The same field retrieved from the base table (e.g. accountbase, contactbase) or 'non-filtered view'  (e.g. account, contact) will return the time/date as stored on the server (in GMT/UTC time)  (in Eastern US time, it's 5 hours ahead of local time - not counting daylight savings time adjustment.)

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    • Marked as answer by Noalie Tuesday, April 21, 2009 2:17 AM
    Tuesday, April 21, 2009 1:55 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    for example, your connection string should reference the filteredactivitypointer table rather than activitypointerbase table.  How did you create your connection string and what does it look like? 

    There is generally an option in the data connection to edit the query and then save changes.  I can give you the exact steps if needed but I would like to understand how you created the connection in Excel first.

    Best Regards, Donna
    Tuesday, April 21, 2009 2:33 AM