vanjaxi.sm

There are 2 tables SL and DL. DL:id, device_name, username SL: id, time(hh:mm:ss) My required output should be I tried query select DE.device_name, AVG(SL.time),MAX(SL.time) FROM DE INNER JOIN SLON DE.id= SL.idgroup by DE.device_name and few other queries, I get average and maximum duration in column header and rest all values zero. I should get average values and max values for every device _name. Help me get it using crosstab element in jasper soft studio.

I nailed it. Thanks @javier to read through my ques and supporting. It helped. I found no need to map parameter or a qery to main report, though I tried all of the possibilities. Ofcourse used parameter {Report _Connection }.The problem lied with Data type in Main report properties where for Report - When no Data Type to set to All sections No Detail. Can you help me with Alignment of sub reports ??

@javier I created main report with empty dataset. Created a new sub report within main report in summary band which is a chart . In the sub report property in main report added Expression: "subreport1.jrxml" and connection expression comes as $P{REPORT_CONNECTION} I can view the subreport but when I run the main report the report is blank page/ Document is empty in Jasper soft Studio.

I want to create an empty main report with no dataset and no query in Jasper Studio to display existing reports as multiple sub reports in it. The main report should just act as a container to display multiple sub reports. Sub reports are charts having seperate datasets . How do I proceed?

I am working on jasper server 6. I am facing similar issue. No calendar icon visible outside the text box.

I have created a pie chart for a report displaying count the percentage and numbers of the protocol. My question: How to get the count and % as a tooltip for diff protocols as TCP-count 331 and %1.72 in pie chart?

@Sadakar Pochampalli how do I get calendar with icon (visible )to pick dates. I dont want text box to be displayed and if text box cant be changed then it should accept only only valid dates and not any text. Though I used the input control wizard to get calendar by changing the input control data type for dates in Jasper Server. But still Text box is visible and calendar icon is invisible but when i click outside the text box i get calendar to pick dates. Hope my question is not confusing.

I have a report with rundate,datefrom, dateto as input parameters with class type java.util.Date to pick dates as calendar , to generate report for specified dates. But when published on Jasper server, I dont get the calendar to pick dates. I get input control text box to type dates. So how to get calendar to pick dates ??and in dd/MM/yyyy date format??(default is mm/dd/yy). I need calendar similar as below: