Issue customizing multi-value parameters where default value is blank

Hi Cleber75,

According to your description, it seems that the issue which you occurred is that a multi-value parameter with blank as default value cannot be set with blank value in the report manager interface. After testing the issue in my local environment, I can reproduce this scenario. In my test, the issue occurs when I don’t select any value as default value, it displays an error message” A value is required” when clicking Apply button.

Based on my research, this should be make sense. Because the parameter is a multiple parameter, it means that we can select multiple values as the parameter values, but at least one available value should be selected. We couldn’t select none as default value. So in your scenario, we should select a label which correspond to blank value as Default Value.

The following screenshot is for your reference:

If there are any misunderstanding, please elaborate the issue for further investigation.



Thanks,

Katherine Xiong

If you have any feedback on our support, please click here.

---

Katherine Xiong

TechNet Community Support

Issue customizing multi-value parameters where default value is blank

Thank you Katherine,

Yes, you understood the issue I'm experiencing correctly....I tried your suggestion and basically hit enter once in the multi-value boxes so that the parameters take the first empty value as default. That seemed to resolve the issue with the error messages, as I was able to apply the changes.

However, when loading the report it does not return any results (even though the parameters are correct), but once I hit the "View Report" button once it works fine...before an user wouldn't have to hit any button to see the results on the report.

This seems to be a hard one to get around...Any other suggestions? not sure if I did exactly what you meant...

Thanks,

C

dropdown selection

Hi Hemaak,

Please provide a complete code to help us reproduce your issue. You can use SkyDrive to upload file and then post url here.

Regards,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

Page caches using Windows Azure

Hi Jeff, thanks for advice. I was using a global App variable in 8.0 but in 8.1 I can't create a global App variable so I'm passing an object using Navigation.

Correct wrap text in SSRS, 2008 Excel Export

While export to Excel in SSRS 2008, the column name are getting wrapped. The autoGrow property of the cell has been set to true.

Please suggest how Wrap of the column header, can be avoided.

We try to adjust maunally , by which we have to increase the page size but prnting becomes an issue.(8.5 inch X 11 inch)

Please suggest

Correct wrap text in SSRS, 2008 Excel Export

We are experiencing problems with reporting services built-in Export to Excel. Basically, the columns get wrapped in Excel

Is there a method for removing the column wrapping

Correct wrap text in SSRS, 2008 Excel Export

Hi SubhadipRoy,

Based on my research, whether to wrap text or not is depended on the last column header in the table or matrix. If we set the CanGrow property of last column header to true, then the header row of table (matrix) will be expanded. If we set the CanGrow property of last column header to false, the header row will be shrunk as the designed size.

So in your scenario, we can try to set the CanGrow property of last column header to true in Reporting Services level. Alternatively, we can click the Wrap Text button to enable the expended extra-long text property in Excel level.

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support