Solved

parameter is missing a value

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

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

828 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