Click here to Skip to main content
11,922,026 members (38,065 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB9.0 VB VB.NET

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 5:32am
Edited 4-Feb-11 6: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
0 OriginalGriff 493
1 Dave Kreskowiak 285
2 Sergey Alexandrovich Kryukov 243
3 Richard MacCutchan 155
4 ppolymorphe 135
0 OriginalGriff 7,231
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,356
3 George Jonsson 2,865
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web03 | 2.8.151120.1 | Last Updated 9 Feb 2011
Copyright © CodeProject, 1999-2015
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