3 iulie 2012 19:09
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.
4 iulie 2012 06:44
in Field expression write following line=Format(Fields!yourfield.Value,”d”)
5 iulie 2012 19:18
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 : )
6 iulie 2012 10:11
try this expression in field
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