RS.Sort with calculations?

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
RS.Sort with calculations?

Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

September 27th, 2003, 11:38 PM

sstian

Registered User

Join Date: Sep 2003

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

RS.Sort with calculations?

Hi!

I am trying to list out a football league table using RS.Sort.
I want to display goals scored and goals conceded in separate columns, but when I sort the table it has to be based on goal difference (goals_scored - goals_conceded).

I have tried this:
RS.Sort = "points DESC, (goals_scored - goals_conceded) DESC "

but it doesn't work, and I have found out that the problem appears due to my calculation.

Is there any way I can make this work?

Stian

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic sort order or sort datatype	kapy_kal	XSLT	2	September 18th, 2007 02:10 PM
how to sort cross tab.sort based on row total	joxa83	Crystal Reports	7	March 2nd, 2006 09:12 AM
Unable to sort using xsl sort command	sly_jimmy_boy	XSLT	3	June 17th, 2005 05:15 AM
RS Manager and RS Server on 2 different computers	Choose File	BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7	1	July 22nd, 2004 10:56 AM
Access Calculations	bjackman	Access	3	December 15th, 2003 09:44 PM