"Merge cells?"

Comments

• Mick.pl

  May 2011 edited 12:03PM

  I can't find a way to merge cells from different rows in DBCross so I used standard MasterData band.
  Maybe my solution is not ideal but you can verify if it helps you:
  
  
• cafe

  May 2011 edited 12:03PM

  Thank you Mick.
  I managed doing it using groups. It doesn't have the same layout but its also functional and understandable. I realized that to achieve that layout i had to change the table.
  I dit it this way.
  
  GroupHeader
  Ex
  GroupHeader
  Room
  Masterdata
  User1 ___________
  User2 ___________
  User#
  GroupFooter
  _________(line)
• Mick.pl

  May 2011 edited 12:03PM

  OK, if you get what you need.
  My solution is based on GroupBand as well, but query (in my simple FR3 example attached a few hours ago) is not modify. Just order by State.
  

  select * from customer
  where state is not null
  order by state, company
  

  and the only thing to manage Memos' frame is a piece of FR script like below:

  var
      LastState  :string;                                                                 
  
  procedure MasterData1OnBeforePrint(Sender: TfrxComponent);
  begin
    with Memo2.Frame do if LastState <> <ADOQuery1."State">
      then Typ := ftTop + ftLeft
      else Typ := ftLeft;
    LastState := <ADOQuery1."State">;        
  end;
  
  begin
      LastState := '';                                  
  end.
  

  
  Mick