Integer and decimal in same column

pelurusilver · Post by **pelurusilver** » Fri Nov 25, 2022 3:13 pm

Hi, i want to create a list and report with both count & sum

Count will display integer number and sum will display decimal number

Is it possible to plot them in 1 page but using different format of number

the count & sum will reside on their on row

thanks

mobhar · Post by **mobhar** » Fri Nov 25, 2022 4:44 pm

You may use Cell_Rendered server event.

pelurusilver · Post by **pelurusilver** » Sat Nov 26, 2022 5:01 pm

Can someone help me to produce the script. I also cannot find Cell_rendered in phpmaker 2021.

this is my table;

pelurusilver · Post by **pelurusilver** » Sat Nov 26, 2022 5:03 pm

CREATE TABLE rpt_crosstab_sum (
REPORT varchar(20) DEFAULT NULL,
Jan decimal(14,2) DEFAULT NULL,
Feb decimal(14,2) DEFAULT NULL,
Mar decimal(14,2) DEFAULT NULL,
Apr decimal(14,2) DEFAULT NULL,
May decimal(14,2) DEFAULT NULL,
Jun decimal(14,2) DEFAULT NULL,
Jul decimal(14,2) DEFAULT NULL,
Aug decimal(14,2) DEFAULT NULL,
Sep decimal(14,2) DEFAULT NULL,
Oct decimal(14,2) DEFAULT NULL,
Nov decimal(14,2) DEFAULT NULL,
Dec decimal(14,2) DEFAULT NULL,
Total decimal(14,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

which REPORT FIELD will have COUNT or SUMM

I want the no plot in Jan to Total ad decimal 2 places for SUMM REPORT.

mobhar · Post by **mobhar** » Sat Nov 26, 2022 5:17 pm

It's under your Reports object in your PHPMaker project, and not under Tables object.