joydeepadhikary_1 Posted March 15, 2023 Share Posted March 15, 2023 Hi ,I've two tables in the jrxml with two different datasets. In these two tables, one table is having two groups on the two fields of the dataset. one group field is used in group header and footer both. Another group field is used in Group footer only.Sometimes, after generating PDF, the footer value for the first set of group, are coming blank. Here "Blank When Null" is checked. But I can see in system log, all the data in DTO list is present properly.This is happening only for the 1st Group of the table. from next grouped values are coming properly.Even problem doesn't persist after regenerate the PDF with same data. There is no exception has been noticed in system logs.I can share my jrxml if required. Looking for suggestions on the same. Link to comment Share on other sites More sharing options...
anish.rai Posted March 30, 2023 Share Posted March 30, 2023 Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times. Link to comment Share on other sites More sharing options...
Thomas Tibcken Posted March 30, 2023 Share Posted March 30, 2023 Hi, I will try to find an answer for you. In cases where "sometimes it's not working" - it is ab bit tricky to finde something. As a starting point can you please share the jrxml and a screen shot of the working and not-working PDF?It is also helpful to see what release you are using. THX TT Link to comment Share on other sites More sharing options...
joydeepadhikary_1 Posted April 3, 2023 Author Share Posted April 3, 2023 Thanks TT, for showing your interest. I'm using Jasper Studio 6.20.0.Please find attached jrxml and pictures.NOTE: Table in the shared pictures is output of the table given in 2nd detail section of JRXML, where the problem has been noticed. Link to comment Share on other sites More sharing options...
joydeepadhikary_1 Posted April 6, 2023 Author Share Posted April 6, 2023 Hello TT, could you please check attachments and suggest me a way out. Link to comment Share on other sites More sharing options...
Prasanth Parameswaram Posted April 10, 2023 Share Posted April 10, 2023 Hello Joy,I have gone through the jrxml and couldn't see any issues. Could you please try the below and advise.1. Please try removing the logic " $R{java.bill.detailSumm.sTotal.label} + " " + $F{serviceSegment} + "u00a0u00a0" +new DecimalFormat("#,###,###.00").format($V{segAmtGroupTotal})" with $R{java.bill.detailSumm.sTotal.label} and see if this fixes the issue.if the issue is fixed , we can conclude that during the calculation of "+ $F{serviceSegment} + "u00a0u00a0" +new DecimalFormat("#,###,###.00").format($V{segAmtGroupTotal})" is causing some issue. 2. If the issue is not fixed, please generate the report with other formats (docx etc.) and see if the issue can be replicated. 3. Untick "Blank when NULL" and check whether null is getting printed to confirm if the expression evaluates to null somehow. Link to comment Share on other sites More sharing options...
joydeepadhikary_1 Posted April 12, 2023 Author Share Posted April 12, 2023 Hi prparame,Thanks for your suggestions. Previously the total calculation was not there in jrxml and it was a simple field. That time also the problem was there. However, I will try your suggestions and update if get it fixed. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now