Subreport on main report
I have one raw dataset and then a generic dataset .I also have 3 report files or 3 rdlc files which all uses the same generic dataset. So let my bill the hierachy. Level1_Report Level2_Report Level3_Report I want to embed Level2_Report on or in the Level1_Report and drill down using a toggle or hyperlink to go to Level2_report. Keep in mind again they all uses the generic dataset. I do a merge from the raw dataset to the generic dataset Can someone walk me through how to embed the subreport into level1Report. This may fix my problem of why subreport eventhandler is not firing because its not getting the data.
November 25th, 2010 3:22am

Hi pianoboyCoder, If I understand correctly, you have merged the datasets into one dataset. Now, you want to embed the subreport into the main report directly. If so, we can add a tablix control into a TextBox in the Level1_Report, in the new tablix control, show the data from the Level2_Report. We can use Filter to filter data in the new tablix control. This will allow us to embed the subreports into the main report. However, I would suggest you still using Subreport control to show the subreport. This may increase the performance. For the issue "This may fix my problem of why subreport eventhandler is not firing because its not getting the data" you met, I would suggest you add some testing data to check if it works. For more information about Filter, please see: Filter Equation Examples (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/cc627464.aspx If you have any more questions, please feel free free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 2:18am

When you say tablix control you mean add table which includes a header row, detail row, and a footer row
November 30th, 2010 5:18pm

http://prologika.com/CS/blogs/blog/archive/2007/08/12/tablix-the-crown-jewel.aspxkk
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 5:28pm

Using visual 2010 c# how do you create a tablix control, I know when you first creating the report it's defaulted to a matrix. can you show pictures using visual studio 2010 how to create tablix control etc.......
December 1st, 2010 4:29pm

Hi, In Visual Studio 2010, please use Table control. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2010 4:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics