Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

parameter is missing a value

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
Eric Douglas
Asked:
Eric Douglas
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
Eric DouglasAuthor Commented:
Also;   The two parameters are the only objects used.    There are not datasets, data sources, images, or bullt-in fields used.
0
 
Eric DouglasAuthor Commented:
Icohan,  THANK YOU for the quick response.   A very simple solution ... it worked great!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now