[MySQL] Perhitungan saldo compatible dengan Jasperreport

biasanya saya menggunakan user defined variable untuk menyimpan nilai (kolom) saldo. tapi berhabung kata rekan kerja saya, dia menginginkan querynya tetep kompatible dengan jasperreport, maka ada sedikit modifikasi untuk inisialisasi user defined variable di mysqlnya.

berikut samplenya querynya:

SELECT     iddinamic_variable,
(if(col_int>=0,col_int,”)) as masuk,
(if(col_int<0,col_int,”)) as keluar,
(@count := @count + col_int) as saldo
FROM tester.dinamic_variable
left join (select @count:=0) as a on 1=1;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s