Post reply

Validation message for report parameter date validation

  • November 13, 2013 at 2:28 am

    #285163

    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.

  • November 13, 2013 at 9:00 am

    #1666123

    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

  • November 14, 2013 at 3:24 am

    #1666311

    Thanks, but can you describe it further, so that I can work on it.

  • November 14, 2013 at 6:15 am

    #1666344

    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.

  • November 14, 2013 at 12:29 pm

    #1666511

    Yep, David is correct, that is the exact method I use for error msgs etc in my reports.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply