DateTime expressions

I am re-writing our existing Crystal Reports in RS, all of the SP's already
exist for the reports, so I am trying to use what we already have and create
clones in reporting services - I have a datetime field that is being returned
from the sp, and I need to have a high level of grouping in the report based
on the date, and a lower level grouping in the report based on the time (by
user)...my question is am I able to keep the SP as is, or do I have to add
two new values to the SP (return the date and the time as separate fields in
order to do what I need? Am I not able to use functions (expressions) to use
this one datetime field in two different effects?Got it ~
"Myles" wrote:
> I am re-writing our existing Crystal Reports in RS, all of the SP's already
> exist for the reports, so I am trying to use what we already have and create
> clones in reporting services - I have a datetime field that is being returned
> from the sp, and I need to have a high level of grouping in the report based
> on the date, and a lower level grouping in the report based on the time (by
> user)...my question is am I able to keep the SP as is, or do I have to add
> two new values to the SP (return the date and the time as separate fields in
> order to do what I need? Am I not able to use functions (expressions) to use
> this one datetime field in two different effects?