I have searched for days trying to find answer to this without any sucess.
there's only one grand total.
But when you need multiple aggregates on the same level you can simply delimit them by comma:
with sum(RACK_UNITS)(title 'Total Rack Units:'),
sum(VENDOR_MAX_WATT_POWER)(title 'Total WATT POWER:')by location
with sum(RACK_UNITS)(title 'Grand Total RUs:'),
sum(VENDOR_MAX_WATT_POWER)(title 'Grand Total WATT POWER:');
Btw, are you actually still running BTEQ reports like this? I almost forgot about that syntax :-)
Thank you Raja and Dieter. Dieter's response gave me the output I was looking for.
And yes, I am still using BTEQ for reports. I know I could use Crystal Reports, but I've never been a fan of that software. Is there some other reporting tool I should be looking at that gives me the ability to schedule and e-mail reports out? I am just a shell nut, but willing to change if I find something that can do what I'm looking for.
almost any reporting tool should be able to do what you want, but why changing it when it suits you?
I just wondered because such BTEQ reports used to be printed directly on that nice green-white endless-paper and now everybody wants some more fancy-looking, fully-colored, graphically appealing report ;-)