I have built a simple report with one group, where the data output looks something like this:
I need to change the format (preferably into a table) where the first line of the detail is on the same line as the group. I need to do this because most of the time, there will only be one detail line per group. So it should look more like this:
My existing group and detail insist on being on different lines. I suspect the way to do it has to do with adjacent left or right groups in a table, but I can't figure out how to make it work.
C1 C2 C3 C4
AAA Blue
5 10
6 20
AAA Yellow
2 10
BBB Green
3 20
I need to change the format (preferably into a table) where the first line of the detail is on the same line as the group. I need to do this because most of the time, there will only be one detail line per group. So it should look more like this:
C1 C2 C3 C4
AAA Blue 5 10
6 20
AAA Yellow 2 10
BBB Green 3 20
My existing group and detail insist on being on different lines. I suspect the way to do it has to do with adjacent left or right groups in a table, but I can't figure out how to make it work.