October 13, 2006 at 1:12 am
Hi All,
I have been using Sql Server 2005 Reporting Services.
I have used grouping(in Table object) in my report and used calculated value in one column.
I have to put the group total of the calculated value in group footer of Table object.
But when I try this, it generates error message.
Can any one help me about how to resolving this problem, please?
Thanks & Regards,
Muthukumar.C
October 16, 2006 at 8:00 am
This was removed by the editor as SPAM
October 26, 2006 at 8:53 pm
Hi Muthu,
I believe the Field Format is not in currency/money format. Please try
=Sum(Convert.ToDecimal(Fields!urfieldname.Value), "urDataSetName")
Cheers
Sujith
October 27, 2006 at 3:37 am
Hi Muthu!
I thnik u calculating the value which is generating an error e.g. divide by zero.
is it so then use the Function in code window to calculate that value and invoke that Function in Table Group... u will not hv any problem any more.
Example is giving Below:
Public Function CalcPercent (ByVal Numerator As Object, _ &
ByVal Denominator As Object) As Object
If Denominator = 0 and Numerator = 0 Then
CalcPercent = 0
ElseIf Denominator = 0 and Numerator <> 0 Then
CalcPercent = 0
Else
CalcPercent = Numerator / Denominator
End If
End Function
Now write =Code.CalcPercent(Numerator,Denominat) in ur Table Group
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply