x

Timeline in SSRS 2008 like in management studio

HI, does anyone now if it's possible to create a time line like the one that appears in some of the default reports in management studio 2008, the Performance Data Collectors ones.
I only manage to sort of do it with a simple chart, but I'd like to implement something more like the time line in SSMS.


This is the time line I'm referring to.

Performance Data Collector

Thanks,
Alan

more ▼

asked Nov 06, 2009 at 10:25 AM in Default

Alan Featherston Lago gravatar image

Alan Featherston Lago
97 2 2 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I suggest you look at the following blog post:

http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx

Where they've posted the source code of their standard reports. You should be able to get into them with something like BIDS and extract the bits that you need.

more ▼

answered Nov 06, 2009 at 11:21 AM

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

yhea, i found that, but those reports are from 2006 and as far as i know (i could be wrong) the time line feature was introduced in SS2008, and i haven't being able to find a more up to date report pack like that one. Thank you anyway :)
Nov 06, 2009 at 11:48 AM Alan Featherston Lago
Which report in particular does it feature on?
Nov 06, 2009 at 12:23 PM Melvyn Harbour 1 ♦♦
oh sorry i didnt explain that very well, the reports I'm referring to are the Performance Data Collectors ones.
Nov 06, 2009 at 12:39 PM Alan Featherston Lago
(comments are locked)
10|1200 characters needed characters left

Are they not just normal line charts embedded into a grid ?

more ▼

answered Nov 06, 2009 at 04:35 PM

dave ballantyne gravatar image

dave ballantyne
928 1 1 4

Thats what I've done to recreate it, but i don't think thats how they were done. I was hoping to find a similar implementation but no luck yet.
Nov 06, 2009 at 05:33 PM Alan Featherston Lago
(comments are locked)
10|1200 characters needed characters left

Ive found the rdl definitions of the standard reports here, no joy on the data collector ones yet though.

more ▼

answered Nov 12, 2009 at 10:18 AM

dave ballantyne gravatar image

dave ballantyne
928 1 1 4

Thats the same link Melvyn Harbour posted.
Nov 12, 2009 at 04:00 PM Alan Featherston Lago
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1842
x555
x126

asked: Nov 06, 2009 at 10:25 AM

Seen: 5036 times

Last Updated: Feb 17, 2010 at 07:18 AM