Click here to Skip to main content
13,090,178 members (49,564 online)
Rate this:
Please Sign up or sign in to vote.
See more:

I have a reportviewer report with the following expression:

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 from [Weighted Average] or wite a similar function in the form code to sort the report. Please note that I use tableadapters and datasets.

With the above code I get function arguments: '>' not recognized.

Any help would be appreciated.

Posted 4-Feb-11 4:32am
Updated 4-Feb-11 5:25am
Sandeep Mewara 4-Feb-11 11:49am
Looks like you keep deleting you question and repost it. Why so?
Schalk Munnik 4-Feb-11 11:52am
The last delete I thought I had the solution - unfortunately I do not :)
Sandeep Mewara 4-Feb-11 11:54am
It's ok, you don't need to delete the questions. How would others know what was already discussed/suggested.
Schalk Munnik 4-Feb-11 11:56am
OK sorry - will leave it in future
Dwayne J. Baldwin 8-Feb-11 3:34am
Is this part of a sql command or an expression? Usually expressions are something like =Fields!FieldName.Value and the AS appears to be a column

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


Please try following might be helpful.

Dim dr As DataRow
       Dim WeightedAverage As Integer = IIf( Convert.ToInt32(dr("Number of A Levels"))>3,((Convert.ToInt32(dr("UCAS Points")/3)*(Convert.ToInt32(dr("Number of A Levels")-(1-(1/Convert.ToInt32(dr("Number of A Levels")))))/Convert.ToInt32(dr("Number of A Levels"),Convert.ToInt32(dr("UCAS Points")/Convert.ToInt32(dr("Number of A Levels"))

i have use dr that will be value of your Data Set current Row.

CPallini 9-Feb-11 9:13am
[Carlo on behalf of Shalk Munnik] Hi Imdadhusen,

I will try the code and get back to - thansk for your help.



This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170813.1 | Last Updated 9 Feb 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100