mayuri.kadam

got the answer: select case when (datatype=0) then "Unknown" when (datatype=1) then "Integer" when (datatype=2) then "Float" else "varchar" end Datatype_Df from sampleDB

Hi All, I am getting a very naive error, I have tried various SQL syntax. My backend DB is DB2. In my SQL I am trying to do somthing like this: select case when (datatype=0) then "Unknown" else when (datatype=1) then "Integer" else when (datatype=2) then "Float" else "varchar" end Datatype_Df from sampleDB; Please help me with this syntax here... Thanks!

Hi All, I am trying to build an application that requires me to be able to access all reports under the path : 'http://localhost:8080/jasperserver/rest_v2/reports/reports/myreports'. So basically I want to hit this link and fetch the names of all reports to display in my react application and then allow the report to download on click. Can someone help me understand how to access these files? Thanks!

Hello All, I am new to Jaspersoft studio. I am trying to create a report and I have followed the following steps: 1) Defined new data source 'SampleDataSource1'- Test connection successful! 2) Created new report - SampleReport1 usingdata adapter 'SampleDataSource1' 3) Added query and selected all fields: SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID","SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"FROM "SAMPLEVIEWS"."SVIEW"Note COLUMNRID is of type string and DATATYPE_DEFINED is Integer 4) Added a parameter 'dbdef' as java.lang.Integer and checked "IsForPrompting" 5) Modified the query to add the line: SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID","SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"FROM "SAMPLEVIEWS"."SVIEW"WHERE "IAVIEWS"."SVIEW"."DATATYPE_DEFINED" = $P{dbdef} 6) Added table to the report with query as: SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID","SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"FROM "SAMPLEVIEWS"."SVIEW" 7) For the table, in 'parameters map' section I added "$F{DATATYPE_DEFINED}.equals( $P{dbdef} )" Now I am trying to run and filter on DATATYPE_DEFINED column but I am getting an error: et.sf.jasperreports.engine.JRException: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.util.Mapat com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:537)at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:512)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:393)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.util.Mapat net.sf.jasperreports.engine.fill.JRFillSubreport.getParameterValues(JRFillSubreport.java:623)at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateParameterValues(JRFillSubreport.java:474)at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateParameterValues(FillTableSubreport.java:108)at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:454)at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateSubreport(FillTableSubreport.java:102)at net.sf.jasperreports.components.table.fill.FillTable.evaluate(FillTable.java:133)at net.sf.jasperreports.engine.fill.JRFillComponentElement.evaluate(JRFillComponentElement.java:110)at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:500)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2022)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)at java.lang.Thread.run(Thread.java:745) Any help is appreciated.Thankyou!

Hello Team, I noticed that jaspersoft server installs locally only. I want to have such a configuration that I create a data source connection and add certain users to be able to access that database schema from any machine as long as they have been provided access by me. And then they should also be able to view the linked reports on the web. How can I do that? Or which version of jaspersoft server should I use so that my reports and data sources can be accessible from any machine for appropriate users who have access?

Hello Team, I am new to Japser Server. What I am trying to do is create a report that will prompt the user to enter Datasourse connection properties like JDBC driver, dbname, URL, username and password etc, and then connect to that database. On that database it should run the SQL query I have defined in my parent report. Please help how I can go about implementing this in JasperStudio/Server. Thanks in advance!

Hi, How to create column group header? Please refer the image for reference. Basically I want to group certain columns and label them differently. "Column grup head 1" is just a label/colunm grup head that I want for 'column1' and 'column2' and so on. Thanks!