Solved

parameter is missing a value

Posted on 2014-10-14
3
196 Views
Last Modified: 2014-10-14
using ReportBuilder 3, I have set up a small test whose solution may then be applied to a larger project.    The report has two parameters;
@ReportNumber;   data type is integer (no checkboxes are checked and it is visible).    
                                  Available values are;     Label                                   Value
                                                                           Report 1                                 1
                                                                           Report 2                                 2
                                                                           Report 3                                 3
                                  Default Value = 1

@ReportTitle:          data type is text ( i have tried all combinations of checkboxes, except 'Allow multiple values, which is always unchecked)
                                  visibility (have tried both Hidden and Internal)
                                  Available Values - (have tried several variations including literal text in the value field "Report Number")
                                                   In the final solution, it will be a a switch statement that will assign a ReportTitle depending upon the @ReportNumber selected.
                                  Default Value - "Default Value"  (for testing purposes)


Every configuration results in "The 'ReportTitle' parameter is missing a value".    

Any help would be much appreciated.

Eric
0
Comment
Question by:Eric Douglas
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 40380164
So if you want your @ReportTitle default value to be filled from the @ReportNumber you will need that "Default Value" to be something like =Parameters!ReportNumber.Label

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0f075d9b-52f5-4a92-8570-43bbdaf2b2b1/change-report-title-in-ssrs-2008-dynamically
0
 

Author Comment

by:Eric Douglas
ID: 40380324
Also;   The two parameters are the only objects used.    There are not datasets, data sources, images, or bullt-in fields used.
0
 

Author Closing Comment

by:Eric Douglas
ID: 40380691
Icohan,  THANK YOU for the quick response.   A very simple solution ... it worked great!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

920 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

18 Experts available now in Live!

Get 1:1 Help Now