We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,289 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Expression in sorting

Hi,
I have a reportviewer report with an expression in the one field as follows:

IIf([Number of A Levels]>3,(([UCAS Points]/3)*([Number of A Levels]-(1-(1/[Number of A Levels]))))/[Number of A Levels],[UCAS Points]/[Number of A Levels]) AS [Weighted Average]

I need to use the results in the [Weighted Average] to sort the output.

I use table adapters and datasets

Any help will be appreciated.

1
Contributor
0
Replies
1
View
Question
Answered
smun04
Newbie Poster
2 posts since Nov 2009
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0
Question Self-Answered as of 2 Years Ago

This question has already been solved: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0439 seconds using 2.48MB