sreerambabu.palaniswamy

Hi, When I try to reduce or increase the size of the Cell, it shows the red highlighted with error "resize or movement operations are not allowed by container layout". I changed the Layout from Vertical to Free in both at table level and also at Report level I followed the steps explained in this url https://community.jaspersoft.com/wiki/why-user-cannot-resize-field-table-tibco-jaspersoft-studio-v630 Please do help asap Thanks sReeram

Hi all, Recently I migrated the Jaspersfot report from 5.6.1 to 6.4.2, the reports worked fine in older version. When I exported the same to 6.4.2, it gives me below error. I even checked the webappsJaspersoftWEB-INFclassesesapiValidation.propertis, the following line looks good Validator.ValidSQL=(?is)^\s*(select|call|with)\s+[^;]+;?\s*$ Please do advise, how to solve the issues. FYI, I'm using the subreport of HTML chart for which the below query is used. 2018-06-11 18:32:03,361 ERROR Validator,MS_04_Main subreports #2:499 [root|superuser] - Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL: (SELECT PK_ID INVID, CATEGORY RADARCATEGORY, MAX(NVL(CRITICALITY,0)) RADARCRIT FROM (SELECT RIM.PK_ID, PLANG.NAME CATEGORY, CASE WHEN COUNT(PLANG.NAME) = 0 THEN 0 ELSE SUM(RIM.PROBABILITY_ENUM*RIM.IMPACT_ENUM)/COUNT(PLANG.NAME) END CRITICALITY FROM RIM_RISKS_AND_ISSUES RIM INNER JOIN ODF_CA_RISK RISK ON RIM.ID = RISK.ID LEFT JOIN CMN_LOOKUPS_V PLANG ON PLANG.LOOKUP_CODE = RISK.WM_CATEGORY AND PLANG.LOOKUP_TYPE = 'WM_CATEGORY' AND PLANG.LANGUAGE_CODE = 'en' GROUP BY RIM.PK_ID, PLANG.NAME UNION select DISTINCT RIM.PK_ID, CATEGORY, NULL CRITICALITY FROM (SELECT 'Resources' CATEGORY FROM DUAL UNION SELECT 'Delivery Quality' CATEGORY FROM DUAL UNION SELECT 'Scope' CATEGORY FROM DUAL UNION SELECT 'WMIS Dependencies' CATEGORY FROM DUAL UNION SELECT 'External Constraints' CATEGORY FROM DUAL union SELECT 'Sponsors/ Users Involvement' CATEGORY FROM DUAL) A INNER JOIN RIM_RISKS_AND_ISSUES RIM ON 1=1) WHERE CATEGORY IS NOT NULL and PK_ID IN ? GROUP BY PK_ID, CATEGORY )ORDER BY PK_ID,CATEGORY 2018-06-11 18:32:03,362 ERROR JRFillSubreport,MS_04_Main subreports #1:866 [root|superuser] - Fill 2: exception com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2018-06-11 18:32:03,365 ERROR JRFillSubreport,pool-6-thread-15:866 [root|superuser] - Fill 1: exception com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2018-06-11 18:32:03,368 ERROR AsyncJasperPrintAccessor,pool-6-thread-15:321 [root|superuser] - Error during report execution com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

Hi Maria, When I open the Design file in JSS, the default properties shows the "Configure workspace setting".In the workspace settings, I don't see the Excel export features. Also there is an option for Use Project settings, but this option is not selected by default. However all export settings are done at the project level. As I couldn't change the deafult use setting to Project for JSS, I've added the following properties to JSS under Workspace settings. net.sf.jasperreports.export.xls.one.page.per.sheet=truenet.sf.jasperreports.export.xls.remove.empty.space.between.rows=falsenet.sf.jasperreports.export.xls.remove.empty.space.between.columns=falsenet.sf.jasperreports.export.xls.white.page.background=truenet.sf.jasperreports.export.xls.detect.cell.type=truenet.sf.jasperreports.export.xls.ignore.graphics=falsenet.sf.jasperreports.export.xls.create.custom.palette=truenet.sf.jasperreports.export.xls.font.size.fix.enabled=falsenet.sf.jasperreports.export.xls.ignore.cell.background=falsenet.sf.jasperreports.export.xls.ignore.cell.border=false I appened the same in /webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties and restarted the services. But still the issue persists when I export to excel. e Please see the difference how it exports to excel from server and from JSS respectively. It happens not only with Chart. It happens even with the text field which are adjacent and the height is different.Please do advise Thanks sreeram

