12,063,242 members (53,070 online)
Rate this:
See more:
Hi,

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.

Regards,
Posted 4-Feb-11 5:32am
Edited 4-Feb-11 6:25am
v2
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

Rate this:

Solution 1

Hi,

```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.

Thanks,
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.

Regards,

Schalk

Top Experts
Last 24hrsThis month
 Dave Kreskowiak 337 CHill60 300 d@nish 175 Chris Maunder 135 Garth J Lancaster 120
 Dave Kreskowiak 1,827 Richard MacCutchan 1,225 d@nish 980 OriginalGriff 800 Sergey Alexandrovich Kryukov 733