Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why isn't this plotting on a chart like I expect? Expand / Collapse
Author
Message
Posted Monday, December 23, 2013 9:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 10:55 AM
Points: 1, Visits: 29
Good day, I'm having an understanding issue with the Chart. Here is a sample dataset:

SELECT 'test1' AS name, 100 AS value, '12/16/2013 10:10' AS logdatetime
UNION ALL
SELECT 'test2' AS name, 200 AS value, '12/16/2013 10:12' AS logdatetime
UNION ALL
SELECT 'test3' AS name, 300 AS value, '12/16/2013 10:14' AS logdatetime
UNION ALL
SELECT 'test1' AS name, 200 AS value, '12/17/2013 9:05' AS logdatetime
UNION ALL
SELECT 'test2' AS name, 300 AS value, '12/17/2013 9:07' AS logdatetime
UNION ALL
SELECT 'test3' AS name, 400 AS value, '12/17/2013 9:09' AS logdatetime

I have attached two pictures. One of them is of the design, and the other is of it being rendered. Why don't all three series' lines render on the chart? Did I set up values, categories, and series of the chart incorrectly?



I'm basically just looking to chart each of the "test" values as a line separately, and their values as the x-axis, and the datetime as the y-axis. What am I doing wrong and why is nothing actually being charted and displayed?



Thank you in advance!


  Post Attachments 
SSRS_chart_design.png (27 views, 25.80 KB)
SSRS_chart_preview.png (23 views, 4.65 KB)
Post #1525580
Posted Monday, December 23, 2013 10:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:17 AM
Points: 44, Visits: 208
You have a problem with category Axis. Change Group Expression from longDateTime to this one:

=DateSerial(Year(Fields!logdatetime.Value),
Month(Fields!logdatetime.Value),
Day(Fields!logdatetime.Value))

It will work


  Post Attachments 
Example.png (6 views, 155.49 KB)
Post #1525591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse