where to write mysql query in jaspersoft server

0

I have installed jaspersoft server 6. No i want to write my own query for report.

How can i do?

kalpesh.chavda's picture
Joined: Mar 11 2015 - 11:50pm
Last seen: 3 years 3 weeks ago

Kalpesh,

   Can you add a little more information, like are you using the ce or pro.  Are you building your own jmxml using the JasperReports Studio? or are you creating a query resource?

Thanks, 

- Josh

jtoepfer - 4 years 6 months ago

Hi,

I am using pro. and want to create query resource

kalpesh.chavda - 4 years 6 months ago

1 Answer:

0

Hi Kalpesh,

Query areas in Jaspersoft : 

1) iReport/ Jasper Design Studio 

Right click the report name -> Find Edit Query 

Short cut : You can find the short cut button on the editor ( Just next to zoom in and zoom out buttons you can find the Query Executor - click on it and it will take you to query exeution area in iReport or Studio). 

2) Jasper Server

Testing : 

Right click on any folder -> Find Add Resource - > Then click on Query -> Go ahead on giving properties & SQL.

NOTE : Queries created on Jasper Server are used in input parameters.

Cheers..!!! 

 

sadakar's picture
627
Joined: Aug 14 2012 - 3:57am
Last seen: 2 weeks 1 day ago
Feedback
randomness