[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Parameter missing a value (SQL RS)

Posted on 2007-10-02
15
Medium Priority
?
2,342 Views
Last Modified: 2013-11-26
Hi All,
Using VS 2005 and SQL Server RS 2005.
I have a report that includes an action event on a chart to "Jump to Report".   The report I am jumping to, takes several parameters.  All but one of these parameters are passed from the original report.  One parameter is a multi value param populated from a dataset.  In preview/debug mode, everything works fine. I click the link, the new report loads and prompts for a selection for the last parameter.  After I publish the reports and try the link, the report begins to load then errors with "MyParameter is missing a value"  It never prompts me to select it. I have tried moving the parameter up and down in the parameters list, but nothing seems to resolve this.

regards,
BIll
0
Comment
Question by:woyler
  • 8
  • 7
15 Comments
 
LVL 18

Expert Comment

by:PFrog
ID: 19998688
Do you have any datasets populating the available values of any parameters?
Even if you are specifying all parameters, if they are not in the available list, then you will get this error.

As a test, make all parameters visible, and you should see which one is empty.
0
 

Author Comment

by:woyler
ID: 19998790
Report1 takes 5 parameters. After those parameters are selected, the report is rendered. There is a link to Jump to Report on Report1.  When this is clicked, all parameters from Report1 are passed to Report2. Report2 has 6 parameters. The first 5 are the parameters passed from Report1.  The sixth is a multi select parameter populated from a dataset.  As I said, this works flawlessly in preview mode.  Once deployed, I get the error that parameter1 is missing a value when I click the link and report 2 begins to render. I do not even get as far as having it display to me the combo box to selet the last parameter.
The error occurs on whatever parameter is listed first in the list.
0
 
LVL 18

Expert Comment

by:PFrog
ID: 19998812
So what are your 'Available Values' set to for Parameter1?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 18

Expert Comment

by:PFrog
ID: 19998850
And is your deployed server pointing to the same database as your BIDS environment?

Also, you should delete all the reports from the server and redeploy - to make sure there are no parameter settings configured on the server causing problems
0
 

Author Comment

by:woyler
ID: 19998884
Sorry, I am not exactly sure what you are refering to here. Parameter1 on report1 is a static hidden parameter with a default value.
Parameter1 on report 2 is the same name as on report one and is passed in the parameters list from report1.
0
 

Author Comment

by:woyler
ID: 19998891
The database is exactly the same. I have gone as far as deleteing the entire folder structure and redeploying.
0
 
LVL 18

Expert Comment

by:PFrog
ID: 19998974
When you look at your list of parameters in the BIDS development environment, there are three sections for each parameter: Properties, Available Values and Default Value
What is set in the Available Values section of the first parameter? It can either be "Non-Queried" or "From Query". Which one does it use, and what are the values or dataset being used?
0
 

Author Comment

by:woyler
ID: 19999032
The first parameter is a hidden parameter , non-queried, with a default value
0
 
LVL 18

Expert Comment

by:PFrog
ID: 19999055
Make all the parameters visible, and let me know what happens then
0
 

Author Comment

by:woyler
ID: 19999312
I get the error parameter is missing a value. BUT, the error is occuring on the 6th parameter(the only one not passed from Report1) This is the parameter that is a multi value populated from a dataset.
If I give it a default value "From Query" ans specify the same dataset, the report works. If I try no default value so I can select a value from the dropdown, I get the parameter missing a value error.
0
 
LVL 18

Expert Comment

by:PFrog
ID: 19999373
If you launch Report 2 directly (not via report 1) does it prompt for parameter 6 correctly?
0
 

Author Comment

by:woyler
ID: 19999496
Yes, it does.
0
 
LVL 18

Expert Comment

by:PFrog
ID: 19999638
Thought so - unfortunately this is one of those sightly irritating things SSRS does.If you link to a report, or include a sub-report, it will not prompt for parameters, they all have to be specified or have defaults.

We know from the last test that the problem is nothing to do with your report as it orks standalone.

One way (and the only way that I know of) around this is to call your Report2 from a URL not a direct report link. i.e.change the navigation from Report 1 to
      http://[server]/ReportServer?/Report2
The problem with this is specifying your other Parameters (1 to 5). You can do this by building up the URL string
      http://[server]/ReportServer?/Report2&param1=xxx&param2=yyy&param3=zzz
Careful though, the parameters are case sensitive...

0
 

Author Comment

by:woyler
ID: 19999679
But why would it work in the preview?
0
 
LVL 18

Accepted Solution

by:
PFrog earned 1500 total points
ID: 19999697
Because there are a lot of differences between how BIDS serves the reports and how report server does it - just one of those things I'm afraid!

Like Javascript - report server works but BIDS preview doesn't
 or overlapping controls, BIDS is ok, reportserver isn't
etc.etc.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 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