M
Mike
In A07, any ideas on how to export multiple queries into the same excel
sheet with a single click as I do now in A03? The boss needs them on one
sheet. They have the same columns. Together they will always fit on one
sheet with plenty of room to spare.
Now, in A03 I OutputTo Excel a main REPORT that just contains 2 subreports
that are each based on a query. The first subreport grows and shrinks such
that the second subreport tucks itself nicely just below the first
subreport's last row. The subreports and underlying queries are setup column
wise to be the same such that with a single click it works great. Both
subreports, one above the other, are exported to a single excel sheet with a
single click of my mouse.
Then comes A07 and say goodnight dick! Or at least I have not found a
solution yet.
Thanks ahead of time. And obviously redirect this to the appropriate group
if I placed it in the wrong one and let me know where it is at.
Mike G.
sheet with a single click as I do now in A03? The boss needs them on one
sheet. They have the same columns. Together they will always fit on one
sheet with plenty of room to spare.
Now, in A03 I OutputTo Excel a main REPORT that just contains 2 subreports
that are each based on a query. The first subreport grows and shrinks such
that the second subreport tucks itself nicely just below the first
subreport's last row. The subreports and underlying queries are setup column
wise to be the same such that with a single click it works great. Both
subreports, one above the other, are exported to a single excel sheet with a
single click of my mouse.
Then comes A07 and say goodnight dick! Or at least I have not found a
solution yet.
Thanks ahead of time. And obviously redirect this to the appropriate group
if I placed it in the wrong one and let me know where it is at.
Mike G.