Jump to content
We've recently updated our Privacy Statement, available here ×

msaifee786

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

msaifee786's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. msaifee786
    Changing the jrxml parameter datatype from java.lang.String to java.sql.Timestamp seem to do the trick. Its now working, returning the correct dataset. djsiders, thanks very much for the help! I greatly appreciate it. Murtaza
  2. msaifee786
    Hi all, I'm using JasperServer 3.7.0 for Linux (on CentOS 5.0). I've just recently started using JasperServer so I'm a little inexperienced. I'm trying to set up a report that takes in 3 mandatory parameters (specifically, a start/end date and an ID hash). These parameters are used in the SQL statement that brings down the data for the report. However, whenever I specify the parameters and run the report, JasperServer returns that the report is empty. If I change the jrxml so that the dates and ID hash are hardcoded into the SQL, then it returns the correct data. For the parameters, I've specified the dates as a 'date' datatype and the ID hash as a 'text' datatype. I've tried to surround the ID hash with quotes in the SQL statement (returns an error because Jasper can't parse the $P{} syntax when quotes surround it) and entering the quotes when JasperServer asks for the parameters when running the report (no difference, still returns an empty report). I've double checked against the database from which I'm pulling the data, and data does exist, so in the correct case JasperServer should be returning something. I've also attached the jrxml as code in case the problem is with that (though, it was generate by iReport). Any idea what might be causing this, or how to solve the problem? Any help would be greatly appreciated. Thanks very much! Murtaza Code:<?xml version="1.0" encoding="UTF-8"?><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="geolucid_pub_countrystats" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="STARTDATE" class="java.lang.String"/> <parameter name="ENDDATE" class="java.lang.String"/> <parameter name="PWEBID" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[sELECT geo_lucid_hourly.p_website_id,pub_site_snap_daily.site_name,geo_lucid_hourly.country_code,geo_lucid_hourly.requests,geo_lucid_hourly.fills,geo_lucid_hourly.impressions,geo_lucid_hourly.p_micro_rev FROM geo_lucid_hourly JOIN pub_site_snap_daily ON (geo_lucid_hourly.p_website_id = pub_site_snap_daily.p_website_id AND DATE(geo_lucid_hourly.datetime) = pub_site_snap_daily.date) WHERE geo_lucid_hourly.datetime >= $P{STARTDATE} AND geo_lucid_hourly.datetime < $P{ENDDATE} AND geo_lucid_hourly.p_website_id = $P{PWEBID} GROUP BY p_website_id,country_code]]> </queryString> <field name="p_website_id" class="java.lang.String"/> <field name="site_name" class="java.lang.String"/> <field name="country_code" class="java.lang.String"/> <field name="requests" class="java.lang.Long"/> <field name="fills" class="java.lang.Long"/> <field name="impressions" class="java.lang.Long"/> <field name="p_micro_rev" class="java.lang.Long"/> <background> <band splitType="Stretch"/> </background> <title> <band height="44" splitType="Stretch"> <staticText> <reportElement x="195" y="0" width="463" height="32"/> <textElement textAlignment="Justified"> <font size="20" isBold="true"/> </textElement> <text><![CDATA[Geolucid Data by Publisher and Country]]></text> </staticText> </band> </title> <pageHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="289" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Publisher Website ID]]></text> </staticText> <staticText> <reportElement x="289" y="0" width="182" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Publisher Website Name]]></text> </staticText> <staticText> <reportElement x="471" y="0" width="61" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Country]]></text> </staticText> <staticText> <reportElement x="532" y="0" width="69" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Requests]]></text> </staticText> <staticText> <reportElement x="601" y="0" width="47" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Fills]]></text> </staticText> <staticText> <reportElement x="648" y="0" width="89" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[impressions]]></text> </staticText> <staticText> <reportElement x="737" y="0" width="59" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Revenue]]></text> </staticText> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band height="25" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="289" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{p_website_id}]]></textFieldExpression> </textField> <textField> <reportElement x="289" y="0" width="182" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{site_name}]]></textFieldExpression> </textField> <textField> <reportElement x="471" y="0" width="61" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{country_code}]]></textFieldExpression> </textField> <textField> <reportElement x="532" y="0" width="69" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{requests}]]></textFieldExpression> </textField> <textField> <reportElement x="601" y="0" width="47" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{fills}]]></textFieldExpression> </textField> <textField> <reportElement x="648" y="0" width="89" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{impressions}]]></textFieldExpression> </textField> <textField> <reportElement x="737" y="0" width="59" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{p_micro_rev}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="22" splitType="Stretch"> <textField> <reportElement x="676" y="2" width="80" height="20"/> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="756" y="2" width="40" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="45" splitType="Stretch"/> </summary></jasperReport>
  3. msaifee786
    Post Edited by msaifee786 at 08/02/2010 23:27
  4. msaifee786
    Hi all, I'm using JasperServer 3.7.0 for Linux (on CentOS 5.0). I've just recently started using JasperServer so I'm a little inexperienced. I'm trying to set up a report that takes in 3 mandatory parameters (specifically, a start/end date and an ID hash). These parameters are used in the SQL statement that brings down the data for the report. However, whenever I specify the parameters and run the report, JasperServer returns that the report is empty. If I change the jrxml so that the dates and ID hash are hardcoded into the SQL, then it returns the correct data. For the parameters, I've specified the dates as a 'date' datatype and the ID hash as a 'text' datatype. I've tried to surround the ID hash with quotes in the SQL statement (returns an error because Jasper can't parse the $P{} syntax when quotes surround it) and entering the quotes when JasperServer asks for the parameters when running the report (no difference, still returns an empty report). I've double checked against the database from which I'm pulling the data, and data does exist, so in the correct case JasperServer should be returning something. I've also attached the jrxml as code in case the problem is with that (though, it was generate by iReport). Any idea what might be causing this, or how to solve the problem? Any help would be greatly appreciated. Thanks very much! Murtaza Code:<?xml version="1.0" encoding="UTF-8"?><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="geolucid_pub_countrystats" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="STARTDATE" class="java.lang.String"/> <parameter name="ENDDATE" class="java.lang.String"/> <parameter name="PWEBID" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[sELECT geo_lucid_hourly.p_website_id,pub_site_snap_daily.site_name,geo_lucid_hourly.country_code,geo_lucid_hourly.requests,geo_lucid_hourly.fills,geo_lucid_hourly.impressions,geo_lucid_hourly.p_micro_rev FROM geo_lucid_hourly JOIN pub_site_snap_daily ON (geo_lucid_hourly.p_website_id = pub_site_snap_daily.p_website_id AND DATE(geo_lucid_hourly.datetime) = pub_site_snap_daily.date) WHERE geo_lucid_hourly.datetime >= $P{STARTDATE} AND geo_lucid_hourly.datetime < $P{ENDDATE} AND geo_lucid_hourly.p_website_id = $P{PWEBID} GROUP BY p_website_id,country_code]]> </queryString> <field name="p_website_id" class="java.lang.String"/> <field name="site_name" class="java.lang.String"/> <field name="country_code" class="java.lang.String"/> <field name="requests" class="java.lang.Long"/> <field name="fills" class="java.lang.Long"/> <field name="impressions" class="java.lang.Long"/> <field name="p_micro_rev" class="java.lang.Long"/> <background> <band splitType="Stretch"/> </background> <title> <band height="44" splitType="Stretch"> <staticText> <reportElement x="195" y="0" width="463" height="32"/> <textElement textAlignment="Justified"> <font size="20" isBold="true"/> </textElement> <text><![CDATA[Geolucid Data by Publisher and Country]]></text> </staticText> </band> </title> <pageHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="289" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Publisher Website ID]]></text> </staticText> <staticText> <reportElement x="289" y="0" width="182" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Publisher Website Name]]></text> </staticText> <staticText> <reportElement x="471" y="0" width="61" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Country]]></text> </staticText> <staticText> <reportElement x="532" y="0" width="69" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Requests]]></text> </staticText> <staticText> <reportElement x="601" y="0" width="47" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Fills]]></text> </staticText> <staticText> <reportElement x="648" y="0" width="89" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[impressions]]></text> </staticText> <staticText> <reportElement x="737" y="0" width="59" height="20"/> <textElement> <font size="12" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[Revenue]]></text> </staticText> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band height="25" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="289" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{p_website_id}]]></textFieldExpression> </textField> <textField> <reportElement x="289" y="0" width="182" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{site_name}]]></textFieldExpression> </textField> <textField> <reportElement x="471" y="0" width="61" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{country_code}]]></textFieldExpression> </textField> <textField> <reportElement x="532" y="0" width="69" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{requests}]]></textFieldExpression> </textField> <textField> <reportElement x="601" y="0" width="47" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{fills}]]></textFieldExpression> </textField> <textField> <reportElement x="648" y="0" width="89" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{impressions}]]></textFieldExpression> </textField> <textField> <reportElement x="737" y="0" width="59" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{p_micro_rev}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="22" splitType="Stretch"> <textField> <reportElement x="676" y="2" width="80" height="20"/> <textElement textAlignment="Right"/> <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="756" y="2" width="40" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="45" splitType="Stretch"/> </summary></jasperReport>
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore