Sorting using SHAPE? 
Author Message
 Sorting using SHAPE?

Howdy,

I've created a Grouping Shape command that sorta looks like this:

SHAPE {<sql string here>} AS TEST BY '<field1>', '<field2>'

It appears that any sort applied in the SQL has no effect on the data
displayed on the report that uses the resulting recordset; however, the
fields listed in the "BY" clause do have a "sort-by-ascending" effect. My
question is this: How does one produce a "sort-by-descending" effect? Would
be appreciated muchly. There doesn't seem to be a lot of documentation about
how sorting is done when using the SHAPE command.

Casey



Sat, 17 Apr 2004 02:20:48 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Shapes shapes shapes

2. Can't sort Outlook Personal Folder using Items.Sort

3. Problems using SHAPE command when building Database connection string using UDL File

4. Sort order - Edit Filter Sort or Quick Sort

5. new shape in another shape

6. Adding a shape from Forms Shapes Stencil

7. How to differentiate a shape created from Stencil drag/drop and shape Copy/Paste

8. How to update document master shapes from template master shapes

9. Dynamically convert shapes to Process Engineering shapes

10. Dropping shapes through VBA with shape Custom Properties setting ASK =True

11. Convert Inline to Shape and Anchor Shape

12. grouping shapes and convert to inline shape

 

 
Powered by phpBB® Forum Software