September 2, 2012 at 9:50 pm
Hi,
I have faced an issue while deploying the rdl to report server for my application. I have a report with two input parameter Start Date and End Date. I have created a custom code function for validating these two dates. i . e Start Date should be less than End Date. It ran successfully in my machine. (VS Designer) . But I could not able to run the rdl in report server. When i remove the custom code portion then it works fine in report server.
I have tried in different report server. But issue is still exists. I didn't use any custom assembly. Just a custom code function.
I have done the code in below link
http://gugiaji.wordpress.com/2012/03/26/easy-step-by-step-ssrs-parameter-validation-using-code/
I have done the following steps
1. I have created two input parameter as Start Date and End Date with Date time as data type
2. I have created a custom function as ValidParams
function ValidParams(byval startdate as datetime, byval enddate as datetime) as boolean
Dim msg as String
msg = ""
If (StartDate > EndDate) Then
msg="Start Date should not be later than End Date"
End If
If msg <> "" Then
MsgBox(msg, 16, "Report Validation")
Return True
Else
Return False
End If
end function
3. I have created a new input parameter as IsValidParam with datatype as Boolean and Hidden is true. Set the default value as =code.ValidParams(Parameters!pFromDate.Value, Parameters!pToDate.Value)
When I run the report in my machine , its working fine.
But in report server, am getting an error like
Error during processing of ‘IsValidParam’ report parameter. (rsReportParameterProcessingError)
Can you help me to resolve it
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply