locked
Report Viewer RRS feed

  • Question

  • User-1775282549 posted

    Hello, all

    I wan to ask is it got anyway to display data field only in the y-axis ?

    For example, this is my table is sql express

    id    %

    1      70

    2      80

    3      40

    4      20

    I want show the id at x -axis and % at the y-axis .. is it got anyway to do it ?

     

    Thanks so much

    Thursday, March 24, 2011 3:07 AM

Answers

  • User351081279 posted

    look, i was suffering from this problem and after hard try i found that you can play a trick on chart control , because data field must be aggregation function so to display the value
     of % field you have to write this formula in data field properties  and this will work correctly

     

    =(Count(Fields!Result.Value)*Fields!Result.Value)/Count(Fields!Result.Value)

    where fields!Result.Value is your % field

    this will work Laughing

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, March 27, 2011 5:54 AM

All replies

  • User351001653 posted

    Hi, Drag id field on X-axis(Category axis) and % field on Value axis(Y-axis)

    Thursday, March 24, 2011 5:27 AM
  • User-1775282549 posted

    Hello, I try before but the output not I want. When i drag and drop, the formula is count by the way i juz wan the data field.

    Thursday, March 24, 2011 9:12 PM
  • User351081279 posted

    look, i was suffering from this problem and after hard try i found that you can play a trick on chart control , because data field must be aggregation function so to display the value
     of % field you have to write this formula in data field properties  and this will work correctly

     

    =(Count(Fields!Result.Value)*Fields!Result.Value)/Count(Fields!Result.Value)

    where fields!Result.Value is your % field

    this will work Laughing

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, March 27, 2011 5:54 AM