Group Refernece
I have a grouping in my report that group values by the hour. I have an avg of the values for each hour. I need to take that hourly average and sum 0 - 3 hours, 4-7,hour,8-11hour,12-15 hours,16-19hour,20-23 hour. How could I do this.
I tried setting a variable, but don't know how to reference the variable to sum.
Thanks
DCPRHC
February 27th, 2012 2:44pm
Hi DCPRHC,
This can be achieved this SSRS, you can customize the group's expression and axis's label using IIF function, you can refer to Challen Fu's reply at this thread
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/80e52b09-6767-46e9-af01-cd2e36c859c9/
Thanks,Challen Fu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
February 29th, 2012 2:49am