13,090,178 members (49,564 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 4:32am
Updated 4-Feb-11 5: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

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

Top Experts
Last 24hrsThis month
 Richard Deeming 170 Graeme_Grant 110 ppolymorphe 90 RickZeeland 90 ProgramFOX 80
 OriginalGriff 3,412 Graeme_Grant 1,874 ProgramFOX 1,707 Jochen Arndt 1,645 ppolymorphe 1,507

Advertise | Privacy |
Web04 | 2.8.170813.1 | Last Updated 9 Feb 2011