How to create Cross tab report using HTML5 and FM webviewer

[MetaSys Software]

Hi All,

 

In FileMaker, I have created cross tab report using subsummary parts and summary fields. But because of lot of summary fields in my sub-summary part and trailing grand summary part, my cross tab report is taking more than 20-25 mins to load. So, I need to speed up this loading time of this report.

 

So, for this I tried to create this report using HTML5 and jQuery/JavaScript with FM webviewer. However, I stuck at one point which is - how to pass summary fields data to html code since summary fields are working on the filemaker foundset.

 

Can any one please help me to create cross tab report using HTML5 and webviewer?

 

Thanks and Regards,

Trupti

Metasys Software Pvt. Ltd.

[No_access]

you can use

 

set variable ($$sumF; Value:GetSummary (Summary field;breakfield) - breakfield has to be part of the sort

 

I must be missing something in your request, Setting the information to a variable and passing to an HTML in web viewer is pretty simple. you can you make a sample file for me to look at. I will be glad to code it for you if needed.

 

thanks