Require help: Multiple dynamic queries in ad hoc editor

[deepa197]

Hi,

I am new to Jasper Reports. We are using jasper server ad hoc editor to create reports. We are in urgent need of creating a dynamic report as follows:

For e.g., our table in database contains fields as follows:

companyid salesamt empcount yearest

C3455 500 5 2002

C1223 156 3 2001

C7789 600 6 2005

C4890 800 12 1999

 

I would like to create a report as below:

 

SalesRange No.ofCompanies

100-150 0

100-300 1

200-550 1

100-600 2

600-➕ 1

 

Sales ranges will be given as input at the time of report execution.

Sales ranges will be as per end-user's wish.

Maximum no.of input ranges can't be predicted.

 

Can we create such reports in Jasper Server Ad Hoc editor?

If yes, please guide me on how to create such reports?

 

Please note that I am not using iReport Designer to create the reports.

Please help. Its urgent.