Jump to content
Changes to the Jaspersoft community edition download ×

ananyachoubey18

Members
  • Posts

    5
  • Joined

  • Last visited

ananyachoubey18's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hi, I am designing a report using Jaspersoft Studio. In the screenshot attached below, I have used a table and using a printwhenexpression to display the hostname just once for repeated values. Now I want the repeated host values in a single row and in the middle. Also I have kept print repeated values as false. I am not able to add the dynamic row spanning. hostname.bmp What I want is this: csv.bmp Please Help
  2. @Elizam Thanks for the explaination. Is there any work around for this problem?
  3. @Elizam Thank you for the explaination but is there any workaround for this type of situation?
  4. Hi, I have created a report using Crosstab and I am simply taking the average of the values and then displaying it in the percentage form. However, when I take the average manually or using excel, my total value doesn't match the crosstab report for few entries. In the image below, as you can see, the average for CORP branch is incorrect. It is supposed to be 75.25% but crosstab is calculating it to be 75.59% Can someone please tell me how to fix this? crosstab.bmp <crosstab><reportElement x="0" y="0" width="2160" height="426" uuid="fad7e9b5-6685-49d8-83d9-e7ddec9a72bd"><property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/></reportElement><rowGroup name="Branch1" width="60" totalPosition="End"><bucket class="java.lang.String"><bucketExpression><![CDATA[$F{Branch}]]></bucketExpression></bucket><crosstabRowHeader><cellContents mode="Opaque" style="Crosstab_CH"><textField><reportElement x="0" y="0" width="60" height="20" uuid="ddc76b5c-fa7b-4f8d-9365-dc5489e1ea4d"/><textElement><font fontName="Arial" size="11" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{Branch1}]]></textFieldExpression></textField></cellContents></crosstabRowHeader><crosstabTotalRowHeader><cellContents mode="Opaque" style="Crosstab_CT"><staticText><reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="3f681ef8-8c0b-4ea5-b3f5-680c7fa79b71"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="11" isBold="true"/></textElement><text><![CDATA[Total Branch1]]></text></staticText></cellContents></crosstabTotalRowHeader></rowGroup><columnGroup name="Insertion_Time1" height="20" totalPosition="End"><bucket class="java.sql.Timestamp"><bucketExpression><![CDATA[$F{Insertion_Time}]]></bucketExpression></bucket><crosstabColumnHeader><cellContents mode="Opaque" style="Crosstab_CH"><textField pattern="M/d/yy"><reportElement x="0" y="0" width="60" height="20" uuid="d38f3a54-ac5f-4a84-9927-139d2ad515f1"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="11" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{Insertion_Time1}]]></textFieldExpression></textField></cellContents></crosstabColumnHeader><crosstabTotalColumnHeader><cellContents mode="Opaque" style="Crosstab_CT"><staticText><reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="89c4c5c6-be8b-4134-be8b-ac69801a7824"/><textElement verticalAlignment="Middle"><font fontName="Arial" size="11" isBold="true"/></textElement><text><![CDATA[Total Insertion_Time1]]></text></staticText></cellContents></crosstabTotalColumnHeader></columnGroup><measure name="folder_status_numeric_MEASURE1" class="java.lang.Double" calculation="Average"><measureExpression><![CDATA[$F{folder_status_numeric}]]></measureExpression></measure><crosstabCell width="60" height="20"><cellContents mode="Opaque" style="Crosstab_CD"><textField pattern="#,##0.##%"><reportElement x="0" y="0" width="60" height="20" uuid="73050814-3b1c-4949-a44d-d925bf168d4b"/><textElement textAlignment="Left" verticalAlignment="Middle"><font fontName="Arial" size="11"/></textElement><textFieldExpression><![CDATA[$V{folder_status_numeric_MEASURE1}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell width="60" height="20" columnTotalGroup="Insertion_Time1"><cellContents mode="Opaque" style="Crosstab_CT"><textField pattern="#,##0.##%"><reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="bffe510e-9697-4c8f-8859-65b71f2a7590"/><textElement><font fontName="Arial" size="11" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{folder_status_numeric_MEASURE1}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell width="60" height="20" rowTotalGroup="Branch1"><cellContents mode="Opaque" style="Crosstab_CT"><textField pattern="#,##0.##%"><reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="71d1f9eb-2bc5-444e-88a2-212ef62f5094"/><textElement><font fontName="Arial" size="11" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{folder_status_numeric_MEASURE1}]]></textFieldExpression></textField></cellContents></crosstabCell><crosstabCell width="60" height="20" rowTotalGroup="Branch1" columnTotalGroup="Insertion_Time1"><cellContents mode="Opaque" style="Crosstab_CT"><textField pattern="#,##0.##%"><reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="f70469f9-8f44-4d66-b634-202ba81d3ec5"/><textElement><font fontName="Arial" size="11" isBold="true"/></textElement><textFieldExpression><![CDATA[$V{folder_status_numeric_MEASURE1}]]></textFieldExpression></textField></cellContents></crosstabCell></crosstab> [/code]
×
×
  • Create New...