Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

parameter is missing a value

Posted on 2014-10-14
3
Medium Priority
?
225 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 2000 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

916 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