How to make a table with merge cells in column

Comments

• gpi

  January 2014 edited 5:06AM

  Try to use TfrxDBCrossView
• Adrian_XE4

  January 2014 edited 5:06AM

  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

  January 2014 edited 5:06AM

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

  January 2014 edited 5:06AM

  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

  January 2014 edited 5:06AM

  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

  March 2014 edited 5:06AM

  Update any Meger Cells FRT if u have done anything