CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> General/Other

 Quick Sort Order Question

Print topic Send  topic

Author Message
accumold

Posts: 9
Posted: 08/28/2006, 8:04 AM


Is there a way to have a secondary sort order on a grid when the sort buttons are selected? And what sceondary is it defaulting to? Key Number?
_________________
Aaron
View profile  Send private message
matheus

Posts: 386
Posted: 08/28/2006, 10:37 AM

In the sorted, you can select many order parameters if you need.
_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br
View profile  Send private message
accumold

Posts: 9
Posted: 08/28/2006, 10:41 AM

I see the option for the sort column and reverse option but there is no control for "sort this column and then by this".

i.e. When the table displays first it is sorted by status then company name. When a user sorts using another filed, say by asignee, I want it to sort asignee then company.

Make sense?
_________________
Aaron
View profile  Send private message
wkempees


Posts: 1679
Posted: 08/28/2006, 12:18 PM

When using the Grid Builder, Step 2 of 5 (CCS 3.0.4.12)
you will see the Order By Drop Down List.
Default : None, next option: Custom
When you choose Custom, you will be presented your base table's field list, and you can build your own custom sort order mixing ascending/descending and fields.

If that is not answering your question, then:
In the grid (after generation), click the "sorter" to open up it's properties.
The properties of a sorter will show SortOrder and has [...] behind it to enable you to do what I described, to a sorter.
If you cannot see the [...] click in the Properties SortOrder and it will appear.


So Yes you can do multiple sorts.

Walter

_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
accumold

Posts: 9
Posted: 08/28/2006, 2:52 PM

I've gotta lay off the crack. I swear I didn't have that option when I first looked. That's what I expected it to do.

Thanks!!
_________________
Aaron
View profile  Send private message
WKempees
Posted: 08/28/2006, 3:00 PM

crack as in mind boggling substance, or as in illegal activation key?
Just kidding.

Walter

accumold

Posts: 9
Posted: 08/29/2006, 10:49 AM

I learned I'm not crazy after all. I have two different applications for this and one it worked as you said, the other was where I was having the trouble. If the table's data source is any thing other than "Table" it won't work. That table is currently set to SQL. I'll have to switch it.
_________________
Aaron
View profile  Send private message
wkempees


Posts: 1679
Posted: 08/29/2006, 3:19 PM

Hey
If it is set to SQL, then write your own Order by clause.
That is what SQL mode is for.

Switch back to Table if that is no problem and you'll have all available to you.

Walter


_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.