Default Null Parameter

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi,

I'm using the SSRS 2012 native mode report builder. I'm adding text parameters. I'm allowing null values and assigning a default null value.

But when I run the report, the null tick boxes are not checked. I have to tick all the null checkboxes to get the report to run with its default values.

This is having a knock on effect as report subscriptions created before the report was modified with an additional parameter are failing.

Is there a bug or a problem with default nulls in SSRS 2012?

Kind Regards,

Steve

Posted 11-Sep-12 21:46pm

Stephen Hewison

Add a Solution

Comments

JasonMacD 15-Apr-13 14:25pm

That worked like a charm, great find on this. I was looking for hours for a solution, not much info out there in regards to this issue in reports.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stephen Hewison · Accepted Answer · 2012-09-17T06:22:00

Solution 1

There was something wrong with the report definition. It wasn't updating the parameter definitions to use the default values.

After deleting the report from the server and republishing it, the default values were applied.

Posted 17-Sep-12 6:22am

Stephen Hewison

Comments

Maciej Los 17-Sep-12 13:29pm

+5!

Stephen Hewison 25-Sep-12 6:41am

In addition, you need to be aware, when you delete the report, you will delete any subscriptions and other data in the report server which relates to that report. If you have a lot of report subscriptions I'd suggest publishing the report new, under a different name. Then copying the data in the Catalog table from the new report to the old report.