where to write mysql query in jaspersoft server

[kalpesh.chavda]

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

How can i do?

[joshuatoepferyahoo.com]

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

[sadakar]

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..!!! 

 

[kalpesh.chavda]

Hi,

I am using pro. and want to create query resource