sending Parameters in reportings

Question

hai 2 all

i have created 2 reports in ssrs .

1st report is select * from Categories
fileds

categoryid ----categoryname ---categorydiscrption

2nd report is select * from products where fkey_Categoriesid=Categryid

now my question is
how to pass the perameters from one report to another and how to use that perameters

..................................................................

if we onclick at categoryname..then in the subreport the related products of that category hav to display..how to do that.?

shashi reddy · Answer

okay mine 1st category-report is select * from categorys 2nd products-report is select * from products where categoryid=@categoryid from 1st category-report i am sending perameter to products-report 2 reports are completed now...in category-report i wanna show category report (has well as products-report)and on selecting the categoryfield in category-report..the sub report shld be an products-report

Raja Krishnamurthy · Answer

Hi Shashi, That link has clear cut instructions on how to create sub-reports. Please let me know what you didn't understand for me to further assist you. Regards, Raja

shashi reddy · Answer

hai raja already i saw that site..but idnt understood that one

Raja Krishnamurthy · Answer

Check out the link given below: http://msdn.microsoft.com/en-us/library/ms160348.aspx HTH. Happy Programming!!! Regards, Raja

sending Parameters in reportings

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)