Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Grouping and Sorting in ASP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-23 : 10:55:13
Robb Webster writes "When you create reports in Access 2000, you are able to group and sort each section according to the specific header of that section and results are restricted by that header. Is there any way to duplicate this same effect using ASP? For example, if I am pulling from the following data:

Location___Room____Furniture

school_____office____desk
school_____office____chair
school_____classroom___desk
school_____classroom___chair
home_______bedroom_____bed
home_______bedroom_____bureau
home_______bedroom_____table
home_______office______desk
home_______office______chair
home_______office______table

Can I get a report that looks like this?

Location
___School
_____Office
_______Desk
_______Chair
_____Classroom
_______Desk
_______Chair
___Home
_____Bedroom
_______Bed
_______Bureau
_______Table
_____Office
_______Desk
_______Chair
_______Table

Thanks a bunch!"
   

- Advertisement -