Top & Trending
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. SELECT dbo.pri.sym, COUNT(*) AS Priority_cnt FROM dbo.call_req INNER JOIN dbo.pri ON dbo.pri.enum = dbo.call_req.priority INNER JOIN dbo.prob_ctg ON dbo.prob_ctg.persid
1. How to display total number of Row at top of report ? 2. How to display Date filter value at the top of the report?