scvens
asked on
Max value in SSRS 2005
Hi i am working on a report and i have a column which contains values which are extracted by calculating values in other columns. Some thing
like this there are 4 columns A B C & D Now
A= fields!XXXX.value
B= fields!123.value
c= iif(previous(fields!XXXX.v alue) = fields!XXXX.value,fields!1 23.value,0 )
D=code.add(reportitems!tex tbox11.Val ue.ToStrin g) ie:-Textbox 11 is notthing but columnC as C dosent have a field name i could not use running values function to sum up the values in column C thats why i wrote a custom code that sums up values which are in column C step by step. Now in D i got the step by step summing of values in C now in the last column of D i will get total sum of C values. Now my task is to extract Max value from Column D. For that i tried using this expression = max( code.add(reportitems!textb ox11.Value .ToString) )
but it gives me Error. Now i dont know how to display the max value of column D. As i need Max value of column D to do further Calculations. Can you please help me out by letting me know how i can extract Max value of Column D.
My custom code to ADD Values in Column C 1 by 1 is
DIM totalsum as integer = 0
public function add(byval wattrating as integer) as integer
totalsum = totalsum + wattrating
return totalsum
end function.
DO i have to write other custom code to get max value if yes then how do i write the expression to call max value using custom code?
like this there are 4 columns A B C & D Now
A= fields!XXXX.value
B= fields!123.value
c= iif(previous(fields!XXXX.v
D=code.add(reportitems!tex
but it gives me Error. Now i dont know how to display the max value of column D. As i need Max value of column D to do further Calculations. Can you please help me out by letting me know how i can extract Max value of Column D.
My custom code to ADD Values in Column C 1 by 1 is
DIM totalsum as integer = 0
public function add(byval wattrating as integer) as integer
totalsum = totalsum + wattrating
return totalsum
end function.
DO i have to write other custom code to get max value if yes then how do i write the expression to call max value using custom code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.