4 Replies Latest reply on Aug 12, 2014 1:58 PM by john9210

    Chart layout and data source

    john9210

      Title

      Chart layout and data source

      Post


           FM 12. I'm having some problems displaying chart data. How do you select a layout for the chart and for the data source? Should the layout tables be the same?

        • 1. Re: Chart layout and data source
          philmodjunk

               Layouts are not data sources. The layout on which you choose to put the chart object specifies a "table occurrence" in Layout setup | Show records from. This table occurrence then establishes the context for whatever data you specify for your chart in the data source options.

          • 2. Re: Chart layout and data source
            john9210

                 Yes, but you still have to find and sort records to display on the chart. Since these are not on the chart layout you have to use another layout to do this. That's what I'm calling the data source. Not so?

            • 3. Re: Chart layout and data source
              philmodjunk
                   

                        Since these are not on the chart layout you have to use another layout to do this.

                   Not so.

                   There are several data source options that you can select for your chart. They all start from the "context" of your chart object's layout--the layout where you have placed your chart.

                   If you specify the found set as your data source, you find and sort records on your chart's layout. If you specify charting from a related table occurrence, then the relationship between your layout's table occurrence to the specified table occurrence determines how the current record on your chart's layout matches to records in the related table and thus controls what data is used in the chart. (Think of this as charting the values shown in an unfiltered portal to a related table.) The third option is to set up delimited data as the source of values for your chart object. This will either be return separated data stored in a text field of the current record on your layout or a calculation--either in a field or specified in chart setup that produces such a list of values. ExecuteSQL is often the tool of choice for producing such a list, but any of these calcuations, whether defined in chart setup or in a field, also evaluate from the context of the current record on your chart's layout.

              • 4. Re: Chart layout and data source
                john9210

                     Thanks PhilModJunk, that was a big help. I wish FM "help" is as clear as you are.