locked
chart - series RRS feed

  • Question

  • I have created a chart in SSRS 2008
    There are three series.
    1- Column1
    2- Column2
    3- expression which is Column1 - Column2

    Question:
    Regarding my series number 3 which is the difference of column1 and 2
    Is my expression correct? I ask because for point number 3, I get a straight line on scale 0
    Any thoughts please?
    Thanks

    Tuesday, September 13, 2011 2:39 PM

Answers

  • Hi

    Have you tried creating col3 in the Dataset and not as a SSRS expression?

     

    SELECT col1, col2, Col1-col2 as col3
    FROM Table
    

    Is it possible you wil have null values in cole 1 or 2? If it is you may want to handle that:

    SELECT col1, col2, IsNull(Col1,0)-IsNull(col2,0) as col3
    FROM Table
    

    Seth

     


    http://lqqsql.wordpress.com
    • Marked as answer by arkiboys Tuesday, September 13, 2011 4:24 PM
    Tuesday, September 13, 2011 4:16 PM

All replies

  • Hi

    Have you tried creating col3 in the Dataset and not as a SSRS expression?

     

    SELECT col1, col2, Col1-col2 as col3
    FROM Table
    

    Is it possible you wil have null values in cole 1 or 2? If it is you may want to handle that:

    SELECT col1, col2, IsNull(Col1,0)-IsNull(col2,0) as col3
    FROM Table
    

    Seth

     


    http://lqqsql.wordpress.com
    • Marked as answer by arkiboys Tuesday, September 13, 2011 4:24 PM
    Tuesday, September 13, 2011 4:16 PM
  • Solved. Thanks
    Tuesday, September 13, 2011 4:24 PM