<p>Hi,</p>
<p>i have requirement of split the comma separated column data to separate rows in BIRT.i am using oracle DB.my select query returns multiple columns out of few columns data has "," .(eg: A,B,C,D)</p>
<p>want to display in a report </p>
<p> </p>
<p>ID</p>
<p>Name</p>
<p>Subject</p>
<p>marks</p>
<p>1</p>
<p>Abc</p>
<p>Science,Maths,English</p>
<p>50,70</p>
<p>2</p>
<p>Def</p>
<p>English,French,Social</p>
<p>90,80,69,99</p>
<p> </p>
<p>Output should be like:</p>
<p>ID</p>
<p>Name</p>
<p>Subject</p>
<p>marks</p>
<p>1</p>
<p>Abc</p>
<p>Science</p>
<p>50</p>
<p> </p>
<p> </p>
<p>Maths</p>
<p>70</p>
<p> </p>
<p> </p>
<p>English</p>
<p> </p>
<p>2</p>
<p>Def</p>
<p>English</p>
<p>90</p>
<p> </p>
<p> </p>
<p>French</p>
<p>80</p>
<p> </p>
<p> </p>
<p>Social</p>
<p>69</p>
<p> </p>
<p> </p>
<p> </p>
<p>99</p>
<p> </p>
<p>i replaced the "," with <br> and displayed in text box. When i preview in viewer works fine. But when i export to PDF format the data is truncated and shows only text box size in report.</p>
<p>please advise me.</p>
<p> </p>
