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.?
Loading
shashi reddyPosted Mar 16, 2011, 11:33 AM
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 KrishnamurthyPosted Mar 16, 2011, 8:21 AM
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 reddyPosted Mar 16, 2011, 8:15 AM
already i saw that site..but idnt understood that one
Raja KrishnamurthyPosted Mar 16, 2011, 7:12 AM
http://msdn.microsoft.com/en-us/library/ms160348.aspx
HTH.
Happy Programming!!!
Regards,
Raja