How to set the following report Parameters?

Hi,

I have a report and the parameters Passed to the report are Cusip and PeriodId through a stored Procedure.

i want to populate the cusip Parameters using a dataset thats got by a sproc called usp_getCusips.

and the PerioId using a dataset thats been got by another sproc called usp_Getperiods...

So in my report i have added 3 datasets one for the main report, one to get the values of the PeriodId and other to get the value of the cusip.

So in my Report parameters for the Parameter Cusip and i have checked the Available value option and selected its corresponding Dataset and value .

and i have also done the same thing for the PeriodId.. But when i run my sproc i am getting this Error.

[rsInvalidReportParameterDependency] The report parameter ‘Cusip’ has a DefaultValue or a ValidValue that depends on the report parameter “Cusip”. Forward dependencies are not valid.

[rsInvalidReportParameterDependency] The report parameter ‘PeriodId’ has a DefaultValue or a ValidValue that depends on the report parameter “PeriodId”. Forward dependencies are not valid.

Any Help will be appreciated.

Regards,

Karen

I'm not sure how to directly answer your question, but it sounds like you have created a circular reference.

See the following thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184243&SiteID=1

|||

Greg,

Thanks for the help, i got it to work.

Regards

Karen

|||Glad I could help.