KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Rename aggregate column #1874

Open Epitello opened this topic on on Jan 27, 2021 - 3 comments

Epitello commented on Jan 27, 2021

Hello, I would like to rename aggregate column generate by visualQuery. Exemple : the sum of motant display something like this : "(sum) montant" and i want "global montant". Do you have any solutions for this ? Thanks by advnce

David Winterburn commented on Jan 28, 2021

Hi,

We will look into providing an option for this. Meanwhile I see two ways for you to change this:

1 . Replace string of the generated sql query from VisualQuery.

2 . Change the label of column meta of "sum(montant)" to something you want.

Let us know your opinion. Thanks!

Epitello commented on Feb 2, 2021

Thanks for your answer. Personally i choose to replace the string of the generated query because is the best way for my utilisation

Epitello commented on Feb 2, 2021

Because i have to change alias and the columMeta method not provide this option

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

VisualQuery