Group the detail band

rbuser

Here's my SQL statement:

SELECT p.Name, p.Code, p.Price, ol.Qty AS QtyOrdered, c.Name AS Category
FROM Product p
INNER JOIN OrderItem ol ON ol.productID = p.ID
INNER JOIN ProductCategory c ON c.ID = p.CategoyID
WHERE ol.OrderID = 2

I can display all the ordered items on the detail band, BUT now I want to
group the items by category name and then the items of each group under each
category name.
ON Report designer, I click:
Report|Groups...

I got List index out of bound error. Then the groups pop up dialog came up
BUT the drop down list box is empty.

nicocizik

Hi Alan,

This is not a known error with RB 9.02. Which version of ReportBuilder are
you using? Perhaps try upgrading or downloading a trial of the latest
version and testing with that.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com