Merge title in a DBGRID

[alexs_marc]

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]

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]

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

Thanks.

[alexs_marc]

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

[bpranoto]

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]

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]

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.

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

Code: Pascal  [Select][+][-]

1. Band := 'ITEM|';
2. Kol := Grid.Columns.Add;
3. Kol.Title.Caption := Band + 'KODE';
4. Kol.Title.Alignment := taCenter;
5. Kol.FieldName := 'ITEMCODE';
6. //
7. Kol := Grid.Columns.Add;
8. Kol.Title.Caption := Band + 'DESCRIPTION';
9. Kol.Title.Alignment := taCenter;
10. Kol.FieldName := 'ITEMNAME';
11.  

[Renato Ricci]

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

Thank you very much!

[bpranoto]

You're welcome! Rx is great!