Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agenda9533
Starting Member
16 Posts |
 Posted - 2005-06-29 : 13:11:41
|
| I need to build a chart based on time values with output "hh:mm:ss". Chart doesn't recognize a string value hh:mm:ss that was converted by =String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddSeconds(Avg(Fields!HT.Value))) I've got "out of the range" error. If i convert it in datetime will chart recognize the time values? How to convert this string into datetime with the same format "hh:mm:ss" Thank you! |
|
|
jhermiz
3564 Posts |
Posted - 2005-06-29 : 17:45:34
|
quote:
Originally posted by agenda9533
I need to build a chart based on time values with output "hh:mm:ss". Chart doesn't recognize a string value hh:mm:ss that was converted by =String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddSeconds(Avg(Fields!HT.Value))) I've got "out of the range" error. If i convert it in datetime will chart recognize the time values? How to convert this string into datetime with the same format "hh:mm:ss" Thank you!
Dont use strings for datetime data types.If you would of used datetime yes the chart will recognize the value as a time. In fact the rs chart does not care what you send it, as long as the data type is valid for the type (x-axis / y-axis / series).To verify create a chart with the x-axis having a datetime field. You will notice rs plots the data using that type. In many cases most people dont care to graph based on time, the majority look at dates only. You can easily overcome this in your query by stripping out the time, also you can overcome this by telling rs that this is a date field only.Either way try it out, place a datetime inside the "Category" section of the chart and a count field in the data value of the chart. Run the report and notice the results.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
agenda9533
Starting Member
16 Posts |
Posted - 2005-06-29 : 17:50:32
|
| Thank you! I've just started working with RS. What book would you recommend for advanced RS "developers" ? |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-06-29 : 17:53:12
|
quote:
Originally posted by agenda9533
Thank you! I've just started working with RS. What book would you recommend for advanced RS "developers" ?
I'd say you are better off playing with the tools than any book out there. I have 3 books on reporting services and the majority are of no value. I have "Microsoft Reporting Services in Action", "Reporting services for smarties" and one other one. I might have read like 2 pages in each book. You learn by doing more than just reading...so play around with it and or get on microsoft's site and view the reporting services tutorial. They have a good one for charting on there.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
agenda9533
Starting Member
16 Posts |
Posted - 2005-06-29 : 17:58:41
|
| Thanks for advice! I just was looking for RS Bible that describes some hidden features ... But nothing is better than forums and google. ;) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-29 : 18:02:03
|
| No such bible exists for RS.For SQL Server, the bible is SQL Server Books Online. But RS' Books Online sucks. I agree with Jon in that the best way to learn RS is by trying it out. Install it along with the samples, then dive into the samples as their samples cover just about everything that you'll need to do.Tara |
|
|
|
|
|
|
Chart based on time values