Groups and sorting

From: Nathan (nkmacgregor.TakeThisOut_at_softhome.net)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 06:39:02 -0600

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

Relevant Pages

  • Eliminating Sort on Specific Data in a Report
    ... I have designed a report that shows the following data: ... Sorted by the follwing criteria: ... subcategory the report shows is a blank space under the ... Country segment because Access actually reads the unassigned field as a ...
    (microsoft.public.access.reports)
  • Re: Groups and sorting
    ... I have a report based on one table. ... > then Subcategory. ... > the report sorts each group alphabetically. ...
    (microsoft.public.vb.crystal)
  • Re: Groups and sorting
    ... Nathan rambled: ... I have a report based on one table. ... > Category, then Subcategory. ... You'd be better off using an actual sort, such as by ID, Name, ...
    (microsoft.public.vb.crystal)
  • Re: automatic reordering for report
    ... >a macro reade the time of selection then a report is printed contain the ... >times which mean that the first user make selection be the first user in the ... You can only sort records on a Report based on data which exists in ...
    (microsoft.public.access.queries)
  • Sort file by computed field
    ... I want to sort records for a report in descending order of a computed ... How do I sort records in a file based on a computed field based on two ... Even a keyword for the command so I had something to look for would be ...
    (comp.lang.cobol)