If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Set value in column

Started by maevr, 08 May 2014 02:20:52 AM

Previous topic - Next topic

maevr

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

MFGF

Meep!

maevr

Yes, but the other post did not describe my problem very well, the other should be deleted.