Report Parameter validation in ssrs report
Alias Varghese
I have created one SSRS report having begin date and end date. If I provide end date< start date it will execute the report as shown in the image 
But that condition I need to show a pop up "Please Check the start date and end date provided". How to do this?
Hell Boy
Click Report Menu then Report Properties.
Go to Code Tab and add similar code as per your requirement:
Function CheckDateParameters(StartDate as Date, EndDate as Date) as Integer
Dim msg as String
msg = ""
If (StartDate > EndDate) Then
msg="Start Date should not be later than End Date"
End If
If msg <> "" Then
MsgBox(msg, 16, "Report Validation")
Err.Raise(6,Report) 'Raise an overflow
End If
End Function
And
Follow the Steps:
1.) Go the Report Parameters and add a parameter with the datatype is string.
2.) Check the Hidden checkbox and Allow blank value ckeckbox.
3.) From Default Values choose Non-Queried radio button and then press the FX button and paste this code.
=CODE.CheckDateParameters(<parameterStartdate>.Value,<parameterEnddate>.Value)
Then press OK.
See reference Link:
Easy Step by Step SSRS Parameter Validation Using Code & Conditional DataSet
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: SonarQube - How to change severity of mulitple rules in bulk
- Next: Custom directives and routing in AngularJS
Related
Related Related
- 1
SSRS report - Casing parameter
- 2
AX SSRS Report Parameter is shown but not useable in the report
- 3
Add a filter parameter to ssrs report
- 4
SSRS - Report Based on Parameter Selection
- 5
Report parameter validation message with Birt
- 6
SSRS Report Parameter Default Null Value not Applied
- 7
SSRS - Custom parameter layout was removed from the report
- 8
Pass query string parameter to SSRS report
- 9
Using SSRS join on the parameter passed in the report
- 10
Correctly wrap double quote to SSRS report parameter
- 11
SSRS passing multiple string parameter to another report
- 12
How to send parameter of a report to another? SSRS
- 13
SSRS - Getting report selected parameter with JavaScript
- 14
Pass query string parameter to SSRS report
- 15
SSRS Passing multi-select parameter to report
- 16
Scope parameter issue in SSRS report Expression
- 17
Month and Year options parameter in SSRS report
- 18
SSRS Report Works when the Parameter uses the "=" Operator but not "IN"
- 19
Set SSRS Report Parameter value with passed Querystring value in SSRS
- 20
Passing parameters to a report in SSRS but no report
- 21
SSRS report - panels are multiplying in a report
- 22
Change value of SSRS report parameter based on the input of another parameter
- 23
SSRS 2008: Show report parameter in textbox if parameter is not NULL or blank
- 24
SSRS Single report parameter used to set dataset query parameters
- 25
SSRS report parameter - single selection dropdown with ''select all''
- 26
SSRS report Showing or hiding a rectange with a parameter leaves a blank area
- 27
How do I reference a SSRS report parameter in an aggregate function in SQL
- 28
Add value of TOP (ALL) to parameter in SSRS report connecting to SSAS cube
- 29
How to pass all values of a field to a sub-report as a parameter in SSRS?
Comments