all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Validations in SQL Server Reporting Services 2000


Validations in SQL Server Reporting Services 2000 parameshwarang NO[at]SPAM gmail.com
10/16/2005 11:15:13 AM
sql server reporting services:
Hi Guys,

I had posted an earlier query on how to do validations of dates on SQL
Reporting 2000.
We have finally found a way to do it. It is not the best way, but it
does work and suit our requirements.

What we do is pass the dates entered in the MDX Query, Stored Procedure
to a VB .NET function within the XML of the RDL File.

For example we write a function GetDay(<Parameter>) and within this we
first check whether this consitutes a valid date using the IsDate()
method. If it is not then we return back an error string.

The visibility of the report depends on whether this function has
returned back any record.

If any body needs a sample of the implementation, do write in to me and
I would send it across.

Thanks,
Param
Capgemini India
Re: Validations in SQL Server Reporting Services 2000 srini
11/2/2005 8:52:07 AM
param-

could you pl. send me the sample.

sreenumay15@gmail.com
AddThis Social Bookmark Button