how to merge two row column cells

Hi,

i need to show in report like need to merge two row cells as single cell when two cells having the same dublicate value and that value need to show in the middle of two cells.i have attached report for your review.

Thanks!!!
Sowjanya Chanumolu

Find more posts tagged with

Comments

For Birt

Hi,
how to remove dublicate row cells and need to show cell value in the middle,i have attached report for your reference.

Thanks!!
Sowjnaya CH.

mwilliams

Hmm. I'm not sure that that'll be easy to do, if at all. Any way you can set up a report with some sample data in a flat file or scripted dataSource that I can run and do some testing on?

For Birt

Hi mwilliams,
i am working on the same requirement from last two weeks,i have attached all the required files for your review,
i have rounded dublicate columns with blue line and i need to show as single value in the middle of two cells.

Thanks!!
Sowjanya ch.

For Birt

Hi,
i have a requirement like need to avoid dublicate values and show single value for 2 row cells.
i have attache report for your reveiw.i have round up dublicate values with blue line.nedd to show that as single value in middle of two row cells.
i have used table groups concept.
please give me solution for this as i am working for this from last 4 weeks.

Thanks in advance.
Sowjanya CH.

mwilliams

Is it just a coincidence to this example, or can you remove the "Dose Reduction" group and move it to the "AcqMod" group level, since the Dose Reduction is always the same across the AcqMod group? Let me know. I'll keep working on the other column.

mwilliams

This isn't 100% correct yet, but maybe it'll help get you towards a solution. What I did was embed tables for the other fields that are right of the detail field, rather than just using grouping. Obviously, if you look closely, the order isn't completely right. You'll have to play around with the grouping expressions on the inner tables to get them to work, if, in fact, this will even work 100%. Another thing you'd have to play with is the borders. Hope this helps you out some! If I think of something better, I'll let you know. If you get this working how you're wanting, please post back the design. Thanks!

For Birt

Hi,
Thanks for your help.
this is not working for FOV column,how can we increse cell space i did but it's not working.
i have attached report for your review.
u used filter condition for every inner table like row[protocol]+row[auqmod] = row.outer[protocol]+row.outer[auqmod] what is the use of this.

Thanks!
Sowjanya

mwilliams

The inner tables are all bound separately to the dataSet, so if you don't include the filter that filters them by both of the outer table's groups, they will return data they shouldn't. I know that what I returned was not working 100%. There is still some work to be done. I just thought what I sent could get you started towards figuring out which groupings needed to be what to make it work. I don't know your dependencies across the table. What columns need to be the same for the columns on the right to merge and which ones do you just want all like values within a section to merge? Is the image you attached taken using the design I sent, with different data? Or what is it?

For Birt

Hi,
Thanks you for taking me to take ahead for solution...

i have used another data...
it's working for detail level column but it's not working for FOV column...
i have attached all required files for your reviwe..
please find and try to give me the solution...
and the values in the FPS column are crossing the cell, is it possible to increse the space..i traied but it's not working...
i have rounded with red circuler wich is not working and rounde with blue line wich is working....
Thanks!
Sowjanya.

mwilliams

I don't see the same issue. The only place I saw this happen was with misspellings like "Normal" and "Noramal".

For Birt

Hi,

the values in the cell are comming out,how to increse the cell width..
i did some dragging border lines it's not working hear.
i have attached report for your reference..Please help me hear.

Thanks!
Sowjanya

mwilliams

You'll just have to increase the default row height. Because of the use of sub tables, I had to make the rows fixed height so they lined up. You'll have to play with this and see if you can find a static value that works or if you need to try to set the height dynamically in script.