I've designed the report in Jaspersoft (5.6.1). When I upload it to server and export to excel, the cell height changes according to the next cell item. Assume there is text field of height 0.20 inches and next to it is a Chart of Height 5.20 Inches. When I export this design from studio, it works fine. But when I export to excel from JasperServer, the Text field cell height increases according to height of Chart. I'm sure I kept each field's position type to Fix realtive to Top and Strech type to No strech. Is there any special settings to be done on Server side too? FYI, I followed all tips for Excel export Thanks Sreeram

Hi Thanks for the reply. I managed to solve the issue by placing the static text above and below the image, so the image wouldn't move. Also I removed Frame which was surrounding the image. Thanks Sreeram

Hi, I've designed a Jasperreport using studio 5.6.1 which has got images. When I export to excel from Studio, it works fine. When I upload to the server and then export to excel (xls or xlsx) the Image postion moves down or up.This creates a extra row in excel and causing a alignment issue. Is there a way to lock the Image postion or is there any property to set at element level? Please advise Thanks SreeramP.S I couldn't share this jrxml, as this is strict policy posting code on forums. Sorry!!!! :(

Any help???http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/cry_smile.gif

Hi, No, couldn't do. As there are nearly 1000 projects. I couldn't assume how much a user will select as the input. http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/sad_smile.gif

Hi, Thanks for the reply. But my requirement is to pass the multiple input in same parameter. I couldn't acheive it using just the integer. Let me explain, the end user inputs by selecting multiple project name in the filter section of the report. These values have to be used together as collection type to get all the results in reports. Above solution is only for Single input. Is there any other way I could use for Multi input parameter instead of collection to acheive my requirement? Thanks Sreeram

Hi Kriplani, Thanks for your reply. Actually I'm trying for Multi value parameter as input. Could you please explain more on "I would suggest you use integer/string parameter and generate the report once for I1, next time for I2 and the third time for I3." as I couldn't follow?

I've designed a Main report which consists of following Sub reports S1S2The above subreports have been placed in Separate Group Headers. Both the subreports have input paramter P1 of type java.collection.util. This parameter was added to Main report as well with same name and Type. When I provide the following Inputs in P1 in Main report I1I2I3 I would expect For the Input I1, the both Subreports S1 followed by S2 should display. Then for input I2, both Subreports S1 followed by S2 should display.However, in my case Subreport S1 prints first all for inputs I1,I2,I3 and then Subreport S2 prints all for inputs I1, I2, I3. How do I get the subreports as I expected as above? P.S I'm using the Jaspersoft Studio 5.6.1 Thanks Sree

Hi, I've chart report which uses the parameter of Type Java.util.collection. When I try to use this chart at group band as subreport to the Main report with similar parameter of Type Java.util.collection, the chart value keep iterates within the group. For example, if the chart shows the value for L1 & L2 in two separate page. But when added to the Main report for the value L1, the subreport displays both L1 & L2 rather than just L1. Have anyone worked with passing collection parameter from main to Sub report? Please advise FYI, using Jaspersoft Studio 5.6.1 Thanks Sreeram

Hi Justine, How did you solve this issue, I'm also having the same issue? Thanks Sreeram

Hi all, I've designed the HTML chart using the oracle query which passes Single value paramater and it worked fine. I used the method of placing the HTML Chart in theSummary band and set the Evalution time to Now and it worked fine. Now I would like to show the same HTML chart for multi value Parameter. I would like to show the chart element for each project in each pdf page.Hence Logically I need to place the HTML chart at Detail band rather than the Summary band. But now it doesn't work and throws error "incrementing bidimensional dataset". Is there any work around. FYI, I'm using this Chart report as subreport to another main report. Jaspersoft studio version:5.6.1 final Please do help ASAP. Thanks, Sreeram <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Charts" pageWidth="200" pageHeight="275" orientation="Landscape" columnWidth="200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="c6523df6-0c5f-4728-87c2-57825f88fca3"> <property name="com.jaspersoft.studio.unit." value="inch" /> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel" /> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel" /> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel" /> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel" /> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel" /> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel" /> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel" /> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Dev DB Conn" /> <parameter name="param_month" class="java.lang.String" /> <parameter name="param_year" class="java.lang.String" /> <parameter name="param_project" class="java.util.Collection" /> <queryString language="SQL"> <![CDATA[sELECT i.id prid,c.INUSAGE,d.CURRUSAGE FROM project table i, custom table c where i.id = c.id and $X{IN,I.id,param_project}]]> </queryString> <field name="prid" class="java.math.BigDecimal" /> <field name="INUSAGE" class="java.math.BigDecimal" /> <field name="CURRUSAGE" class="java.math.BigDecimal" /> <summary> <band height="223"> <componentElement> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="3" width="190" height="220" uuid="0a0e6b98-2d59-453a-8642-3a65d4b30bb1"> <property name="local_mesure_unitwidth" value="inch" /> </reportElement> <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Column" evaluationGroup=""> <hc:chartSetting name="default"> <hc:chartProperty name="_showDataPoints"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="_showMeasureNameOnValueAxis"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.alignTicks"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.borderRadius"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.borderWidth"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.ignoreHiddenSeries"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.selectionMarkerFill"> <hc:propertyExpression> <![CDATA[new java.awt.Color(-1)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.shadow"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.spacingBottom"> <hc:propertyExpression> <![CDATA[new Integer(20)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.zoomType"> <hc:propertyExpression> <![CDATA["none"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="colors"> <hc:propertyExpression> <![CDATA[java.util.Arrays.asList("#779499","#C0D9DE","#8bbc21","#910000","#1aadce","#492970","#f28f43","#77a1e5","#c42525","#a6c96a","#C0D9DE")]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.enabled"> <hc:propertyExpression> <![CDATA[false]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.href"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.text"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.align"> <hc:propertyExpression> <![CDATA["center"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.borderRadius"> <hc:propertyExpression> <![CDATA[new Integer(5)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.enabled"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.floating"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.layout"> <hc:propertyExpression> <![CDATA["horizontal"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.lineHeight"> <hc:propertyExpression> <![CDATA[new Integer(30)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.margin"> <hc:propertyExpression> <![CDATA[new Integer(15)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.padding"> <hc:propertyExpression> <![CDATA[new Integer(8)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.symbolPadding"> <hc:propertyExpression> <![CDATA[new Integer(5)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.symbolWidth"> <hc:propertyExpression> <![CDATA[new Integer(30)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.verticalAlign"> <hc:propertyExpression> <![CDATA["bottom"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.x"> <hc:propertyExpression> <![CDATA[new Integer(10)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.y"> <hc:propertyExpression> <![CDATA[new Integer(10)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legened.itemStyle.fontSize" value="4" /> <hc:chartProperty name="plotOptions.series.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.dataLabels.enabled" value="true" /> <hc:chartProperty name="plotOptions.series.dataLabels.format" value="{point.y:,.0f}" /> <hc:chartProperty name="plotOptions.series.lineWidth"> <hc:propertyExpression> <![CDATA[new Integer(2)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.shadow"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.showInLegend"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.visible"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.align"> <hc:propertyExpression> <![CDATA["left"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.style.color"> <hc:propertyExpression> <![CDATA[new java.awt.Color(-4138530)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.text"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.verticalAlign"> <hc:propertyExpression> <![CDATA["top"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.enabled"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.shadow"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.labels.step"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.gridLineColor" value="'#FFFFFF'" /> <hc:chartProperty name="plotOptions.column.marker.enabled"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.title.text" value="" /> </hc:chartSetting> <multiAxisData> <multiAxisDataset /> <dataAxis axis="Rows"> <axisLevel name="InvName"> <labelExpression> <![CDATA[]]> </labelExpression> <axisLevelBucket class="java.lang.String"> <bucketExpression> <![CDATA[]]> </bucketExpression> </axisLevelBucket> </axisLevel> </dataAxis> <dataAxis axis="Columns" /> <multiAxisMeasure name="Initial Baseline" class="java.lang.Integer" calculation="Highest"> <labelExpression> <![CDATA["Initial Baseline"]]> </labelExpression> <valueExpression> <![CDATA[$F{INUSAGE}]]> </valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Current Baseline" class="java.lang.Integer" calculation="Highest"> <labelExpression> <![CDATA["Current Baseline"]]> </labelExpression> <valueExpression> <![CDATA[$F{CURRUSAGE}]]> </valueExpression> </multiAxisMeasure> </multiAxisData> <hc:series name="Current Baseline" /> <hc:series name="Initial Baseline" /> </hc:chart> </componentElement> </band> </summary></jasperReport>[/code]

Hi, I've Java code which will modify the width of Rectangle by modifying in jrxml. But how do I call the Java code when the report runs. Scriptlet didn't help much. Is there a way to call the Java/jar file to studio to dynamically change the width of text object? Any help will do Thanks Sreeram