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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics