Parameter missing a value (SQL RS)

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
woylerAsked:
Who is Participating?
 
PFrogCommented:
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
 
PFrogCommented:
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
 
woylerAuthor Commented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
PFrogCommented:
So what are your 'Available Values' set to for Parameter1?
0
 
PFrogCommented:
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
 
woylerAuthor Commented:
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
 
woylerAuthor Commented:
The database is exactly the same. I have gone as far as deleteing the entire folder structure and redeploying.
0
 
PFrogCommented:
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
 
woylerAuthor Commented:
The first parameter is a hidden parameter , non-queried, with a default value
0
 
PFrogCommented:
Make all the parameters visible, and let me know what happens then
0
 
woylerAuthor Commented:
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
 
PFrogCommented:
If you launch Report 2 directly (not via report 1) does it prompt for parameter 6 correctly?
0
 
woylerAuthor Commented:
Yes, it does.
0
 
PFrogCommented:
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
 
woylerAuthor Commented:
But why would it work in the preview?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.