Rattlesnake
Freshman
- Joined
- Dec 23, 2003
- Messages
- 47
Hi,
I am creating an application in ASP.net (using VS 2003).
I have a datagrid that displays a list of deliveries that are to be made to several customers.
The Delivery have the following info :
PO. No
Customer
ProductID
Quantity
DeliveryDate
On a particular Date there will be several Products that have to be delivered to a single customer.
I want to group the records in the Datagrid by DeliveryDate and then by Customer , so that all the deliveries for a customer for a particular date are listed together. I know how to create the query for this.
Currently I can display the deliveries sorted by Date and then by Customer.
Is there a way I can display the the grouped deliveires in a Drill down manner i.e that the Main row should show the Customer and the Delivery Date and when drilled down the other details of the delivery should be shown like PO No.,Product ID , Quantity etc)
I would also like to know how can I have ALTERNATING background COLORS for groups so as to distinguish between them.
Thanks
I am creating an application in ASP.net (using VS 2003).
I have a datagrid that displays a list of deliveries that are to be made to several customers.
The Delivery have the following info :
PO. No
Customer
ProductID
Quantity
DeliveryDate
On a particular Date there will be several Products that have to be delivered to a single customer.
I want to group the records in the Datagrid by DeliveryDate and then by Customer , so that all the deliveries for a customer for a particular date are listed together. I know how to create the query for this.
Currently I can display the deliveries sorted by Date and then by Customer.
Is there a way I can display the the grouped deliveires in a Drill down manner i.e that the Main row should show the Customer and the Delivery Date and when drilled down the other details of the delivery should be shown like PO No.,Product ID , Quantity etc)
I would also like to know how can I have ALTERNATING background COLORS for groups so as to distinguish between them.
Thanks