SSRS - Remove from the parameter dropdown in a deployed report

Question

SSRS - Remove from the parameter dropdown in a deployed report

avani104

SSC Veteran

Points: 227
More actions
December 30, 2008 at 4:56 am

#195538

Hi
I have a doubt in SSRS.I created a report and it have the parameters ProductID. I wanted to have a default value, so in the report Parameters-> Default Values; i have bound it to a query .
When i view the report by clciking on the preview tab, the ProductID dropdown does not display '< Select a Value> '. After deploying that report in the Server. I have a problem that it shows another perameter '< Select a Value> ' in the drop down as the first parameter. I want to remove that '< Select a Value> ' from the drop down and I want to show only the parameters that the query returns i.e. ProductID. Can any body help how to remove the '< Select a Value> ' from the drop down list.

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

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

dva2007 SSCertifiable Points: 7707 More actions · Answer 1

Remove the parameter from the report itself. Create new parameter. If you need from query then u need to put into available values of parameter. U can select dataset and field name. If u select default value then drop down will appear but not allow you to select any value. it will select first record as default value and run the report.

please let us know if you find more problem.

nidhiraj Valued Member Points: 63 More actions · Answer 2

But when we deploy the default will appear in dropdown.

how to remove that

sanjeev_aec SSC Rookie Points: 29 More actions · Answer 3

[font="Verdana"]

Hi,

I had also faced same problem, some time ago but now able to solve that. U have to put a default value always for the parameters as dropdown. It can be set into Report --> Report Parameters --> Default Values

U have to set any value, either hard coded or dynamically (e.g first value of dropdown) in the Non-Queried or From Query options respectively always. Hope it will solve problem at ur end as well!

Plz let me know if it not works.

Regards,

Sanjeev.

[/font]

sudip678 SSC Rookie Points: 31 More actions · Answer 4

Hi,

I have a dataset for a country drop down as

Name Value

Select a Country 0

India 1

USA 2

The default value for the parameter is selected as 0

so when I preview it in my report manager it seems fine and default value is "select a country"

But when I deploy and see in browser the default value remains "select a country" but at the same time a new value gets added in the parameter list.

Kindly let me know how can I remove it from my parameter drop down list.

Please help.