Skip to Content
author's profile photo Former Member
Former Member

Why can I NOT see my formula in the chart

Post Author: Elenac

CA Forum: Charts and Graphs

I am creating a chart that requires the value of a formula to appear on the x-axis. Why can i not see this formula when selecting my data for the chart. I can only see some of my formulas, not all. I went to the advance view and it does not appear there either

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2007 at 06:41 PM

    Post Author: V361

    CA Forum: Charts and Graphs

    what version of CR do you have ?, what type of chart are you creating, what is the formula you can not see ?. If you add the formula to the details section, do you see a result ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2007 at 08:11 AM

    Post Author: Elenac

    CA Forum: Charts and Graphs

    The version i am using is version 11.

    The report is an exisitng report with various formulas. When I try create a bar chart, i cannot see any of the formulas in the group footer section of my report. I can see the formulas in the detail section though

    The report shows the grade of service for each 30 minute interval, so the formula is in a group footer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2007 at 06:42 PM

    Post Author: V361

    CA Forum: Charts and Graphs

    That is odd. The group that has the formulas, can you insert a section and place the graph in the inserted section ? Can you see the formulas then.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2007 at 03:52 PM

    Post Author: Elenac

    CA Forum: Charts and Graphs

    I inserted new sections and no luck. I still cannot see the formula.

    Someone mentioned to me that the formula may be a second pass formula and that is why it is not appearing on the graph. What is a second pass formula?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2007 at 04:02 PM

    Post Author: V361

    CA Forum: Charts and Graphs

    It refers to the order that CR process formula's. You can have "Run Time", While Printing records, While reading records, etc.... So... Some formulas are processed at a later time, Say you had two groups, or a subreport, CR will "Typicaly" calculate group 1, before 2, before 3, before the sub... "Here again it all depends on where the formulas are located... and what they are doing" look in the help section for "WhilePrintingRecords"

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 28, 2007 at 07:37 PM

    Post Author: ljfrench

    CA Forum: Charts and Graphs

    I'm having a similar problem. I followed the advice here to manually create a running total field. I also created a running total for the same information using the Running Total Expert.The running total field keeps track of the average fulfillment rate for orders shipped. It is an average of one week's orders shipped on time. I need to use a manual running total because I need to calculate not only one week's average but also a four-week rolling average for charting.Both averages print fine on the report but only the running total created by the Expert is available for use on the chart. Of course, the chart is supposed to include the four-week rolling average so this situation does me no good.I've tried changing the order of formula processing but the manual RT only seems to work with WhilePrintingRecords. If only there was a way to delay chart creation until after the records were printed!Thoughts? Does anyone know a way to accomplish this task? I can provide code samples. Thank you!ljfrench

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 29, 2008 at 07:52 PM

    Post Author: wstromer

    CA Forum: Charts and Graphs

    I have the exact same problem. Did any of you find a solution? I just posted my issue here in another thread.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.