Multiple queries in one View

Posted on March 30, 2015 at 9:30am

Hi,

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.

Thanks

 

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

1 Answer:

Posted on March 30, 2015 at 5:57pm

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

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