[analyze report execute]

I ask if exist a tool for Jaspersoft Studio for analyze the report execution. I view the "statistics" palette, but the information is poor...
Any idea?

[mismatched input '$P!{__#param1}' expecting ')']

translated, the select query is this:

SELECT count(DISTINCT CASE WHEN ((o.id IS NOT NULL)  AND (o.activate BETWEEN (TO_DATE('01/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('26/02/2014', 'dd/mm/yyyy')))  AND ((o.validate BETWEEN (TO_DATE('23/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('20/02/2014', 'dd/mm/yyyy'))) AND o.play LIKE 'Close')) THEN o.id END) AS number, o.type[/code]

and i have always the same error... why??

[mismatched input '$P!{__#param1}' expecting ')']

I using DB Oracle 10g.

 

[mismatched input '$P!{__#param1}' expecting ')']

select count(distinct case when (o.id is not null $P!{__#param1}  $P!{__#param2} ) then o.id end) as Number, o.typefrom OST owhere o.type is not nullgroup by o.typeorder by o.type[/code]

when i write this query in my data set, JasperStudio indicate me this error:

mismatched input '$P!{__#param1}' expecting ')'

and i can't execute the report.

I'm sure that the content of param1 and 2 it's ok (and if i remove one of them, the query work).

How i can resolve this?

[RESOLVED: JasperReport Server report reference to sub-reports]

i have found the solution!

when i add a subreport under a table cell, jasperstudio don't load automaticaly the jrxml file of sureport, so you need to upload and change the reference manually with the uri (if sub report is load in the mainreport resources):

repo:/subReport

or the absolute path

/folder_to_the_mainReport/mainReport_files/subReport

 

I don't know why jasperStudio have this behavior, but you just need to figure out how to make remedy :)

[RESOLVED: JasperReport Server report reference to sub-reports]

I have a report Report1 that contains a lot of sub-reports (subReport1, subReport2, etc...) linked inside a table (in the table cell i have insert a sub-report).

In JasperStudio i have put all subreport's file in a folder in the same project:

MyProgect/

Report1.jrxml

Report1.jasper

/subReports

subReport1.jrmxl

subReport2.jrxml

subReport3.jrxml

subReport1.jasper

subReport2.jasper

subReport3.jasper

Report1 reference to the subreports by her *.jasper file (exemple of Expression parameter: "subReport/subReport1.jasper) and work perfectaly.

Now, when i put all in the server (maintaining the same folder hierarchy but all put in the server's folder /Process) i have this error:

The server has encountered an error. Please excuse the inconvenience.

Error Message

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Resource not found at : subReports/subReport1.jasper

How i can fix this problem?

(i have try to change the path to /Process/subReports/subReport1.jasper but nothing...)

[send a parameter to a sub-dataset]

Its helpful yes, but i need a solution to pass each rows result of datase10 to dataset11.

Example:

Dataset10 result this SQL table (i don't know how many and the result isn't static (it's possible in the future a val4, val5 and soon)):

val1

val2

val3

 

ok, for each value use this in the sub-dataset11 for compiling the query:

select *

from myTable

where myTable.attr = val1

 

and soon...

 

It's possible?

[send a parameter to a sub-dataset]

I need to send a particular value to a sub-dataset.

dataset10 produce the table with a lot of value, for each row value invoke another dataset11 with this value like a foreach cycle that produce another table to shw in the report.

Its possible?

I hope I explained as best as possible ...

[Show group by query result]

It's possible view or hide a group band in relation of a query result (setup in a specific dataset)?

[Style and Document is Empty]

In my report, after have modify the style of tables, the report preview return "Document is Empty". Why????

[passing main parameter to sub-datasets with JasperStudio]

works a lot!!! thx :)

[passing main parameter to sub-datasets with JasperStudio]

I'm created a report with JasperStudio 5.5 that have many parameter defined in the main and a lot of sub-dataset (defined with tables) that required this parameters.

The situation:

/main/Parameters: myPar

/main/mySubDataSet1/
/main/mySubDataSet2/
...
/main/mySubDataSetN/

The sub-dataset need to use this parameter in her query: select * from Tab t where t.attr = $P!{myPar}

So, my problem is that the sub-dataset can't access at this main paramenter, all the time that i try compiled, the program send me "Parameter not found : myPar".

How i can do for use myPar in the sub-dataset?

p.s.: i read this thread Pass main dataset parameter to subdataset query (based on iReport) but without success...

[Using same parameter between two datasets]

And with JasperStudio?

[Add new Global Report Parameter]

I need to create a new global parameter in my report (created with Jaspersoft Studio 5.5 and after publishing in JasperServer 5.5).

So, my report is very big and it's impossible to cover all information in one query.

I tried to create a lot of table but the parameters aren't inherited!

In short, I need to use the main parameters of the report all'inderno of the various datasets.

This parameter it's a simple data that a user specify when invoche the report.

There are some solution?