Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Date parameter validation problem in SSRS Report

Author  Topic  Eranna Starting Member 2 Posts Posted - 2009-08-19 : 13:07:55 Hi, I have two parameters as start and end date. I have to validate them if the user enters any text ( a message box should pop up ). The solution i have is I created a hidden parameter and calling a custom code passing the date parameter and popping up the message box from the custom code. However it is not passing the value if i enter any string to the custom code. However this works perferctly fine if i make the date parameter as a string. I tried to convert in many ways the value of the parameter before i send it to the function but of no use. Could any body help in this. Thanks, Eranna