The job worked great, until I attempted to use a template. I had some data manipulation in the template, creating percentages from the gathered rows, however when I ran the project the only thing attached to the email was the empty template.
When I created a generic template, with just every other line highlighted, the query populated cells on Sheet 2 of the spreadsheet, while sheet 1 contained the empty highlighted rows.
The documentation makes it seem easy and straightforward, so I must be doing something wrong. Any help is greatly appreciated.
Can you send us the Project XML for this? It will be much easier to review and help you figure out what's wrong that way.
Please email it to [email protected].
Lead Solutions Consultant