title: SSRS - Group by Date part of a datetime field , resulted from FetchXML query
body: <p>I am new to Fetchxml and using MS CRM Dynamics 2015 On Premise to create SSRS report using Visual Studio 2012</p>
  
  <p>My Fetchxml query returns me a Datetime column (CreatedOn)</p>
  
  <pre><code>&lt;fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"&gt;
    &lt;entity name="fax"&gt;
       &lt;attribute name="createdon" /&gt;
       &lt;attribute name="documenttype" /&gt;
      &lt;attribute name="activityid" /&gt;
      &lt;attribute name="statecode" /&gt; 
      &lt;order attribute="createdon" descending="false" /&gt;
     &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  
  <p>I want to group with Date (not with datetime).</p>
  
  <p>Tried to do formatting by using</p>
  
  <pre><code>=Format(createdonValue.value, "dd/MM/yyyy")  
  </code></pre>
  
  <p>and  </p>
  
  <pre><code>=FormatDateTime(createdonValue.value, DateFormat.ShortDate)
  </code></pre>
  
  <p>It's formatting, but grouping doesn't work. Records repeats.</p>
  
  <p>Please let me know is there any way to group by only with 'Date' part of 'FetchXML resulted date value' or is there anyway to get only 'date' part while querying with fetchxml.( e.g. in another column.)</p>