Exporting Summary Fields

[selzlerb]

Hello Team,

I'm having a formatting problem with exporting data.

I've created a database that will allow me to track absences for the schools in my district. What I want to do is export the summary data for each school to a tabbed text file for use in Excel.

I've created a layout that displays what I want to export. Note the "Preview" jpg attachment. However when I actually export the file it exports the same summary data for each school repeated for each absence. Note the "Export" jpg attachment.

I have a separate table each for "Students", "Absences", and "Schools". Both the students and schools layouts have portals with fields from absences in them.

First, I'm not understanding why the export is behaving the way it does. And second, if I need to have another table to do what I wish, how will I relate it to the others so that the same thing doesn't continue to happen?

Let me know what you think.

- Sez

[Ender]

In the Export dialog (on the upper right), you should be able to Group by the Sort fields, then add the desired Summary fields to the Export order (it will move the selected Summary field and a Summary by Whatever-you-sorted-by field, you should keep both).

[selzlerb]

Hello Team,

Thanks for the Reply, however I had already done that and I continue to get strange results.

Note the "export" jpg. I've been trying this and in the field area it "duplicates" the entries by itself.

The closest I've been able to come to the kind of results I want is evidenced in "excel" jpg. But notice how the first row has duplicate entries. The others don't, just the first row, but that creates an incorrect alignment of the data. This can be fixed manually in Excel, however I'd rather it just export the data correctly as I have other fish to fry with exporting data in this database.

Also, sorry for the sloppy look, I don't work on the "polish" until I get everything working to my satisfaction.

This is an odd one for me. Let me know what you think.

- Sez

[selzlerb]

Hello Team,

It looks like the best solution is to choose to save records as an Excel file rather than export them to a tabbed file. So it looks like this problem is resolved. Thanks.

- Sez