miwagada

Hi Team , I have 2 columns : 1) To_Date : Datetime. 2) Status : Integer. (Fixed values set for Status) I want to get sum of "seconds" from To_Date column as when the status column changes. For Ex : Data is like in table : StatusDatetime (in seconds)120025002100140022501100So for Status 1 - I should get value 700, similarly for Status 2 - I should get value 850. How this can be achieved without using scriptlets?

Just restart Jasper studio.

I too have the same requirement. https://community.jaspersoft.com/questions/1107841/iterate-linkedhashset.

1) use html tags in textfield. 2) change markup to "html" of textfield properties. Hope it works. Regards, Miwa

You have to import StrinUtils first in your jrxml source code: <import value="org.apache.commons.lang.StringUtils"/> Its working in my environment.

You can use leftPad function of StringUtils ex : import org.apache.commons.lang.StringUtils; StringUtils.leftPad($F{field_name}, 6,"0"); "6" : length of the desired string. "0" : inserts 0 at beginning. Hope it may help Regards, Miwa

Have you used below in sql query ?$X{IN, column_name, list_parameter_name} Regards, Miwa

Hi, I think you should use JRBeanCollectionDataSource(<List>) method. you can refer below link: https://www.programcreek.com/java-api-examples/?api=net.sf.jasperreports.engine.data.JRBeanCollectionDataSource Hope it works Regards, Miwa

Alternative Answer : Use Stretch properties of Bar graph, if x-axis values are not seen OR increase the band size. OR change the Position Types. Hope it works. Regards, Miwa

Yes sure. as per your structure : |Category1 | Note1 | |Category1 | Field1 | Value1 | |Category1 | Field2 | Value2 | |Category2 | Note2 | |Category2 | Field1 | Value1 | |Category2 | Field2 | Value2 | As per your requirement, select Table component, step 1 : create group on "Category", step 2 : add columns category, Fieldname, valuename, step 3 : select all columns - > right click -> group columns -> add textfield on grouped area. Step 4 : add Category Or Note fieldname in the textfield expression. Thats it. Hope it will work. Regards, Miwa

Alternative answer use n and t on your textfield expression. Hope it may work Regards, Miwa.

Add "Status" Textfield into Frame.

$V{Variable_2}+"n"+"t"+$V{Variable_2}

Table can be used with such requirements. Use Groups in Table component.For total part, use Group Footer or Table footer for grand total.

($F{id}==null AND $F{name}.equals("Jasper")) OR $F{sal}>10000?"ABC":"XYZ"

try this out. : <variable name="cur_date" class="java.lang.String"> <variableExpression><![CDATA["02-09-2019"]]></variableExpression> </variable> <variable name="Variable_1" class="java.lang.String"> <variableExpression><![CDATA[new SimpleDateFormat("dd-MM-yyyy").format(NOW( )).toString()]]></variableExpression> </variable> <variable name="Variable_2" class="java.util.Date"> <variableExpression><![CDATA[NOW()]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <pageFooter> <band height="51" splitType="Stretch"> <textField> <reportElement x="60" y="10" width="100" height="30" uuid="0d31c363-a408-485d-9e99-1bb922846a90"/> <textFieldExpression><![CDATA["Cur Date : "+$V{cur_date}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="117" splitType="Stretch"> <textField> <reportElement x="170" y="43" width="340" height="30" uuid="cd531e57-7944-4354-af7c-9c37bf897e80"/> <textElement textAlignment="Left" verticalAlignment="Top"/> <textFieldExpression><![CDATA[$V{cur_date}.substring(0,2)!="14"?"14"+$V{cur_date}.substring(2,5)+$V{cur_date}.substring(5,10):$V{cur_date}]]></textFieldExpression> </textField> <textField> <reportElement x="302" y="14" width="100" height="30" uuid="70643b88-d842-4e6f-9746-bc5a613bc84a"/> <textFieldExpression><![CDATA[$V{Variable_2}]]></textFieldExpression> </textField> </band> </summary>

Edit the published report and select proper database (which you have created in your server). OR Select proper database in Jasper studio while publishing to Jasper server. If still not able to connect to db, restart your Jasperserver service and your connected db.

I have one variable 'arr1' which saves date field values in LinkedHashSet and 2nd variable 'state' of int type (not unique). Now , result should retrieve difference of 'arr1' values which falls under certain value of 'state'. Can anyone help me on this problem?

pass input control parameter name in the query you are using like : select id, name from customers where id = $P{id_name} Or select id, name from customers where id in $P!{id_name} where id_name is the name of input control created in jasper server.

This may help..

Problem Solved

Hi , I am using Jaspersoft Studio 6.4.0 pro, I am using pie chart which has 5 slices. Requirement is to show each new graph resective of slice selection in drill-down manner. Example : Pie returns 2 slice values : Good (60%) and Bad (40%) , if we click on Good slice, all factors related to good will be shown in a pie/bar graph. Similarly, if we click on Bad, page dashlet will update to Bad factors with Bar or Pie chart. There are no Parameters involved for this requirement.

I have one dashboard that contains 2 dashlets (designed in jaspersoft studio). I am struggling to redirect to that dashboard from new report (drill from report -> Dashboard). Till now I found to drill down reports to reports, how can i drill report to dashboard? I have used _report parameter and added "repo:/dashboard_path", it says, Error MessageUnexpected type (Dashboard) of the resource with URI repo:/trial/OEE_Quality. Require urgent help on this problem.

I want to display only first and last value from dataset pulling for X-Axis in Stacked Column Graph. Category Set value is of Date type. Hence I dont want to print each date value on graph except for the first and last value in output. I have applied "showLabel=0' in chart properties, but its not getting reflected. Can I know the solution of this issue?

Use subreport for external report to display its values