XSLT - FMP to Excel - Trailing Grand Summary

[damon_albran]

Hi Folks,

I am a beginner of XSLT and I am working on a function to export a MS excel file by XSLT from FMP 8.

My report format in filemaker contains sub-summary (sort by a category field), body, and trailing summary. I have a summary field placed on both sub-summary and trailing grand summary, I have already figured out how to do the sub-summary in XSLT, however, I still don't know how to do the trailing grand summary. Actually, I do not want to export a static summary number, I want the XSLT would pass a formula to Excel to do the grand summary there.

Any ideas will be much apprecidated!

Thanks,

Jarvis

[beverly]

Are you passing the entire result XML to Excel? Have you created a template in Excel and saved is as XML, as a basis for the XSLT that could be used to create the proper schema?

A little more information, please.