Conectare
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
SSRS Report using Report Builder for CRM 2011-how do I group by Date with Date/time field?

Răspuns propus SSRS Report using Report Builder for CRM 2011-how do I group by Date with Date/time field?

  • 3 iulie 2012 19:09
     
     
    Sign in pentru a vota
    0

    Hi,

    I am trying to build a summary report by date, but the date is part of a date/time field.    I need the date (without the time) to be the column group. How can I do that in the report builder?

    To access the report builder, I am clicking on "Report Builder" from SQL Server Reporting Services Custom Reports for CRM.

    Thank you!

    Voni

    Voni Garrett

     

Toate mesajele

  • 4 iulie 2012 06:44
     
     
    Sign in pentru a vota
    0

    Hi

    in Field expression write following line

    =Format(Fields!yourfield.Value,”d”)
     
  • 5 iulie 2012 19:18
     
     
    Sign in pentru a vota
    0

    Hi Riaz,

    I was able to use this to format what actually prints, but I still get a separate column for each time within the date.  Am I missing something somewhere?

    Thank you for your help  : )

    Voni

    Voni Garrett

     
  • 6 iulie 2012 10:11
     
     Răspuns propus
    Sign in pentru a vota
    0

    hi,

    try this expression in field

    =FormatDateTime(Fields!field_name.Value,DateFormat.ShortDate)

    this will give date in Short date. :)

    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful. Regards, Hari.

    • Propus ca răspuns de Irah.2008 19 iulie 2012 05:46
    •