Slowness while using SQL Server as datasource for jasper reports

If SSMS its executing fast means there's more chances of bottleneck being at jasper end.

Did you check if memory set at JVM is sufficient? Is it a really large report? Are you using pagination?

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page