add a adhoc crosstab in ireport

[ahamdaoui]

I m new at jasper.

I  should create a report which recuperate data in text boxes and a crosstab with a drilldown feature.

to do that, i create a report having textboxes by ireport and a adhoc crosstab with adhoc module of Jasper server.

My problem is that i want to add the two reports . i thought of 2 methods : but i have problems with both and i don't know which one is the best?

1st : using dashboard : the dashboard allow me to add my 2 reports but the problem is that i loose the drill down feature of the adhoc crosstab. in addition, i m looking on how to add an input control to synchronize the update of the 2 reports.

2sd: using ireport by importing the adhoc crosstab on ireport and then add the textboxes missing. BUT the preview of the adhoc crosstab doesnt work and it gives me this error : 

"ompiling to file... C:UsersAdministrateurAppDataLocalTemp2jstmpfile_1368626073026.jasper
Errors compiling C:UsersAdministrateurAppDataLocalTemp2jstmpfile_1368626073026.jasper!
Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@47aebbd  net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl resolves to a package import com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl;        <----------------------------------------------------> 1 errors 1. Only a type can be imported. com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl resolves to a package import com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl;        <----------------------------------------------------> 1 errors      at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:204)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:512)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)"

can you plz to show me wich solution is better? or any other solution?

thanks a lot

Asma

[biamazon]

I am facing the same issue. Did you find out a way to Run Ad-hoc reports in iReport?