Multiple queries in one View


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.



bill.talley's picture
Joined: Oct 23 2014 - 7:15am
Last seen: 8 years 1 month ago

1 Answer:

Custom SQL can be written in Derived Table in Domain definition.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago