start date - end date validation in report builder 3.0....
hello all
i want to validate date time in my report created in report builder 3.0
that end date should be greater that start date.
how can i do that????
Regards, Kartik Ghodasara Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
August 28th, 2012 5:18am
Hello Kartik,
Actually, There is no built in way of validating the inputs.
What you can do is the add a textbox to report add a message for validation error and whow the text box only when there is a validation error.
You can also hide the table, chart if there is a validation error.
- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2012 5:32am
Hi chintak
thanks for reply
can you please provide me step and validation code for displaying the error text in textbox when enddate is less than startdate????
Regards, Kartik Ghodasara Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
August 28th, 2012 5:56am
Hi chintak
thanks for reply
can you please provide me step and validation code for displaying the error text in textbox when enddate is less than startdate????
Regards, Kartik Ghodasara Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
HI Kartik !
You need to write below expression in your textbox as suggested by chintak;
=IIF(Parameters!END_DATE.Value < Parameters!START_DATE.Value, "End Date must be greater than or equal to Start Date", "")
Now in textbox visibility option write below expression;
=IIF(Parameters!END_DATE.Value < Parameters!START_DATE.Value, FALSE, TRUE)
And in your tablix / matrix please write below expression in Visibility;
=IIF(Parameters!END_DATE.Value < Parameters!START_DATE.Value, TRUE, FALSE)
Please let me know if this doesnt work for you. Hope I have answered you correctly.
Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2012 6:27am