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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics