On demand Subreports

Is it possible to create a subreport, that will show after i clicked a certain value in the main report.
for insance:
Customer sales
Microsoft 200k
Oracle 100k
Clicking on the customer microsoft should start the subreport (on demand for proformance) where all sales details are in.
Please let me know, thanks in advanceYou might want to look into drillthrough reports.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_interactive_v1_38tn.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6wa3.asp
Also check out the samples - the Territory Sales report uses drillthrough:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_5u7n.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"M.a.t" <M.a.t@.discussions.microsoft.com> wrote in message
news:6D59E6F9-9EA7-4C7A-9318-B7A30838E3D9@.microsoft.com...
> Is it possible to create a subreport, that will show after i clicked a
certain value in the main report.
> for insance:
> Customer sales
> Microsoft 200k
> Oracle 100k
> Clicking on the customer microsoft should start the subreport (on demand
for proformance) where all sales details are in.
> Please let me know, thanks in advance