How to make a table with merge cells in column

Adrian_XE4

Hi all,
Please help me with a *fr3 example who can make a table like this. I mean, I want to learn, how to merge cells in column 1 and column 2 in this way?

gpi

Try to use TfrxDBCrossView

Adrian_XE4

Thanks Gp1 for your answer, but I can't see the TfrxDBCrossView component in my FastReport 4.0 menu.
May be because I have Fast Report Embarcadero Edition?

There is another way to do this kind of report?

Thank you!

technisoft

I think you have to make a single query, combining the 3 separate ones, suitably ordered, and then use group bands etc.

Adrian_XE4

Thank you Technisoft for you answer.

I've already tried this. The problem is that group bands are not the same horizontal line.

I mean, Cell_1_1 in Group 1 on higher line than Cell_1_2 line in group 2 and column 2. It should be on the same line with Cell_1_1.
Also, the rest Cell_1_1, Cell_1_2, Cell_1_3 should be on the same line.

Moreover, if Cell_1_2 and Cell_2_2 are subgroup of Cell_1_1, then the base line of Cell_1_2, not be under Cell_1_1. Only a Cell_2_2 baseline should be under Cell_1_1.
I do not know if I explained clearly.

How can I do this?

So right now, I have one ADOQuery with all records of 3 tables.

What kind of bans should I use and what settings for these bands should have exactly?

Thank you very much.

technisoft

You might be able to make a subreport for each query and place them side by side on a band. I have no idea whether that would work.
If everything fails I'd make a temporary table which reflects the column and row structure.
For your example the table would have 12 rows, 4 columns
For column 1 only row 1, 4, 9 and 10 would hold data. It may need some work to get the border lines as per your example.

Mahaveer

Update any Meger Cells FRT if u have done anything