Need Help in SSRS Report

Question

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I don't think you can enable/disable parameters in SSRS. You could set the parameter values to a specific values like 'N/A' or something like that.

kaladharreddy15 SSC-Addicted Points: 476 More actions · Answer 2

Hi Jack,

Thank you very much

can you please let me know the exact process to

set the parameter values to a specific values like 'N/A' or something like that.

if you explain some example its very greatful

Thanks

Kaladhar

htilburgs Ten Centuries Points: 1117 More actions · Answer 3

What you can do is, modify your dataset by adding the next to your original select statement:

select '-Not Available-' as BatchNumFrom, '-Not Available-' as BatchNumTo
union
select ..........[your original selection]

Make sure that the name of your selection matches with the original selections.

Then edit your query like (change what you need)

where BatchNumFrom = @ParameterName and BatchNumTo '-Not Available-'

Do this for all your parameters you want to 'disable'.

Now when you run your report, you're able to select the -Not Available-' for your parameter.