Generating multiple excel files and dumping them to a folder

Topics: Developer Forum, Project Management Forum, User Forum
Jul 1, 2013 at 8:45 PM
I am trying to generate multiple excel files dynamically from data entered into the database.

I have a "watersources" table and each watersource is linked to multiple entries in the "dataentries" table.

For each waterource, a file needs to be created with each data entry for that watersource.

Everything works fine when creating just one file but when I try to loop through, it breaks. Not sure where I need to save the file at the end of each loop.