469,579 Members | 1,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

SQL RS Report Parameter multivalue failing

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
1 3946
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.

Similar topics

11 posts views Thread by Rolf Barbakken | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by amith.srinivas | last post: by
reply views Thread by kamboj.shalabh | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.