all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Displaying the available values for a parameter from the database


Displaying the available values for a parameter from the database pmud
8/17/2005 2:28:03 PM
sql server reporting services:
hI,


My report has 4 report parameters: @manufacturer , @brand, @Start Date,
@EndDate .

I want the @manufacturer , @brand to hsow the drop down list with distinct
values from the db. Now when in these 2 report parameters I do , Available
Values as Non Queried and the Value and lable as manufacturer , i get the
following errors:

"The report parameter ‘manucode’ has a DefaultValue or a ValidValue that
depends on the report parameter “manucode”. Forward dependencies are not
valid."

"The report parameter ‘manucode’ has a DefaultValue or a ValidValue that
depends on the report parameter “StartDate”. Forward dependencies are not
valid."

"The report parameter ‘manucode’ has a DefaultValue or a ValidValue that
depends on the report parameter “EndDate”. Forward dependencies are not
valid."

Please help.

Thanks

--
RE: Displaying the available values for a parameter from the database pmud
8/17/2005 3:36:04 PM
Hi,

I found the solution to that. I created 2 datasets: one for desplaying the
manufacture and one for displaying brand. Then in Report parameters Available
Values" I put these new datasets respectively for brand and manucode and
chose the value and label. :)
--
pmud


[quoted text, click to view]
AddThis Social Bookmark Button