SSRS Report Builder 3.0 折线图:如何绘制每天的持续时间图表?
使用 SSRS 报表生成器 3.0。我想要一个折线图,其中日期位于 X 轴,持续时间位于 Y 轴。在 Excel 上很容易得到这个,但 SSRS 在图表方面并不那么直观。下表实际上更大。但我希望 X 轴上的日期倾斜 90 度,Y 轴以持续时间值的格式显示间隔。我已经尝试了显而易见的方法,但出现的要么是空白图表,要么是图表开头的混乱。感谢您的帮助!谢谢!
`|开始日期|包|任务|持续时间
|1/1/2011 |包1 |任务1 |00:04:36
|1/10/2011 |包1 |任务1 |00:12:06
|1/11/2011 |包1 |任务1 |00:15:55
|1/12/2011 |Pkg1 |任务1
|00:16:39 |1/13/2011 |Pkg1 |任务1 |00:14:17
|1/14/2011 |Pkg1 |任务1 | 00:15:30 `
Working with SSRS Report Builder 3.0. I want a Line Chart where the dates are on the X axis and the Durations are on the Y-axis. It's so easy to get this on Excel, but SSRS is not that intuitive when it comes to charting. The table below is actually larger. But the I want the dates on X to tilt 90 degrees and the Y-axis to show intervals in the format of the Duration values. I've tried the obvious but what comes up is either blank chart or a jumble in the beginning of the chart. Your help is appreciated! Thanks!
`|StartDate|Package |Task |Duration
|1/1/2011 |Pkg1 |Task1 |00:04:36
|1/10/2011 |Pkg1 |Task1 |00:12:06
|1/11/2011 |Pkg1 |Task1 |00:15:55
|1/12/2011 |Pkg1 |Task1 |00:16:39
|1/13/2011 |Pkg1 |Task1 |00:14:17
|1/14/2011 |Pkg1 |Task1 |00:15:30 `
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将持续时间转换为小数后,图表开始工作。但不明白如何使用标准时间跨度这是不可能的。那好吧。
After converting the Durations to a decimal, the chart started working. Can't see how this is not possible using standard time spans though. Oh well.