Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Report Chart Query RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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