Sub-summary fields don't show on the IWP

[Flo]

Hi everybody,

I would like to generate a report that contains sub-summary fields. It works very well on the full client, but if I access the layout on the IWP, no records are shown.

Also, whenever I want to sort these records (even if there is nothing to sort -/ ) It's like if there were no field on the layout....

Is there any known issue about sub-summary fields and IWP ?

I hope you understood my problem, it's a bit weird tho.

Thanks for your help !

[Flo]

Ok, I found the solution, sub-summary field are simply not compatible with the IWP.... So I adapted my solution in a compatible way :

Seeya

[night_writer]

What option did you elect? I have a similar problem and have looked at several potential work-arounds but can't seem to get any of them to really work.

My initial thought was to write a summary calc field that would Count, but FMP doesn't support counting text very well. Next option is to write a calc field that uses an IF statement to assign a numeric to the field value and then sum those.

Really need a CountIf type function...

Thanks for passing on your solution.

Grant