SSRS not using default parameter values

Question

I have a report in which I did everything the same (with respect to parameters) as I always do, but for some reason when I preview the report in Data Tools, default values for SystemName parameter isnt used.

Here is a screenshot:

screenshot

Default and Available values are both set to a query embedded in the related dataset and no setting is different than the other parameters.

Has anyone experienced this before? Does anyone know what can cause this?

Additional screenshots:

Photos

Put `SystemName` in Label field for `Available Values` for System Name parameter. — Anup Agrawal, Jul 09 '14 at 19:59
Have you used Systemname as a parameter before? I'm wondering if it is a reserved word and that's causing problems. — Dave.Gugg, Jul 09 '14 at 20:39

score 1 · Answer 1 · answered Jul 10 '14 at 20:34

Found solution to my problem. The problem was my query in the dataset for the systemname parameter had blank entries. So I added a where clause to filter null and blank fields and problem was solved. I assume blank comes first when things are sorted so thats why i was geting a blank default value

SSRS not using default parameter values

1 Answers1