Did you use the "group by" option?
this option exports one row of data per sorted group just like your summary report.
Thanks for your reply
Maybe I'm having a 'blond moment here but where will I find the 'group by option?
When in the layout of the sub summary report, in preview mode is where I attempt to export to excel
Just to note I'm using FM Pro v 11
Group by is found in the export options on the right side. If I am not mistaken, though, I thought that group by would export ONLY the grouped info and not the detail. If that is true you may have to make a dummy table and move records temporarily into this table including creating lines for subsummaries and then export from that context. You have full control then because you are making the table yourself as you go, via a script.
1 of 1 people found this helpful
If I am not mistaken, though, I thought that group by would export ONLY the grouped info and not the detail.
That is exactly the case and since we are discussing a summary report with no body layout part, that would seem consistent with what is needed here. The group by option also will not appear unless you records are sorted for the same reason that sub summary parts are not visible unless you have correctly sorted your records.