August 31, 2012 at 5:11 am
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
August 31, 2012 at 6:22 am
this might not be the best section of SSC as its tends to be mainly for Tsql, however you might get a better/faster response on theis part of the SSC forum
http://qa.sqlservercentral.com/Forums/Forum1633-1.aspx
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply