I am familiar with the concept of master detail tables and I have something I'm trying to do that seems so easy, but I can't find a way to do it.
I've gone through this suggestion: http://www.codeproject.com/Articles/270924/Master-Details-Report-in-SSRS-2008 which allows you to create two data sets and use an action on the column. The problem with mine is, when I click on the column, the report get's refreshed and asks you for the original date parameter, it never populates the id I need to show the second table.
All I'm trying to do is display rows from table1 that have a key that is located as an FK in table2. I figured I would chose the cell that my id is being displayed in, right click for textbox properties, go to Action, pick Go to Report, pick the report I'm in, and add the parameters I need for the second table.
Like I mentioned though, when I click on the link, the page refreshes and I have to enter my original parameter for a date. Is there a way to send the id to the second table on the report and have it display? The dataset for the second table is waiting for the parameter, and I set the default of the id param to -1 so it doesn't fail.