In sql service reports

[member27]

Hi all, Iam usind sql service reporting tool for generating reports .. I did some samples in that..I cant undstand the non query and from query options in report parameters tab..please cn any one explain abt tat.. non query option swe can give values which will come in combo box options and we can select any one and generate reports ..how can we make use of from query option..can anyone expalin with example

[Paddy Boyd]

From query is simple enough, you just assign a DataSet from the report as the source of the items in the dropdown. Much like populating a dropdown in any UI.

[member27]

thnx for ur reply.. I have fileds id,name in table1 I have my Query string = select * from table1 where id=@pid in the parameters (pid)properties I assigned the value field and labelfield as id and also in defalult values of from query i gave the label field as id but some error is there Error 2 [rsInvalidReportParameterDependency] The report parameter ‘code1’ has a DefaultValue or a ValidValue that depends on the report parameter “code1”. Forward dependencies are not valid. can u tell me wat error i did?