move is null

[rodchar]

hey all,
i have a query that i bind to my dataset/datagrid that uses the WITH ROLLUP
keyword, so the totals show up at the top of the table. does someone know of
a clever way to move that 1st row to the bottom of the grid?

thanks,
rodchar

[Jacek Stawicki]

U¿ytkownik "rodchar" <ro*****@discussions.microsoft.comnapisa³ w
wiadomo¶ci news:97**********************************@microsof t.com...

hey all,
i have a query that i bind to my dataset/datagrid that uses the WITH
ROLLUP
keyword, so the totals show up at the top of the table. does someone know
of
a clever way to move that 1st row to the bottom of the grid?

Try to sort the query:

SELECT ProductID, SUM(UnitPrice) AS UnitPrice
FROM Sales.SalesOrderDetail
GROUP BY ProductID WITH ROLLUP
ORDER BY ProductID
--
JS
BRE Bank Dev Team, Poland

[rodchar]

thank you.

"Jacek Stawicki" wrote:

>
U¿ytkownik "rodchar" <ro*****@discussions.microsoft.comnapisa³ w
wiadomo¶ci news:97**********************************@microsof t.com...

hey all,
i have a query that i bind to my dataset/datagrid that uses the WITH
ROLLUP
keyword, so the totals show up at the top of the table. does someone know
of
a clever way to move that 1st row to the bottom of the grid?

Try to sort the query:

SELECT ProductID, SUM(UnitPrice) AS UnitPrice
FROM Sales.SalesOrderDetail
GROUP BY ProductID WITH ROLLUP
ORDER BY ProductID
--
JS
BRE Bank Dev Team, Poland