We're creating a view on top of a domain and then make a report on top of the view. The view has several fields from the domain, but we also need some additional queries against jndi datasource to bring in these results into view.
Fairly new to jasper and would like to know where "custom sql queries" are typically added. We are on Jasper Report Server Pro 6.0.1. Don't know if Jasper Report Studio is need for this. Seems like should be able to do it in a domain or view?
Any advice or direction appreciated.