rpachipu

Please go the below link for drilldown in multi-graph filtering. Adding a Hyperlink to a Chart Dashlet | Jaspersoft Community

HI, You can achieve this only using scriptlet or creating a jar using the jasper reports libraries table component by calculating the length of the text to derive on the table width. Also you can check on the below url. TIBCO Jaspersoft® Studio Layouts | Jaspersoft Community

Need to check how the 6 subreport are placed. If possible please share the jrxml to analyse the issue.

Hi , if its JSON datasource you can try '/' instead of '.' as below: <field name="shift" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="shift"/> <fieldDescription><![CDATA[shift]]></fieldDescription> </field> <field name="employees" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="employees"/> <fieldDescription><![CDATA[employees]]></fieldDescription> </field> <field name="initialName" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="initialName"/> <fieldDescription><![CDATA[employees/initialName]]></fieldDescription> </field> <field name="employeeName" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="name"/> <fieldDescription><![CDATA[employees/name]]></fieldDescription> </field> <field name="employeesPoSup" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="poSup"/> <fieldDescription><![CDATA[employees/poSup]]></fieldDescription>

We are so glad that your problem was solved.

1.You can freeze the top rows or columns you applying below property <property name="net.sf.jasperreports.export.xls.freeze.column" value="A"/><property name="net.sf.jasperreports.export.xls.freeze.row" value="1"/> 2. You achieve the same from the studio UI after right clicking on the textbox as below:

This issue will happen when you export a path in an organization or whole organization as a URI in buildomatic without the --organization flag. This will generate you a regular export archive that contains all the resources under certain URI starting from the root. Then you try to import that archive with the --organization flag. This is incorrect, you need to have consistency with these flags since --organization flag expects an archive in certain format that contains only organization data. To correctly export and import organization using buildomatic or web services make sure you're always providing the --organization flag.

You pass the main report parameters to table dataset as shown below:

You can sort in query or in SortFields in jrxml. The order should be like order by emp name, account, company, salary, department, compensation.

Hi, you need to use breaks specific to xlsx .PFA

Check whether scale image option to fill frame and see you placed the image to the full background ( which equals to page size).

Place the image in background band and apply the print when expression $V{PAGE_NUMBER} ==1 for band or the image.

Hi , You can use background band for the image or watermark to display for all pages. Set Image's property scale image to display full image.

Is the report migrated from another lower version try to recreate the textbox . In such cases you can add a tab space "\t" at the end of the text in a text filed instead of line break.

Once jar is created, we may need to add the jars under the "..apache-tomcatwebappsjasperserver-proWEB-INFlib" directory or you can upload it to the server as resource to the report which uses the scriptlet. Here the video tutorial for this.

In studio, you cannot use a dataset fields directly into the main report. You can use Dataset fields, if your main report has a list, table or sub-reports. If you want to compare the results of datasets. There are two ways. 1. writing a scriptlet 2. Handling at the query itself. 3. using return variables from each dataset element and compare the values. Hope this help you.

Did you tried using text? did you check master report data connection whether its returning data? Also apply all sections no detail to main subreport and compile the jrxml.

The subreport is returning empty pages to the main report so its not displaying anything. You check when No Data Type to ALL Section No detail for the subreport to display the text . Also need to check the main report connection which is passing to subreport .

Hi Garbriel, It will be helpful if we know , what kind of customizations? UI changes or SSO changes or customizations in a custom jar file. Normally, we need to merge customizations code while doing upgrade. Also we need to make sure that there are no changes in the lastest version libraries you are using in your customizations , if there are such , you need to work on that.

Hi Jacob, if you want to use one field to add a backcolor of another , you can easily do this by adding property to your textfield than by conditional style. 1. Making the texfiled opaque. 2. appling net.sf.jasperreports.style.backcolor to the textfield. For eg: Where as c2 field will have hex color code. <textField> <reportElement mode="Opaque" x="127" y="1" width="73" height="30" uuid="41cbd2d7-7379-400f-95a7-bee3824834db"> <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$F{col2}]]></propertyExpression> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{col2}]]></textFieldExpression> </textField>

Before using the parameter in sql , need define the parameter accountId as below:

You can supress the pages based on input parameter or by defining a variable(System) and go the detail or other display bands and using the print when expression to do this. $V{PAGE_NUMBER} <= $V{PagesRequested}

Instead of using Print when expression on the frame or textbox, editing the expression will work i.e., $V{PAGE_NUMBER} ==1?"":$V{PAGE_NUMBER}

Yes, we can set the ruler options from windows -> Preferences as shown in the above pic. Another way to set from pageFormat.