?
Solved

SSRS report parameter not defaulting to default value on test environment

Posted on 2011-09-13
2
Medium Priority
?
256 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 2000 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

A new era in Cloud training has arrived.

A day that will go down in Cloud history.. But are you ready for it? Will you accept this Cloud challenge?

Question has a verified solution.

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

In this article I will describe the Detach & Attach 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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 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