Re: Groups and sorting

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Briscobar (youcant_at_sendmespam.com)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 09:04:43 -0500

In news:OnYxp2OFFHA.3732@TK2MSFTNGP14.phx.gbl,
Nathan <nkmacgregor.TakeThisOut@softhome.net> rambled:
> Hi,
>
> I'm using CR for VS.NET 2002. I have a report based on one table.
> The table has, three important columns: Category, Subcategory, and
> ItemNumber. These all hold strings. The report is grouped by
> Category, then Subcategory. I have loaded each row into the table in
> the order in which I want to see the categories and subcategories on
> the report, but the report sorts each group alphabetically. I don't
> really want them to be sorted at all. Is there a way to do this?
> I've tried adding two colunms to the table: CategoryPosition and
> SubcategoryPosition, then entered these in the Sort Records box, but
> I get the same results. Any suggestions?
>
> Thanks,
> Nathan

A table, by definition, is an unordered set of data. Regardless of the order
you loaded it into the database, it is stored unordered. When you run a
SELECT statement on the table, the *output* can be ordered, but the table
itself cannot. I suggest not using the "original order" for this, as it can
be sketchy. You'd be better off using an actual sort, such as by ID, Name,
or whatever it was that determined the order you entered them into the
table.

HTH. 

-- 
KB  -  MCNGP "silent thug" #26
Briscobar AT gmail DOT com
A.S.S.F.U.C.K.E.R.S. are not welcome at www.mcngp.com. Unless you email
cheatsheets@mcngp.com first.
Quantcast