Default sort column for OFRs

[Bob Worley]

Its been a while since I've had to do this, can someone remind me if there is a way to specify which column to initially sort by in an On Form Report?

Version 6.6.3 btw ... 

____________________

Bob Worley

IT Applications Developer

Coburn Supply Co., Inc.

m: 214.676.9825

   

 

[Rick Weiser]

Hi Bobby,

Have a look at page 215 of the v699 manual.  You use  DBI.G.SORT.ONFORMREPORT.

Rick

[Bob Worley]

I'm already using that subroutine when the user clicks on the column header (Row 0) to manually sort.  Do I have to use this as well when the OFR is first loaded?

--
You received this message because you are subscribed to the Google Groups "DesignBais-Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to designbais-forum+unsubscribe@googlegroups.com.
To post to this group, send email to designbais-forum@googlegroups.com.
Visit this group at https://groups.google.com/group/designbais-forum.
For more options, visit https://groups.google.com/d/optout.

[Bob Garrard]

Hi Bobby,

Your basic code determines the initial sort. There will be some sort of SSELECT of your data that will present the data in your required sort sequence. 

Bob Garrard

To unsubscribe from this group and stop receiving emails from it, send an email to designbais-for...@googlegroups.com.
To post to this group, send email to designba...@googlegroups.com.

[Rick Weiser]

Bobby,

True but,  If you want DB to sort then after you build the grid, you can do a DBBUTTONCLICK = hidden button, which will run the sort subroutine.  This works.

Rick