Hi
I created a report and i'm grouping for a DateTime field.
The problem is that there are rows with same Date but different time like :
"31/05/2011 11:00:00"
"31/05/2011 12:00:00"
"31/05/2011 12:30:00"
"31/05/2011 13:00:00"
"31/05/2011 15:00:00"
The problem is that the report is groupped by Date and Time i want report to be groupped only for Date.
is it possible??
Hi,
Yes it is possible.
Assuming that the DateTime field you are grouping by is called OrderDate, instead of using the expression “=Fields.OrderDate” to group by use “=Fields.OrderDate.Date”.
“Date” is the property of the DateTime object that returns the date part of the DateTime, see ( http://msdn.microsoft.com/en-us/library/system.datetime.date.aspx ).
Thanks,
Leo
Hi Leo
you solution worked well as always. Thanks !!!!
I'have another problem.
My report is like an Invioce report. and i'm gouping by date.
i remember that in crystalreport there was an option "New Page After" for group. Setting that option to true when the group data finished the data after that group were in a new page.
Is there a way to do this in our Ingragistics report???
Currently you don’t have a way of doing what you want. In the next CTP we will include “insert page break before” and “insert page break after” properties of group header/footer sections. I think that will solve your problem.