[#6666] - Discrepancy in report execution on JasperStudio and JasperServer

I have uploaded a report to JasperServer using JasperStudio, but the results displayed in JasperStudio differ from the results displayed in JasperServer.

Is there a problem in the way which JasperServer executes SQL queries?

Data source Query:

SELECT n2.acct_id aih, n2.acct_name anh, n.acct_id ai, n.acct_name an, o.o_bal, v.debit, v.credit, IFNULL(o.o_bal,0)+IFNULL(v.debit,0)-IFNULL(v.credit,0) balance
FROM nom n
LEFT JOIN nom n2 on (substr(n.acct_id, 1, 6) = n2.acct_id)
LEFT JOIN (SELECT ALL vd.acct_id,sum(vd.debit-vd.CREDIT) o_bal
FROM voucher v LEFT JOIN voucherdet vd ON (v.comp_id = vd.comp_id and v.year_id = vd.year_id and v.voucher_id = vd.voucher_id)
AND (v.VOUCHER_DATE < $P{Date_From})
AND (v.COMP_ID = $P{Comp_ID})
GROUP BY vd.acct_id
) o ON n.acct_id = o.acct_id
LEFT JOIN (SELECT ALL vd.acct_id, sum(vd.debit) debit, sum(vd.credit) credit
FROM voucher v LEFT JOIN voucherdet vd ON (v.comp_id = vd.comp_id and v.year_id = vd.year_id and v.voucher_id = vd.voucher_id)
AND (v.VOUCHER_DATE BETWEEN $P{Date_From} AND $P{Date_To})
AND (v.COMP_ID = $P{Comp_ID})
GROUP BY vd.acct_id
) v ON n.acct_id = v.acct_id
WHERE (o.o_bal <> 0)
or (v.debit <> 0)
or (v.credit <> 0)

Attached: Screenshot from Jasper Studio (The correct report) + Screenshot from Jasper Server (The incorrect report, the same accounts are being repeated many times over.)