Topic: how to get total sum on grid footer with sql query button
Hi,
I created a yerterday button with sql query settings.
When click on yerterday button it shows the records of yerterday.
How can i get total sum on grid footer?
test app attached
My Visual Database → General → how to get total sum on grid footer with sql query button
Hi,
I created a yerterday button with sql query settings.
When click on yerterday button it shows the records of yerterday.
How can i get total sum on grid footer?
test app attached
Hello Kkalgidim,
You can define your tablegrid as normal with the columns you wish to see and any column totals.
Your 'sql query' uses this definition to display the output and the totals will be shown as specified (see 'yesterday sql query' in the attachment).
Instead of an 'sql query', you could just use a simple 'search' (see 'yesterday search calendar' in the attachment); this gives you flexibility to see expenditure for any day (not just yesterday).
I hope this helps.
Derek.
Thank you Derek
Calendar clicl version is really useful but i want to create buttons like
yesterday
last week
last month
is it possible to make it on calendar version?
i am using version 1.49
when i use sum on grid settings it does not appear!
Bu latest version it appears
kkalgidim
I have added footer in your project, also added button last week and last month.
I downloaded latest minor update ver 1.52
Problem fixed on this version . So i did not use function for total sum. I used grid setting for it.
For date intervals i used 2 calendar object with >= and <= filter
so i am getting result between 2 date filed
Also i used buttonf for practical use as yerterday, last week, last month.
Thanks for your help Derek and Dmitry
Hello all,
I had a look with great interest to the example posted by Dmitry and I noticed the
Form1.TableGrid1.Columns[3].Footer.FormulaKind := fkSum;
in the code.
I was wondering Dmitry, are there other Formulakind we can use like this and how are they named ?
fkCount
fkAverage
fkMaximum
fkMinimum
fkDistinct
Is this correct ?
Cheers
Mathias
mathmathou
There is no more formulas, only listed above
How do you read (get) the value of the footer columns?
Got it Thanks...
frmMain.TableGrid3.Columns[0].Footer.Caption
property Caption return string, another way to get float value
Form1.TableGrid3.Columns[0].Footer.FormulaValue
My Visual Database → General → how to get total sum on grid footer with sql query button
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi