Hi friends,

Can anyone help me in passing parameter value to report using c#.

User selects the values from the listbox, so i need to pass the array of values of docid to the report.

my query is:

select dr.todocumentid, d.description, d.documentkey, dr.fromdocumentid, d1.description, d1.documentkey from (select document_documentid, fromdocumentid,todocumentid from document_document where todocumentid in (" + @docid + ") union select document_documentid ,todocumentid , fromdocumentid from document_document where fromdocumentid in (" + @docid + ")) dr inner join document as d on dr.todocumentid = d.documentid inner join document d1 on d1.documentid = dr.fromdocumentid order by dr.todocumentid

Thanks.