pivot table - Jasper Studio crossTab, rowGroup DateTime to "Month Year" - Stack Overflow

admin管理员组

文章数量:1399955

I have been struggling to get my crossTab to group by "Month Year". I read that SimpleDateFormat is outdated. My dataset is using language domain.

The coding is html style and lots of solutions out there are based on object-oriented language with class and constructors. I have the below:

            <rowGroup name="InvoicePayment.DateTime_Paid_1" width="120" totalPosition="End">
                <bucket class="java.sql.Timestamp">
                    <bucketExpression><![CDATA[$F{InvoicePayment.DateTime_Paid_1}]]></bucketExpression>
                </bucket>
                <crosstabRowHeader>
                    <cellContents mode="Opaque" style="Crosstab_CH">
                        <textField>
                            <reportElement x="0" y="0" width="120" height="20" uuid="a1f18861-cce6-4f61-a181-b6566db45c98"/>
                            <textFieldExpression><![CDATA[$V{InvoicePayment.DateTime_Paid_1}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabRowHeader>
                <crosstabTotalRowHeader>
                    <cellContents mode="Opaque" style="Crosstab_CT"/>
                </crosstabTotalRowHeader>
            </rowGroup>`

This code new java.text.SimpleDateFormat("MMM YYYY").format($F{InvoicePayment.DateTime_Paid_1} works in a table, but not in a rowGroup on CrossTab

Even just using table with grouping. Why is it just no examples out there for grouping a TimeStamp field to "Month Year"

本文标签： pivot tableJasper Studio crossTabrowGroup DateTime to quotMonth YearquotStack Overflow