Wednesday, 15 June 2011

visual studio 2010 - Parent and Child report in RDLC -


I want to create a report (.rrdlc) in Visual Studio 2010. The report should initially show a parent record when the user clicks the detailed button to load the child record in the same report.

My employee records are shown as parent records and when the user is expanding, the expansion report should be shown with a list of projects that the employee has worked.

I tried with sub reports, but it initially showed parents records and when I select any record, it shows the details of the details in another report but I want to That both parents and children records are shown in the same report. There is no group between parent and child records. The employee ID is the mailing column.

Thanks, light.

The easiest way to do anything in the RDLC report is to list You can also load data from multiple tables, as long as you create a group on a column, which is the same (FK) in the data-sources.

You can group this list on staff and add text boxes to the data that you want to display. Inside the same rectangle you can add a new list and you can group it on projects, inside this second rectangle, you can add a table, matrix, or add another group to another list.

You can find a good tutorial option 2 recommended, which I tried to describe in words and option 1 is probably trying to use sub-reports.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)