I have a Report that looks like this:

Department Number of Employees
MKT 58 Details...

And i have a subreport displaying the info of the employees for a given
department.. i want if its possible, that the user clicks on Details.. and
the subreport appears but i have no idea how to do this.. any sugestions.. im
new at Rs, and im desperate..

Details is a textbox. In designer you should go to props of this text box
and setup a drillthru action that is basically a pointer to a drillthru
report with report parameter values.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Although you can hid and show sections you would still most likely end up
with the subreport running for every single row. RS has two concepts that
you should read up on. Drill down and drill through. When somebody wants
detail for a particular row of data drill through works great. You setup a
link (I just take one of the fields (or add an additional one that says
something like Details ... ), I make it blue and underlince, then right
mouse click, properties, advanced properties, navigation, jump to report.
You jump to the report passing it the parameters based on the row you are
on. Works great and is very intuitive, my users love it.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]