August 8, 2008 at 5:06 am
Hello
I have some kind of strange scenerio. I have am using a query with datetime, and for some reason whatsoever the date is supposed to group together.
What I am getting now is Thursday, August 07, 2008 been repeated as its own group?!!!
can anyone help me sort this out, I have done nearly all tricks of the book!!!
August 19, 2008 at 8:41 am
Probably what you are getting is different groups for the same day simply because transactions are occuring at different times during that day.
I assume you have a group expression based simply on the date?
If this is the case then you probably need to use an expression to format the date for that group, so for example, your group expression could be something like =Format(Fields!DateColumn.Value,"dd MMM yyyy")
This would ensure that all transactions for the same date would appear under the same group.
Regards,
Nigel West
UK
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply