I can't seem to get this to work today. I have a layout sorted by a field and the summary works. When I export to Excel the total record count shows on 1st row with nothing else. What am I missing?
Check the "group by" options that you specified for the export.
Grouped by Image Type
Does the first image in your first post show records or sub summary groups?
And exactly what sort order did you have at the time of import? (Might they be sorted by more than just "image type"?
What data type is "image type"? (It shows text in the field, but is field defined as number when you check it via Manage Database?)
They are the sub summary.
Records are sorted by image type, a text field.
I have a script that does a find/sort. The data is displayed correctly.
An export script goes to a "Print" layout showing the field summarized and sub summary , again data is displayed correctly.
The next script step exports the data.
Try this test.
Make a copy of your script, but halt it just before the export.
Run this copy of the script so that everything but the export takes place.
Manually inspect the data and then do this same export via manually choosing menu options instead of by script.
If this produces correct results try deleting this export records step and putting in a new copy. (I've seen export or import steps somehow corrupt their field mapping so maybe this is the case here.)
No go. Same results.
Print Screen/Export with Grouped data/ Export without grouped data.
Here is a simple test. Still doesn't work.
Retrieving data ...