I am new to the Telerik suite and am just learning the ropes on creating Telerik reports.
I have a SQL Server stored procedure that outputs number of minutes (using datediff() function in SQL). That is to be a signed integer. My result set would look like this:
Date Name TotalMinutes
1/1/2011 Jim 20
1/2/2011 Jim 15
1/3/2011 Jim 30
1/4/2011 Jim 5
I have a report setup to display the data just as it appears above. In a grouping footer I have it SUM the minutes to get a total (e.g. 70). I created a user function that takes that value and adds 10 to it. So, the expression for my textbox field in the footer is as follows: = AddMinutes(Sum(Fields.TotalMinutes)), which given my example should return 80 for Jim
My user function is defined in a class file (DateFunctions.vb):
Public Shared Function AddMinutes(byval TotMinutes as Integer) as Integer
return TotMinutes+10
End Function
I am not using any code-behind on the report itself. I am just putting an Expression in through the GUI. When I try to run this I get a Undefined Function error in the report. I tried calling it as =DateFunction.AddMinutes(Sum(Fields.TotalMinutes)) and just as =AddMinutes(Sum(Fields.TotalMinutes)), but I keep getting the same error.
Please Help as I am stuck!
I have a SQL Server stored procedure that outputs number of minutes (using datediff() function in SQL). That is to be a signed integer. My result set would look like this:
Date Name TotalMinutes
1/1/2011 Jim 20
1/2/2011 Jim 15
1/3/2011 Jim 30
1/4/2011 Jim 5
I have a report setup to display the data just as it appears above. In a grouping footer I have it SUM the minutes to get a total (e.g. 70). I created a user function that takes that value and adds 10 to it. So, the expression for my textbox field in the footer is as follows: = AddMinutes(Sum(Fields.TotalMinutes)), which given my example should return 80 for Jim
My user function is defined in a class file (DateFunctions.vb):
Public Shared Function AddMinutes(byval TotMinutes as Integer) as Integer
return TotMinutes+10
End Function
I am not using any code-behind on the report itself. I am just putting an Expression in through the GUI. When I try to run this I get a Undefined Function error in the report. I tried calling it as =DateFunction.AddMinutes(Sum(Fields.TotalMinutes)) and just as =AddMinutes(Sum(Fields.TotalMinutes)), but I keep getting the same error.
Please Help as I am stuck!