I have a report in SS reporting services 2005 and a subreport.
The main report has ID column which I want to make it clickable and when it is clicked I want to show that ID's record in the subreport.
How can I do this?
The main reports has lots of records and the record has note field but it is really hard to include that note section in nice table format.
So only when that record has been clicked on, the note of that record shows up in the subreport.
Is this doable?