zsy2053
-
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 zsy2053
-
-
-
-
-
I need to display the jasper report in webpage with parameter panel. I searched a lot of materials online, but they don't work to me. So, could anyone help me to display my report in web-page with parameter panel? the XML file for my report is as follow.
<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 6.1.0 --><!-- 2015-06-25T02:10:23 --><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="Blank_A4_2" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f63b2357-ec93-4888-9301-cc151fdd7756"><property name="com.jaspersoft.studio.data.defaultdataadapter" value="NewDataAdapter "/><parameter name="startdate" class="java.sql.Date"><parameterDescription><![CDATA[Please select start date]]></parameterDescription></parameter><parameter name="starttime" class="java.sql.Time"><parameterDescription><![CDATA[Please select start time]]></parameterDescription></parameter><parameter name="enddate" class="java.sql.Date"><parameterDescription><![CDATA[Please select end date]]></parameterDescription></parameter><parameter name="endtime" class="java.sql.Time"><parameterDescription><![CDATA[Please select end time]]></parameterDescription></parameter><queryString><![CDATA[sELECT count(distinct ttc.vehicle_id) as vc,ttc.routeTag,ttc_routes.title,ttc.dateTimeFROM ttcINNER JOIN ttc_routes ON ttc.routeTag = ttc_routes.routeTagWHERE ttc.dateTime >= TIMESTAMP($P{startdate}, $P{starttime}) and ttc.dateTime <= TIMESTAMP($P{enddate}, $P{endtime})GROUP BY ttc_routes.titleorder by vc desclimit 10]]></queryString><field name="vc" class="java.lang.Long"/><field name="routeTag" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><field name="title" class="java.lang.String"><fieldDescription><![CDATA[]]></fieldDescription></field><field name="dateTime" class="java.sql.Timestamp"><fieldDescription><![CDATA[]]></fieldDescription></field><background><band splitType="Stretch"/></background><title><band height="252" splitType="Stretch"><barChart><chart evaluationTime="Report"><reportElement x="227" y="52" width="200" height="200" uuid="ba244296-4247-4400-b20b-110dc34fa405"/><chartTitle/><chartSubtitle/><chartLegend/></chart><categoryDataset><categorySeries><seriesExpression><![CDATA["SERIES 1"]]></seriesExpression><categoryExpression><![CDATA[$F{title}]]></categoryExpression><valueExpression><![CDATA[$F{vc}]]></valueExpression></categorySeries></categoryDataset><barPlot><plot/><itemLabel/><categoryAxisFormat><axisFormat/></categoryAxisFormat><valueAxisFormat><axisFormat/></valueAxisFormat></barPlot></barChart></band></title><pageHeader><band height="35" splitType="Stretch"/></pageHeader><columnHeader><band height="61" splitType="Stretch"/></columnHeader><detail><band height="125" splitType="Stretch"/></detail><columnFooter><band height="45" splitType="Stretch"/></columnFooter><pageFooter><band height="54" splitType="Stretch"/></pageFooter><summary><band height="42" splitType="Stretch"/></summary></jasperReport> -
I met a trouble that I need to migrate my BIRT report into Jasper report, could anyone tell me how to do that?
-
Hello, I'm using jasper studio right now, and I want to create parameter that users can use to filter the data. For example, if a user want to see the number of buses from 2015/6/6 12:00:00 to 2015/6/12 13:00:00, he can just type the date and time on the page, then the corresponding data will be displayed. How can I do that, I know I can use BIRT to achieve this purpose, in BIRT, I can use a contional SQL like:
select count(distinct ttc.vehicle_id) as vc,ttc.routeTag,ttc_routes.title,ttc.dateTimefrom ttcINNER JOIN ttc_routes ON ttc.routeTag = ttc_routes.routeTagWHERE ttc.dateTime >= TIMESTAMP(?,?) and ttc.dateTime <= TIMESTAMP(?,?)GROUP BY ttc_routes.titleorder by vc desclimit 10Then, I can set the parameter to control the time range. Could anyone tell me how can I do the same thing in Jasper?
how to fix the 404 error after installing tomcat
in Products
Posted
I'm trying to install the jasper server in my computer. But, after the installation (the installation process is fine), I can't open the web page of the server. It always show the following error.
and I also attached the log of tomcat