Please describe in more detail what you need to see in each chart and how you produce the report on this layout. In particular, is it a report based on all records in your table or only some records in the table.
Hopefully, you did not actually duplicate a table here, but instead, duplicated a Tutorial: What are Table Occurrences?.
Thank you for such quick response.
The layout is a report based on all record in the table, and yes the duplicate is just another Table Occurrence. Basically I need:
- one Pie Chart (in the header) the shows the different types of tasks in %, so I have a TYPE column in the table and I can sort the layout by Type and the Pie Chart works great.
- In the body I am showing all records NAME and TYPE fields and I want to have small pie charts for each Name showing Type in % (just like the one in the Header) but sorted by Name,
so that each small Pie Chart will be per that individual and what TYPE of task that individual has and the amount will be shown on the pie chart on %. I placed the small Pie Charts in the Sub-summary and i have a button to sort by Name and Type (in that Order) and then you can see the small pie charts. By changing the sort on the layout from TYPE to sort by NAME and TYPE, the Big Pie Chart (in the header) will changes since the sort for the layout changed. So that is why I thought I can make use of the Table Occurance to make this happen, and I am unable to do so.
Please let me know if this is a better explanation.
On your layout, you sort records by Name, then by Type?
What version of Filemaker do you have?
Yes, bu Name and then by Type and the version is FM 12 Pro Advance
Assuming that your sub summary located chart is working correctly for you, I can think of two approaches for getting the main chart to work:
Have a script sort your records the way you need for your main chart. Use GetLayoutObjectAttribute in a script to copy the chart image into a container field. Resort your records as needed for your report and use the container field in the top of your report to display the chart.
Use ExecuteSQL() to generate a return separated data series with one number for each sorted group based subtotal. Chart this "delimitted data" to produce your report.