Solved

parameter is missing a value

Posted on 2014-10-14
3
194 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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