December 30, 2011 at 12:56 pm
I have a report that shows total for 3 columons based on the parameter startdate and EndDate.
Eg
A B C
$10,000 $20,000 $5,000
I need it , to be based on week end(ever friday) eg dates start from satarday will be included on the following friday.
If the date range is for 1 year it will have 52 weeks rows.
E.g for dec
Based on (the Paramter) startdate and end date
A B C
Weekend end 12/2/2011 $400 --etc
Weekend end 12/9/2011
Weekend end 12/16/2011
'
'
'
total $10,000 $20,000 $5,000
I was looking expression that give such result
thanks
December 30, 2011 at 1:54 pm
It would probably be easiest to include the week datepart in your sql query, then use the week to group the report. If you can't change the query, the next easiest way would be to add a calculated field to your dataset, using the datefield, like this:
=datepart("ww",Fields!DateValue.Value,0,0)
Adjust the first day of week and first week of year switches as needed for your system. Syntax for Datepart: =DatePart(DateInterval.Quarter,Fields!BirthDate.Value,FirstDayOfWeek.System,FirstWeekOfYear.System)
Use the Week field as your Column Group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply