Environment: Windows 8.1, SQL Server 2008 R2 Express database, SQL Server 2008 R2 BIDS
Database: Performance counter data collected on client servers. The particular values involved in this question are % Processor Time and Batch Request/sec.
I did not start this report from scratch. I am actually just modifying one Allen White provided from his TechEd 2010 session that you can find here. I am using the same table structure with a few modifications to column names and such for my liking, pretty much the same other than that. I also added some filter/parameters into the report because I have multiple servers in this database.
I take the RDL file and import it into my SSRS project. Modify the procedures and column names to match my setup. I noted the format of the graph to be a simple line graph:
The border for each series is set to a solid line style with 2pt line width, no shadow. I don't see why I don't get a pretty line versus this. Is there some format setting I am missing? It has been sometime since I have tried setting up graphs in BIDS.
Best Answer
Always enjoy getting help from this site... Thanks to @billinkc.
I had the thought in the back of my mind that maybe the graph had to much data to display but guess it never clicked.
I modified the graph's Category Groups to be an expression for grouping by the hour not just the full date value:
=Hour(Fields!CapturedTime.Value)That allowed the graph to be prettified into this: