如何对 Reporting Services 矩阵的列进行分组？
我想在报告服务矩阵中显示数据。它是一个访问峰值矩阵，以天为行，小时为列。我的程序返回如下数据：
Day / Hour / Peak
2010-05-01 00:00:00.000 2010-05-01 00:00:00 0
2010-05-01 00:00:00.000 2010-05-01 01:00:00 0
2010-05-01 00:00:00.000 2010-05-01 02:00:00 0
2010-05-01 00:00:00.000 2010-05-01 03:00:00 0
2010-05-01 00:00:00.000 2010-05-01 04:00:00 0
2010-05-01 00:00:00.000 2010-05-01 05:00:00 0
2010-05-01 00:00:00.000 2010-05-01 06:00:00 0
2010-05-01 00:00:00.000 2010-05-01 07:00:00 0
2010-05-01 00:00:00.000 2010-05-01 08:00:00 0
2010-05-01 00:00:00.000 2010-05-01 09:00:00 0
2010-05-01 00:00:00.000 2010-05-01 10:00:00 0
2010-05-01 00:00:00.000 2010-05-01 11:00:00 0
2010-05-01 00:00:00.000 2010-05-01 12:00:00 0
2010-05-01 00:00:00.000 2010-05-01 13:00:00 0
2010-05-01 00:00:00.000 2010-05-01 14:00:00 0
2010-05-01 00:00:00.000 2010-05-01 15:00:00 0
2010-05-01 00:00:00.000 2010-05-01 16:00:00 0
2010-05-01 00:00:00.000 2010-05-01 17:00:00 0
2010-05-01 00:00:00.000 2010-05-01 18:00:00 0
2010-05-01 00:00:00.000 2010-05-01 19:00:00 0
2010-05-01 00:00:00.000 2010-05-01 20:00:00 0
2010-05-01 00:00:00.000 2010-05-01 21:00:00 0
2010-05-01 00:00:00.000 2010-05-01 22:00:00 0
2010-05-01 00:00:00.000 2010-05-01 23:00:00 0
2010-05-02 00:00:00.000 2010-05-02 00:00:00 0
2010-05-02 00:00:00.000 2010-05-02 01:00:00 0
2010-05-02 00:00:00.000 2010-05-02 02:00:00 0
2010-05-02 00:00:00.000 2010-05-02 03:00:00 0
2010-05-02 00:00:00.000 2010-05-02 04:00:00 0
2010-05-02 00:00:00.000 2010-05-02 05:00:00 0
2010-05-02 00:00:00.000 2010-05-02 06:00:00 0
2010-05-02 00:00:00.000 2010-05-02 07:00:00 0
2010-05-02 00:00:00.000 2010-05-02 08:00:00 0
2010-05-02 00:00:00.000 2010-05-02 09:00:00 0
2010-05-02 00:00:00.000 2010-05-02 10:00:00 0
2010-05-02 00:00:00.000 2010-05-02 11:00:00 0
2010-05-02 00:00:00.000 2010-05-02 12:00:00 0
2010-05-02 00:00:00.000 2010-05-02 13:00:00 0
2010-05-02 00:00:00.000 2010-05-02 14:00:00 0
2010-05-02 00:00:00.000 2010-05-02 15:00:00 0
2010-05-02 00:00:00.000 2010-05-02 16:00:00 0
2010-05-02 00:00:00.000 2010-05-02 17:00:00 0
2010-05-02 00:00:00.000 2010-05-02 18:00:00 0
2010-05-02 00:00:00.000 2010-05-02 19:00:00 0
2010-05-02 00:00:00.000 2010-05-02 20:00:00 0
2010-05-02 00:00:00.000 2010-05-02 21:00:00 0
2010-05-02 00:00:00.000 2010-05-02 22:00:00 0
2010-05-02 00:00:00.000 2010-05-02 23:00:00 0
...
报告服务中的行字段是日期，列是小时，详细信息是峰值。但是当我渲染结果时，它会重复每行的小时列。
给定此数据集，如何对所有凌晨 1 点、所有凌晨 2 点等进行分组？
I want to display data in a reporting services matrix. It is an access peak matrix, in a way that days are rows, and hours are columns. My procedure returns data like this:
Day / Hour / Peak
2010-05-01 00:00:00.000 2010-05-01 00:00:00 0
2010-05-01 00:00:00.000 2010-05-01 01:00:00 0
2010-05-01 00:00:00.000 2010-05-01 02:00:00 0
2010-05-01 00:00:00.000 2010-05-01 03:00:00 0
2010-05-01 00:00:00.000 2010-05-01 04:00:00 0
2010-05-01 00:00:00.000 2010-05-01 05:00:00 0
2010-05-01 00:00:00.000 2010-05-01 06:00:00 0
2010-05-01 00:00:00.000 2010-05-01 07:00:00 0
2010-05-01 00:00:00.000 2010-05-01 08:00:00 0
2010-05-01 00:00:00.000 2010-05-01 09:00:00 0
2010-05-01 00:00:00.000 2010-05-01 10:00:00 0
2010-05-01 00:00:00.000 2010-05-01 11:00:00 0
2010-05-01 00:00:00.000 2010-05-01 12:00:00 0
2010-05-01 00:00:00.000 2010-05-01 13:00:00 0
2010-05-01 00:00:00.000 2010-05-01 14:00:00 0
2010-05-01 00:00:00.000 2010-05-01 15:00:00 0
2010-05-01 00:00:00.000 2010-05-01 16:00:00 0
2010-05-01 00:00:00.000 2010-05-01 17:00:00 0
2010-05-01 00:00:00.000 2010-05-01 18:00:00 0
2010-05-01 00:00:00.000 2010-05-01 19:00:00 0
2010-05-01 00:00:00.000 2010-05-01 20:00:00 0
2010-05-01 00:00:00.000 2010-05-01 21:00:00 0
2010-05-01 00:00:00.000 2010-05-01 22:00:00 0
2010-05-01 00:00:00.000 2010-05-01 23:00:00 0
2010-05-02 00:00:00.000 2010-05-02 00:00:00 0
2010-05-02 00:00:00.000 2010-05-02 01:00:00 0
2010-05-02 00:00:00.000 2010-05-02 02:00:00 0
2010-05-02 00:00:00.000 2010-05-02 03:00:00 0
2010-05-02 00:00:00.000 2010-05-02 04:00:00 0
2010-05-02 00:00:00.000 2010-05-02 05:00:00 0
2010-05-02 00:00:00.000 2010-05-02 06:00:00 0
2010-05-02 00:00:00.000 2010-05-02 07:00:00 0
2010-05-02 00:00:00.000 2010-05-02 08:00:00 0
2010-05-02 00:00:00.000 2010-05-02 09:00:00 0
2010-05-02 00:00:00.000 2010-05-02 10:00:00 0
2010-05-02 00:00:00.000 2010-05-02 11:00:00 0
2010-05-02 00:00:00.000 2010-05-02 12:00:00 0
2010-05-02 00:00:00.000 2010-05-02 13:00:00 0
2010-05-02 00:00:00.000 2010-05-02 14:00:00 0
2010-05-02 00:00:00.000 2010-05-02 15:00:00 0
2010-05-02 00:00:00.000 2010-05-02 16:00:00 0
2010-05-02 00:00:00.000 2010-05-02 17:00:00 0
2010-05-02 00:00:00.000 2010-05-02 18:00:00 0
2010-05-02 00:00:00.000 2010-05-02 19:00:00 0
2010-05-02 00:00:00.000 2010-05-02 20:00:00 0
2010-05-02 00:00:00.000 2010-05-02 21:00:00 0
2010-05-02 00:00:00.000 2010-05-02 22:00:00 0
2010-05-02 00:00:00.000 2010-05-02 23:00:00 0
...
My row field in reporting services is the day, column is hour, detail is peak. But when I render the result, it repeats the hour columns for each row.
How to group all 1AM, all 2AM, and so on, given this dataset?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
程序结果的问题是时间是凌晨 1 点、凌晨 2 点等，但每个日期的日期部分都不同。
我只是忽略了日期部分，一切都很好并组合在一起。
The problem with the procedure result was that time was 1AM, 2AM, etc, but the date part is different for each date.
I just ignored the date part and everything is fine and grouped together.