I got it thanks you, the dates i am working with will never start or end on a Saturday or Sunday so i used the -DATEDIFF(wk, @StartDate, @EndDate) * 2...

Thanks for getting back top me. one problem. i am using a model for my datasource. I don't have an field for day(sunday) only, Day (13th), Week, Month & year.

Hi

I need to get back data which is >=20/09/07 so i need this to be a filter.

Once you have put the report onto report manager so it is accesable via the web go into properties and select parameters - in there you can change the Display...

I still need help with removing the grouping from the first column. is there a way of removing the duplicates

i have found the answer

I have managed to to this thanks you

I have managed to do this

it's ok, i have found the answer

hi

jUST DATE- don't want the time on the end