none
Report Chart Query

    Question

  • Hi Guys

    Cant seem to find the right forum location for this particular query.

    I have a chart on my report that I need to show Yes / No values. It would be a summary of all data in a field DisWeight). Currently, this field holds all of the YES values. That would make my argument = Yes and my Value = DisWeight

    ColType          DisWeight
    Yes              100
    Yes               75
    Yes               25
    Yes              100
    Yes               50

    The average of this is 70% and the chart would need to show 70% = yes & 30% = No

    ColType would be the Argument, DisWeight would be the value. I cannot add any extra rows because the data is collected along with  other data within the table. I can add a column and calculate the No values but I cant figure out how to assign both columns to the chart to only show Yes = 70% & No = 30%

    How would I attempt this in a report?

    Thanks

    Nacho


    Nacho is the derivative of Nigel "True fact!"

    Wednesday, October 28, 2015 12:12 AM

Answers

  • What type of report did you build? If you are using .net Chart control, there is a dedicated forum for that here.

    If its a Crystal Report, please post your question on their official forum, as this product is not supported here.


    Fouad Roumieh


    Wednesday, October 28, 2015 5:54 AM

All replies

  • What type of report did you build? If you are using .net Chart control, there is a dedicated forum for that here.

    If its a Crystal Report, please post your question on their official forum, as this product is not supported here.


    Fouad Roumieh


    Wednesday, October 28, 2015 5:54 AM
  • Hi.

    Ok thanks. Ive progressed so will need to close the post and move to another forum :)

    Thanks


    Nacho is the derivative of Nigel "True fact!"

    Wednesday, October 28, 2015 7:01 AM