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