Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Validation message for report parameter date validation Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 2:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:22 AM
Points: 613, Visits: 1,160
Hi

I have to show a validation message in my SSRS report if the report parameter start date is less than the end date. I try googling, but I could’nt find a way that will really work out. Please help on this.
Post #1513745
Posted Wednesday, November 13, 2013 9:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:54 AM
Points: 281, Visits: 1,308
Hi,

You could do this by having a textbox on the report containing your validation message, and toggling the visibility of the main report components (e.g. table, matrix etc) and the message textbox when startdate>enddate

Cheers
Paul
Post #1513941
Posted Thursday, November 14, 2013 3:24 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:22 AM
Points: 613, Visits: 1,160
Thanks, but can you describe it further, so that I can work on it.
Post #1514201
Posted Thursday, November 14, 2013 6:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:30 AM
Points: 7,057, Visits: 7,287
Add a textbox at the top of your report containing the error message as you would like to see it.
Right click on the box and select textbox properties, select visibility, select show or hide depending on expression, select expression icon (fx).
Add expression to compare the dates ie
=Parameters!FromDate.Value<=Parameters!EndDate.Value



Far away is close at hand in the images of elsewhere.

Anon.

Post #1514241
Posted Thursday, November 14, 2013 12:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 1,170, Visits: 2,545
Yep, David is correct, that is the exact method I use for error msgs etc in my reports.
Post #1514444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse