GetSummary

[Simmo]

Could anybody help?

I'm looking to chart the total sales of my business month by month, I have a subsummary report that shows 12 monthly totals, but when I use GetSummary on the sum field (to paste to the chart) it only gets the first months total, how do you get Filemaker to read the next Subsummary part?

[aaa]

I think that will be easy to use for subsummary report total field. Look attachment

SubSummary.zip

Edited October 12, 2005 by Guest

[Simmo]

Thanks for that.

The reporting side of things is covered, it's taking the sub-summary totals from the report and putting then in a chart which is the problem.

I am using GetSummary but this only takes the first subSummary value, I was looking for a method to 'grab' subsequent sub-totals.

[Garry Claridge]

Are you trying to do this with CDML?

If so, you would need to use Javascript. Some examples for summaries exist on this forum. If you can't find them, I can have a look through some of my old CDML files.

All the best.

Garry

[aaa]

SubSummary works normaly. Look attachment. Can you describe how you get values from table for chart? May be here is problem? I did charts for years and month on FM and it worked normaly.

SubSummary.zip

Edited October 14, 2005 by Guest

[Garry Claridge]

You need to go to "Preview" mode to see the sub-summary report.

Garry

[davidwdf]

I need a quick fix! Need to show summary fields using CDML. Can anyone help?

David

[Garry Claridge]

The only way I've found to do this is with Javascript. Here is an example:

Location | Total

[FMP-Record]

if (curr_loc == "[FMP-Field:locations::location_name]")

{

loc_total += [FMP-Field:qty];

tot_qty += [FMP-Field:qty]; }

else

{

if (curr_loc != "") { document.write(curr_loc + " | " + loc_total + "

"); };

curr_loc = "[FMP-Field:locations::location_name]";

loc_total = [FMP-Field:qty];

tot_qty += [FMP-Field:qty];

} ;

[/FMP-Record]

document.write(curr_loc + " | " + loc_total + "

");

document.write("Total Quantity: " + tot_qty);

This script summarizes quanities sold for each city.

Good Luck.

Garry