Merge title in a DBGRID
lazarus / 16-Databases

----------------------------------------------------------------------
alexs_marc · 2020-07-21 13:11

Hi folks!

I would like to know if there is a way to group columns from a DBGRID
in the title (merge). In Delphi I use a component called TMDBGRID that
has this feature. I would like to do this on Lazarus without
installing third party components.

Has anyone ever needed this and got a native solution?

Thanks!

----------------------------------------------------------------------
rvk · 2020-07-21 14:22

This is not possible with TDBGrid.

But maybe you can check if TRxDBGrid can do this.
(It's downloadable via Package > Online Package Manager)

(screenshot?
http://freepascal.ru/forum/viewtopic.php?f=18&t=4743#p39711)

----------------------------------------------------------------------
Renato Ricci · 2021-05-25 20:51

Hi Alex .. Did you manage to merge in the title?

Thanks.

----------------------------------------------------------------------
alexs_marc · 2021-05-26 00:39

No buddy... I couldn't do it natively, I tried THeader to no avail.
And then I used canvas as an alternative resource.

----------------------------------------------------------------------
bpranoto · 2021-05-26 03:16

Use TRxDBGrid from Rx. You can install it from the Online Package
Manage.

It supports Columns Bands, footer,etc. like the attached picture.

----------------------------------------------------------------------
Renato Ricci · 2021-05-26 11:53

Thanks Alessandro.. Since I already use TRxDBGrid, I will try what
@bpranoto suggested.

@bpranoto, Did you set the bands at the collumn level or at the grid
level? Cause I did not find any component property to accomplish it.

Thanks.

----------------------------------------------------------------------
bpranoto · 2021-05-26 12:03

Quote from: Renato Ricci on May 26, 2021, 01:53:35 pmThanks
Alessandro.. Since I already use TRxDBGrid, I will try what @bpranoto
suggested.

@bpranoto, Did you set the bands at the collumn level or at the grid
level? Cause I did not find any component property to accomplish it.

Thanks.

To set Band title to adjacent columns set the title Columns like this:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i Band :=
'ITEM|';Kol := Grid.Columns.Add;Kol.Title.Caption := Band +
'KODE';Kol.Title.Alignment := taCenter;Kol.FieldName :=
'ITEMCODE';//Kol := Grid.Columns.Add;Kol.Title.Caption := Band +
'DESCRIPTION';Kol.Title.Alignment := taCenter;Kol.FieldName :=
'ITEMNAME';

----------------------------------------------------------------------
Renato Ricci · 2021-05-26 12:15

@bpranoto.. the PIPE |caractere did the trick! I did not know that!

Thank you very much!

----------------------------------------------------------------------
bpranoto · 2021-05-26 14:51

You're welcome! Rx is great!