I have a matrix and I've dropped in a subreport with two columns. I would like to put the column headings of the subreport in the same row as the column heading row of the main report. The following is a sample of the output that I am trying to create. The "Plan" and the "Balance" columns come from the subreport. Employee Plan Balance Pay Code Hours Taken Annual Tom Sick Plan 50 Regular Hours 2080 Vacation Plan 75 Sick Hours 35 Vacation Hours 85 Jim Sick Plan 40 Regular Hours 2090 Vacation Plan 30 Personal Plan 24 Al Sick Plan 42 Regular Hours 2030 Vacation Plan 60 Sick Hours 40 Vacation Hours 25 The following shows a fragment of the design view of the report as I currently have it. I've put the "Plan" and the "Balance" columns headers of the subreport in the main report column headers row, but only by putting spaces between the words "Plan" and "Balance". Obviously, I would like to have them appear in two separate cells. Ideally, there would be a "Split Cell" option, but I couldn't find one. I also tried adding a column, and then merging the cells at the subreport level, but that merged the entire column and got rid of the cell that I put the "Balance" label in. I also tried putting a one record table with two columns in the cell but that caused Visual Studio to crash. Employee Plan Balance Pay Code Hours Taken Annual [Employee] SubReport [PayCode] [Hours] I'm sure I'm just missing something simple so any help is appreciated. Thanks, PaulPaul Taylor

Hi Paul Taylor, Subreport can only display its content in the textbox you layed, so you cannot put the column headings of the subreport in the same row as the column heading row of the main report. This is by design. To work around the issue, there are two methods: 1. You can join two different datasets into one, then design one report to cover all the information you need rather than two different report. 2. Inside the parent group, add two columns, then you will have to two different column header, type in Plan and Balance into these two different column headers separately, then merge the two textboxes of detail row under the colunn headers, after that put the subreport into this merged textbox. Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I'm not sure how to combine the two different datasets into one so I tried option 2. Unfortunately, this did not work because I don't have a parent group, I just have a recursive parent. I can add a column and type in the column header labels, but then when I merge the detail row, it deletes one of the columns. What I ended up doing instead was creating a separate 1 record subreport that contained two text boxes that have the column headers on them and this seemed to work. Thanks for your assistance. PaulPaul Taylor