This below Query is working fine in SQL and Jasper Studio Main report but when adding table using this query in jasper Studio query data showing three times.
COUNT(*) AS Priority_cnt
INNER JOIN dbo.pri ON
dbo.pri.enum = dbo.call_req.priority
INNER JOIN dbo.prob_ctg ON
dbo.prob_ctg.persid = dbo.call_req.category
dbo.prob_ctg.sym LIKE 'Application ISU%'
AND dbo.call_req.status = 'CL'
GROUP BY dbo.pri.sym
Please help me with a proper solution.