?
Solved

SSRS report parameter not defaulting to default value on test environment

Posted on 2011-09-13
2
Medium Priority
?
259 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 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline

830 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