none
Line chart in ssrs

    Question

  • Hi All

    I have student marks data and average mark for each subject of the class. Table consists of arount 200 students. Table as follows;

    Stu_name   subject_name   Marks         average_mark

    Smith          Maths                50               61

    Smith          Commerce          71              43

    Smith          Science              56               72

    John            Maths                79               61

    John            Commerce          67              43

    John            Scienc                63               72

    .............

    .........................

    ...........................

    I want to get "line chart" in SSRS 2008.

    X Axis representing subjects . Y Axis representing Marks. There are two series which are representing student individul marks and average marks. And also need chart for every students.

    please look at attahment also to understand my requirements.

    Please advice me how to achieve my requirement.

    Any help really appreciate.

    Thank you


    • Edited by dukdpk Wednesday, July 17, 2013 2:51 PM
    Wednesday, July 17, 2013 2:48 PM

Answers

All replies

  • Hi All,

    I have student marks data and average mark for each subject of the class. Table consists of arount 200 students. Table as follows;

    Stu name       maths      science     maths_average     science_average

    John               70           60              53                               52                                 

    Anne              35          87               53                               52                              

    Smith             67           24              53                               52                                 

    George           89            78             53                               52                                 

    .............................................

    ..........................................

    ......................................

    ...............................

    I want to draw line chart by representing student indiviual subject marks verse subject average marks. And also need page break based on each student.

    Please advice me how to achieve my requirement.

    Any help really appreciate.

    Thank you

          


    Wednesday, July 17, 2013 12:04 PM
  • Hi,

    Try like this,

    Create dataset with below query :

    DECLARE @TMP TABLE (Stu_name VARCHAR(20),subject_name VARCHAR(20),Marks INT,average_mark INT)
           
    INSERT @TMP SELECT 'Smith','Maths',50,61
    INSERT @TMP SELECT 'Smith','Commerce',71,43
    INSERT @TMP SELECT 'Smith','Science',56,72
    INSERT @TMP SELECT 'John',' Maths', 79,61
    INSERT @TMP SELECT 'John','Commerce',67,43
    INSERT @TMP SELECT 'John','Science',63,72
    SELECT * FROM @TMP

    Right-click on report body - > Insert - > Charts - > Line With Markers

    And then try as shown below :


    sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.


    Wednesday, July 17, 2013 4:31 PM
  • Hi Dukdpk,

    From your description, you want to dispaly each student's mark for each subject and average_mark of all students for each subject, right? This can be done in Reporting Services. Here has a similar thread, please refer to the link below to see Charlie's post.
    http://social.technet.microsoft.com/Forums/sqlserver/en-US/c467f9a7-77ef-42ba-80e0-d014961df2e6/two-different-chart-typedata-into-the-same-chart

    However, in your scenario, you want to dispaly all the student on one chart, this seems no make sense for the reason that there are 200 students in your dataset. It's better for your to divide all the students into multiple group and display then on multiple charts.

    If you have any questions, please feel free to ask.

    Regards,


    Charlie Liao
    TechNet Community Support

    Thursday, July 18, 2013 9:44 AM