By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,536 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

SQL RS Report Parameter multivalue failing

P: n/a
Ben
NooB: Anyone help with what I could be doing incorrectly here? Trying to
have a parameter drop down list where a user can select one or more of the
available values contained in the table to filter out results. Have a
single table with five values. Keep getting the following error....

Table name is Name

Field is NickName

Parameter name is "Nick", datatype string, prompt "Select NickNames",
multivalue "on", available values "From Query", dataset points to ODBC SQL
connection, value field is NickName, Label Field is NickName, default values
null

select statement reads: select * from name where (NickName in (@Nick))

ERROR MESSAGE WHEN PREVIEW: [rsInvalidReportParameterDependency] The report
parameter 'Nick' has a DefaultValue or a ValidValue that depends on the
report parameter "Nick". Forward dependencies are not valid.

Any clue?
Jun 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Jun 10, 10:54 pm, "Ben" <nos...@thankyou.comwrote:
NooB: Anyone help with what I could be doing incorrectly here? Trying to
have a parameter drop down list where a user can select one or more of the
available values contained in the table to filter out results. Have a
single table with five values. Keep getting the following error....

Table name is Name

Field is NickName

Parameter name is "Nick", datatype string, prompt "Select NickNames",
multivalue "on", available values "From Query", dataset points to ODBC SQL
connection, value field is NickName, Label Field is NickName, default values
null

select statement reads: select * from name where (NickName in (@Nick))

ERROR MESSAGE WHEN PREVIEW: [rsInvalidReportParameterDependency] The report
parameter 'Nick' has a DefaultValue or a ValidValue that depends on the
report parameter "Nick". Forward dependencies are not valid.

Any clue?
Bob, I think you can't use parameter with IN clause. To test, change
to 'where NickName = @Nick'

Jun 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.