Solved

SSRS report parameter not defaulting to default value on test environment

Posted on 2011-09-13
2
243 Views
Last Modified: 2012-05-12
I have a rdl that I created, with a parameter. I want the parameter to default to a specific value. I have added the following code to my rdl:

<DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>

It defaults to the correct value on my development machine, but when I try and test it on my test environment, it does not default to the correct value.
0
Comment
Question by:jjliu4492
2 Comments
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 500 total points
ID: 36534244
Set the below values along with Default for the <ReportParameter>.

<DataType>Datatype</DataType>
<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>


0
 

Author Comment

by:jjliu4492
ID: 36536221
I added

<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>

to my <ReportParameter>, but it is still defaulting to "Select a Value" on my test environment.

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How do ASP.NET and MVC work together? 4 25
check the deletion of SQL job on who delete/disable it 12 26
Angular JS Route 3 45
Entity Framework 7 28
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now