locked
Chart representation RRS feed

  • Question

  • Dear all,

    I have the following table content result on my RSS report which is build with Report builder 2.0

    Status                  Days                 Hours              Minutes
    ========================================
    Stop                      3                        6                      5
    Running                 10                      2                      15

    The table above help me to identify how long I have been in each of those status
    I would like to display those result in the report as a chart view in order to express for each status the amount of time I stays in
    For that I can express all time as minutes, but how to show that tables in x and Y representation within a chart in order to have X = Status fiels and Y = amount of time or % of total time ?

    thnaks for help
    regards
    serge 
    Your experience is build from the one of others
    Friday, September 18, 2009 11:22 PM

Answers

  • You should drop status on the categories (bottom flange) of the chart and then add a value expression (top flange) which will add-up days, hours and minutes. At the end you will get 2 columns in the chart showing number of minutes for Stop and Running.

    Let me know if you need more help with that expression...

    Alex.
    http://blogs.msdn.com/alexgor
    Saturday, September 19, 2009 2:52 AM

All replies

  • You should drop status on the categories (bottom flange) of the chart and then add a value expression (top flange) which will add-up days, hours and minutes. At the end you will get 2 columns in the chart showing number of minutes for Stop and Running.

    Let me know if you need more help with that expression...

    Alex.
    http://blogs.msdn.com/alexgor
    Saturday, September 19, 2009 2:52 AM
  • works great, thnaks

    serge
    Your experience is build from the one of others
    Saturday, September 19, 2009 9:03 AM