I am new to SSRS from years of Crystal Reports experience. I'm moving a report from CR to SSRS that shows by plant, sales volumes for current day, yesterday, mtd and ytd. I simply can't get this to work in SSRS. Is it even possible or do I have to do all of this date grouping in the query?
My date parameter to run the report is @TicketDate = Today() and my Current Day Totals is using an expression =IIf(Parameters!StartTicketDate.Value= Today(),Fields!Qty.Value,0). After that, I'm totally lost! I've tried several different runs at this with DateAdd, DateInterval replacing "Today()", but no luck. Can anyone help me? I've included a representation of what I'm looking for. Thanks in advance for any help you might offer.
"Ticketing by Plant
As of: 08/28/2015 12:56 pm"
PLANTID LOAD TODAY YESTERDAY WEEK MONTH YEARLY
00011 52 1,236.00 1,110.00 4,649.54 8,002.34 120,824.29
00013 10 620.00 437.99 ,201.01 5,134.52 101,973.14
00021 10 156.25 699.79 1,856.32 1,952.00 35,064.32
00041 10 141.35 800.25 2,525.32 8,301.00 67,459.40
00043 74 1,913.10 2,178.81 7,418.53
00070 10 229.37 1,189.26
00080 10 189.10 13,769.4
176 4,485.17 20,185.52
Excludes "VOID" tickets only.
My date parameter to run the report is @TicketDate = Today() and my Current Day Totals is using an expression =IIf(Parameters!StartTicketDate.Value= Today(),Fields!Qty.Value,0). After that, I'm totally lost! I've tried several different runs at this with DateAdd, DateInterval replacing "Today()", but no luck. Can anyone help me? I've included a representation of what I'm looking for. Thanks in advance for any help you might offer.
"Ticketing by Plant
As of: 08/28/2015 12:56 pm"
PLANTID LOAD TODAY YESTERDAY WEEK MONTH YEARLY
00011 52 1,236.00 1,110.00 4,649.54 8,002.34 120,824.29
00013 10 620.00 437.99 ,201.01 5,134.52 101,973.14
00021 10 156.25 699.79 1,856.32 1,952.00 35,064.32
00041 10 141.35 800.25 2,525.32 8,301.00 67,459.40
00043 74 1,913.10 2,178.81 7,418.53
00070 10 229.37 1,189.26
00080 10 189.10 13,769.4
176 4,485.17 20,185.52
Excludes "VOID" tickets only.