mayuri.kadam
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by mayuri.kadam
-
-
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!
-
Using case when/if else in jasper dataset sql
in Products
Posted
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