Parameter missing a value (SQL RS)
Posted on 2007-10-02
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.