<p>Hi,</p>
<p> </p>
<p>I'm trying to create a nested table inside CrossTab detail cell which parameters will be crosstab column and row dimension like this</p>
<p> </p>
<p>ItemID--TagId = 1
TagId = 2
TagId = 3</p>
<p>
</p>
<p>1 -- table Tag --table Tag --table Tag</p>
<p> -- values of --values of --values of</p>
<p> -- itemId 1 --itemId 1 --itemId 1</p>
<p> --and tagId 1 --and tagId 2 --and tagId 2</p>
<p>
</p>
<p>2 -- table Tag --table Tag --table Tag</p>
<p> -- values of --values of --values of</p>
<p> -- itemId 3 --itemId 3 --itemId 3</p>
<p> --and tagId 1 --and tagId 2 --and tagId 2</p>
<p> </p>
<p>Original table from database query looks like this:</p>
<p>Id -- TagId -- TagValue -- ItemID</p>
<p>1 -- 1 -- value1 -- 1</p>
<p>2 -- 1 -- value2 -- 1</p>
<p>3 -- 2 -- **** -- 2</p>
<p>4 -- 2 -- yyy -- 2</p>
<p>5 -- 3 -- 1234 -- 2</p>
<p>6 -- 3 -- 225 -- 1</p>
<p> </p>
<p>I have tried with the instructions at here:</p>
<p><a data-ipb='nomediaparse' href='
http://digiassn.blogspot.com/2010/08/birt-all-about-crosstabs.html'>http://digiassn.blogspot.com/2010/08/birt-all-about-crosstabs.html</a></p>
<p>but no success.</p>
<p>Please help me or guide me to the right thread.</p>
<p> </p>
<p>Thanks in advanced</p>
<p>Tam Nguyen Minh</p>
<p> </p>