Tuesday, February 9, 2016

I need to avoid "Please select a value for the parameter ''ParameterName" message comes in RDLC

In Reporting Services, each parameter must have a value which can be a blank value and null value when we try to run a report the closet approach is to add a blank value to the parameter available values and set the blank value as the default value. Please note that a blank value will be added to the dropdown list the parameter after doing so. To do this, please refer to below Example:

SELECT
0 as ID,
'All' AS JobName
Union
SELECT
  LkupJob.ID,
  LkupJob.JobName
 FROM
  LkupJob

No comments:

Post a Comment