Dear Alan,
You should be able to control the number of blank lines with the skip rows variable in the general section of the program preferences. While checking it I noticed that SQL*XL outputs one line too many... I have corrected this in SQL*XL 4.0.32.
Another way to control the number of blank rows is through the break on the report. This was partly implemented. I have now completed the implementation in SQL*XL 4.0.32. You can create a report break to skip a number of lines:
break on report skip 2; Note that these lines come before the feedback line if you have set the feedback on.
To do what you require I suggest you use one of the following techniques:
- Use the select to syntax:
select mycol from mytable to A1;
Use this syntax to put the data at a certain column. You can change your SQL in each cell to contain the to clause. If you the formula =ADDRESS(ROW(),COLUMN(),4) Excel will return the current cell address which you may want to use to make the target addresses variable. You should be able to make the formulas such that you end up with:
A1: select count(*) from table1 to E1;
A2: select count(*) from table2 to E2;
A3: select count(*) from table2 to E3;
- You can also use the cell formula SQLQueryValue to achieve the same. If your select statements are in column A you could use the formulas in columns E to display the result:
E1: =sqlxl.xla!SQLQueryValue(A1)
E2: =sqlxl.xla!SQLQueryValue(A2)
E3: =sqlxl.xla!SQLQueryValue(A3)
For more information about the SQLQueryValue statement see:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135155904