Merge cells in Sparx System for dynamically generated rows

[monicashishodia]

I am new to enterprise architect. I am trying to fetch data in a fragment using SQL custom query.The data should come in form of a table which is happening. But the data is in Root-->Child format as below

Col1 Col2 Text For Col1 Text for Col2 Text for Col1 Text for Col2 I want to merge these cells in col1 and display single entry for root data and was able to do it through SQL and now the output is Col1 Col2 Text For Col1 Text for Col2 Text for Col2 But now i have another problem. As it is appearing as part of a table, those empty rows in col1 are appearing as empty rows in table(white empty boxes with black border. I am not able to show here due to lack of formatting). I want to merge these empty cell in form of one. For static data it is happening but in dynamic cols which are generating through SQL on run time, i am not able to achieve this. Please suggest a way out. Regards, Monica

[Eve]

I don't think there's any way to do that.

[monicashishodia]

Hi Simon

Thanks for reply.

Can we achieve this by some other mean?
I could not find a direct way to fetch this data from model as data is coming from different packages.
If i dont use SQL to populate data then can we use Jscript to do the same. I apologize if i have suggested something out of context as my knoweldge of EA is very limited.

Regards,
Monica