locked
Query business closure in CRM report RRS feed

  • Question

  • As the topic, Is it possible to query business closure in a CRM report?

    If so, how?

     

    Thanks


    Best Regard Vincent L
    Wednesday, September 29, 2010 12:51 AM

Answers

All replies

  • Hi,

     

    You can't do it in the regular Report Wizard. You should use Reporting Services to query for Business Closures. This post of mine could help you how to check whether a day is a business closure in the code (not in SQL, but it's easy to translate): http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/2767c884-9740-485d-811d-aefa39661e51

     

    Let us know whether that helped.

    Kuba


    -- Kuba Skałbania, Netwise
    • Marked as answer by Vincent L Wednesday, September 29, 2010 1:17 AM
    Wednesday, September 29, 2010 12:58 AM
  • Thanks, that seems to be the answer.

    I can query the business closure on FilteredCalendarRule view.


    Best Regard Vincent L
    Wednesday, September 29, 2010 1:17 AM
  • True!
    -- Kuba Skałbania, Netwise
    Wednesday, September 29, 2010 1:27 AM