Reporting Services 2012 Parameters with NULL Allowed and Default by richardps

Active

Type:	Bug
ID:	772538
Opened:	11/28/2012 8:48:04 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Hi,

I cannot find a way of making a text parameter NULL by default. This worked fine with Report Builder 3.0 on SQL Server 2008. But in SQL 2012 the functionality has changed and NULL is unchecked by default at runtime.

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Reporting Services

Windows Server 2008 (all editions)

English

1. Create a new blank Report in Report Builder v3.0 (SQL 2012)
2. Add a Parameter called "test". Data Type "Text", "Allow Null Value" (only) checked and "Visible" selected.
3. Set the Available Values to "None"
4. Set the Default Value to "Specify Values", then click Add which will create a default of "(Null)"
5. Click OK
6. Run the report

Result in Report Builder = the Parameter's NULL Checkbox is checked by default
Result in IE and Firefox = the Parameter's NULL Checkbox is unchecked by default

The Parameter's NULL Checkbox should always be checked by default when the report opens (and before it runs).

X64

0 attachments

Microsoft