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