HEY GUYS I HAVE A STOREDPROC WHERE IN I GENERATE A REPORT IN WHICH THE DATA IS GROUPED BY TIMESTAMP. NOW I NEED TO GROUP THE DATA BY DAY. I NEED TO GENERATE A REPORT IN EXCEL IN WHICH THE DATA IS GROUPED BY DAY. CAN SOMEONE ADVISE ME ON THIS THANKS JUSTIN

group by day .....!!! sorry

create a table(row/column) level group depending on your requirement and keep the expression something like this:- = DAY(FIELDS!TimeStamp-Column-Name.Value) Please let us know if you need further help. Thanks KumarKG

i already have a stored proc where in im using it to generate the report to show my timestamp. now i need to generate the report by grouping by day. could u tell me how i need to modify the existind stored proc or create an new stored proc. and how it should be done thanks

Paste the sp with some sample date and we can reply you back ASAP. Otherwise you can also trying applying the same logic to your sp, saying:- GROUP BY DatePart(day, column-name) Please let us know your feedback. Thanks KumarKG

Hi justin, if you have one record for one day, simply use order by day..... if you have multiple records for same date use group by date. amit

I do a DATENAME(dw, column) to get Monday, Tuesday ect and DATEPART(dw,column) to get a numerical figure to order it by

hi Andy, all these monday ,atuesday numerical number would come under one column ,hence simple use this column in order by list in query Amit