I have several related tables (using inner and outer joins from Framework manager) that poulates a list in a report (report studio) that shows empty columns. First row on new id includes all values but the remaining is empty (look at example below)
tb1 is the main table.
tb1 -> tb2 (1-n)
tb2 -> tb3 (1-n)
tb1 -> tb4 (0-n)
How can I make so that these empty columns get the same values as the first row on a new id.
Current output:
tb1.id tb1.col1 tb2.col2 tb3.col3 tb4.col4
1 val1 val2 val3 val4
1 val5
1 val6
1 val7
2 val10 val21 val31 val40
2 val11 val22 val32
2 val12 val23 val33
2 val13 val24 val34
Expected output:
tb1.id tb1.col1 tb2.col2 tb3.col3 tb4.col4
1 val1 val2 val3 val4
1 val1 val2 val3 val5
1 val1 val2 val3 val6
1 val1 val2 val3 val7
2 val10 val21 val31 val40
2 val11 val22 val32 val40
2 val12 val23 val33 val40
2 val13 val24 val34 val40
Isn't this the exact same question you posted here:
http://www.cognoise.com/index.php/topic,24724.0.html
MF.
Yes, but the other post did not describe my problem very well, the other should be deleted.