title: How to query domain in jaspersoft with Dynamic Parameters
body: <p>I am new to jaspersoft reporting. I am currently designing and developing reports by considering following requirements.
  I want to create template based reports where all dynamic parameters I need to pass in SQL query.
  I was going through japsersoft reporting I found that we can create join views and cache data by creating domains. So that it reduces hits at db level.</p>
  
  <p>While creating report I found that I cant execute SQL script on Domain objects.</p>
  
  <p>Please advice whether I am on right track or not.
  Basically I want to query on cached data such as domain view instead of hitting DB directly.</p>
  
  <p>Please suggest if any workaround is available for this problem.</p>