Single result sets exported to Excel may not be enough for your needs. You might have a project where the end user wants multiple results in a single page. And of course you would like to make it attractive.

You can build complex reports by sending result sets to specific cells of a worksheet. Here is a report that I run monthly to show connection types and module usage.

Building Complex Reports

For this report I have an excel file that contains only the formatting. I want to save this template and always use it as my base.

This report contains only the formatting

So in my automation script I make a copy of template.

Copying Template

Then using the Select to file I export to specific cell locations. Note: In TDP 3.3 you will need to use the Export Wizard template activity to export to specific cell and named worksheet. 

About the Author

Debbie Peabody

Debbie Peabody is a Software Development Team Lead. She joined Quest in 1997 coding for Quest’s SQL Tuning product SQLab. She brings many years of experience of development on database tool products and co-designed Toad Data Point.

Start the discussion at