SQL 2 Excel Pro has now got the ability to generate your spreadsheets from multiple SQL queries - not just one like in the free version.

You specify one main query as usual, then you can add data from other queries using "Extra Cells". You specify which cell the output from the extra query should start (upper left corner) and the data will be populated in your sheet. The query can return just a single value, or multiple rows and columns. Add as many extra queries you need like this.

Here's a simple example:

1. The main query is specified to output two fields from the jos_content table
   
   
   
   
2. We then define "Extra Cell" as a SQL based data. Two SQL queries are defined in this example.  One selects the same thing as the main query, just for demonstration purpose. But it can be anything you want. The second query calculates the max(id) as writes that number in a cell.
   
   
   
   
3. The downloaded spreadsheet looks like this:
   
   
   
   
   

Which database you use for each SQL query is controllable. This enables you to build really complicated reports and pull the information from multiple database sources.

The example above is pretty lame but I hope it illustrates the power and flexibility you have at your fingertips with SQL 2 Excel Pro.

Comments (0)

Subscribe to this comment's feed

Name

Email

Comment

smaller | bigger

Subscribe via email (registered users only)

I have read and agree to the Terms of Usage.

Write the displayed characters

Add Comment