Hello,
I have a table like this:
patid diag fee
----------------------
1 A 10
2 B 15
2 A 10
3 C 20
3 A 10
3 D 25
4 B 15
And i want my report to look like this:
ID Diag and Fee Total
----------------------------------------
1 A 10
10
----------------------------------------
2 B A 25
15 10
----------------------------------------
3 C A D 55
20 10 25
----------------------------------------
4 B 15
15
----------------------------------------
I'm grouping by patid but i still can't figure it out how to display horizontally the members of a group. A patid can have multiple diag, each diag having a corresponding fee.
Thanks,
Bobby
I have a table like this:
patid diag fee
----------------------
1 A 10
2 B 15
2 A 10
3 C 20
3 A 10
3 D 25
4 B 15
And i want my report to look like this:
ID Diag and Fee Total
----------------------------------------
1 A 10
10
----------------------------------------
2 B A 25
15 10
----------------------------------------
3 C A D 55
20 10 25
----------------------------------------
4 B 15
15
----------------------------------------
I'm grouping by patid but i still can't figure it out how to display horizontally the members of a group. A patid can have multiple diag, each diag having a corresponding fee.
Thanks,
Bobby