CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 custom sort of groups

Print topic Send  topic

Author Message
umar000

Posts: 16
Posted: 12/29/2009, 9:19 PM

suppose we making report using groups. groups in code charge provide Asending and desending sorter of GROUP but if we want to sort record thorgh custom srt then how we can do it?
_________________
Umar
View profile  Send private message
damian

Posts: 838
Posted: 12/30/2009, 1:02 PM

Quote umar000:
suppose we making report using groups. groups in code charge provide Asending and desending sorter of GROUP but if we want to sort record thorgh custom srt then how we can do it?

if you want to use a different field for your sort you can use teh visual query builder to do this
if you want somethig more advanced you may need to switch to sql instead of table to create your query


_________________
if you found this post useful take the time to help someone else.... :)
View profile  Send private message
Oper


Posts: 1195
Posted: 12/30/2009, 6:08 PM

if by dynamic you mean choose different order while runing yor code
  
function Tasks_DataSource_BeforeBuildSelect(& $sender) {  
global $Tasks;  
  
  If ($Tasks->DataSource->Order == "") {   
     $Tasks->DataSource->Order = "task_name DESC";  
  }  
    
}  

  
Function Tasks_DataSource_BeforeBuildSelect(Sender)   
  
  If Tasks.DataSource.Order = "" Then   
     Tasks.DataSource.Order = "task_name DESC"  
  End if   
	   
End Function  


be aware this could brake your code report, depend what field you use for group/sort.

Function from CCS Help
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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