lukus

September 20, 2013

BTW the ling above is to the patched version of the jar

September 20, 2013

Wow! A year later and the problem is resolved!!

Replacing the js-mongodb-datasource-1.0.0.jar in my iReport app and for my server code did the trick!

August 21, 2013

Could you not use a 'Conditional Style' instead? I know its not quite as flexable as passing in a style using the java server but that way you could set up several conditional styles and then just pass in a single string type parameter to determine the style.

Posted August 19, 2013 · August 19, 2013

There are so many font questions on the forum I'm sorry if I've missed this on in my reading and duplicated it.

Set up

I have an jasper report template I'm working on in iReport. I have a font family Helvetica LT Std that I want to use 6 members of.
I have ensured that the fonts are installed on my machine. I have ensured that they are all TTF.
I have installed all six fonts by going into 'iReport>Preferences>Fonts>Install Fonts' (using a Mac).
I have set all the font details ('Bold, Italic, Bold Italic' etc) to the same .ttf file
I have checked to see if the fonts have been imported by checking 'Contents/Resources/ireport/ireport/fonts' and confirming that the fonts are present
I have then restarted iReport

I understand that ultimately these fonts will need to be packaged into a jar file for use on the server.

The Problem

I am not able to see my newly imported fonts in the font selection list. I can only see the main font family listed 'Helvetica LT Std'.

The Question

How do I correctly install a full family of fonts for use in a report where the font family member falls outside the usual 'Bold, Italic, Bold Italic'?

Thanks

September 24, 2012

Hi there,

I'm running a mongodb on amazon with authenticartion at a db level (not server level).

I'm running iReport Designer 4.7.0 with the MongoDbPlugin 0.14. When I ht the test button after setting up the "MongoDB Connection" I get a "...JRException: unauthorized"

I've been using iReport for a long time but have been forced to use a different (far inferiorior product) while I sort this out/wait for a change. I'm hoping this is all down to my own stupidity!

Cheers

Luke

September 20, 2012

Hi There,

I want to connect to a MongoDB that has authentication enabled on it. It seems that iReport does not support this (seems very strange that this is the case). I'm wondering if there is some sort of work around. I would be happy to write a class that returns the fully authenticated connection but I need to know if/how I could impliment this from within iReport.

Anyone got any tips or workarouds on how to get my mongodb playing nicely with iReport?

Cheers

July 13, 2009

Hi Matt,

thanks for helping me out with this one. Unfortunatly I just couldn't crack it. I took the rather drastic measure of scrapping CentOS and installing FreeBSD and using their Ports jdk16 install...

java version “1.6.0_03-p4″
Java SE Runtime Environment (build 1.6.0_03-p4-root_30_mar_2009_17_29-b00)
Java HotSpot Client VM (build 1.6.0_03-p4-root_30_mar_2009_17_29-b00, mixed mode)

This has worked a charm.

Once again thanks.

Cheers

July 13, 2009

Hi Teodord,

thanks for helping me out with this one. Unfortunatly I just couldn't crack it. I took the rather drastic measure of scrapping CentOS and installing FreeBSD and using their Ports jdk16 install...

java version “1.6.0_03-p4″
Java SE Runtime Environment (build 1.6.0_03-p4-root_30_mar_2009_17_29-b00)
Java HotSpot Client VM (build 1.6.0_03-p4-root_30_mar_2009_17_29-b00, mixed mode)

This has worked a charm.

Once again thanks.

Cheers

July 8, 2009

Hi Teodord,

From the FAQs you posted eariler --- "One thing to play attention to is making sure that the fonts set in the report via fontName attributes are actually available in the Java VM, because AWT silently uses the default font when a specific font cannot be loaded"

This seems to be the most likely scinario and including the font lib in the class path won't be a problem but I'm unsure of even what font the default fint is. I've tried explicity setting the font and including that in the classpath to no avail.

Cheers

July 8, 2009

I am able to get lebels when creating an RTF so this looks to be PDF specific...

July 8, 2009

OK I've had a crack using RTF output (I'm not set up to create HTML output at the mo without writing another class). The result was that I actually got the labels...?

July 8, 2009

Hi Matt,

thanks for the sugestions. This isn't an actual report but rather something I knocked up for testing so I haven't been too concerned with proper pratice ;)

I've put in a static query with the JRXML

Cheers

Code:

<?xml version="1.0" encoding="UTF-8"  ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport		 name="Action_Graph"		 columnCount="1"		 printOrder="Vertical"		 orientation="Portrait"		 pageWidth="595"		 pageHeight="842"		 columnWidth="535"		 columnSpacing="0"		 leftMargin="20"		 rightMargin="20"		 topMargin="20"		 bottomMargin="20"		 whenNoDataType="NoPages"		 isTitleNewPage="false"		 isSummaryNewPage="false">	<property name="ireport.scriptlethandling" value="0" />	<property name="ireport.encoding" value="UTF-8" />	<import value="java.util.*" />	<import value="net.sf.jasperreports.engine.*" />	<import value="net.sf.jasperreports.engine.data.*" />	<subDataset name="Piegraph" >		<queryString><![CDATA[sELECT 12 AS count, 'Missed' AS status		UNION		SELECT 45 AS count, 'Compleated' AS status		UNION		SELECT 16 AS count, 'Pending' AS status		UNION		SELECT 75 AS count, 'Actions' AS status		UNION		SELECT 62 AS count, 'Refused' AS status]]></queryString>		<field name="count" class="java.lang.Long"/>		<field name="status" class="java.lang.Integer"/>	</subDataset>	<queryString><![CDATA[sELECT '']]></queryString>		<background>			<band height="0"  isSplitAllowed="true" >			</band>		</background>		<title>			<band height="64"  isSplitAllowed="true" >			</band>		</title>		<pageHeader>			<band height="6"  isSplitAllowed="true" >			</band>		</pageHeader>		<columnHeader>			<band height="0"  isSplitAllowed="true" >			</band>		</columnHeader>		<detail>			<band height="0"  isSplitAllowed="true" >			</band>		</detail>		<columnFooter>			<band height="0"  isSplitAllowed="true" >			</band>		</columnFooter>		<pageFooter>			<band height="0"  isSplitAllowed="true" >			</band>		</pageFooter>		<summary>			<band height="337"  isSplitAllowed="true" >				<bar3DChart>					<chart  hyperlinkTarget="Self" >					<reportElement						x="16"						y="14"						width="515"						height="309"						key="element-1"/>					<box></box>						<chartLegend textColor="#000000" backgroundColor="#FFFFFF" >					</chartLegend>					</chart>					<categoryDataset>						<dataset >							<datasetRun subDataset="Piegraph">							</datasetRun>						</dataset>						<categorySeries>							<seriesExpression><![CDATA[$F{status}]]></seriesExpression>							<categoryExpression><![CDATA[$F{status}]]></categoryExpression>							<valueExpression><![CDATA[$F{count}]]></valueExpression>							<labelExpression><![CDATA["Status"]]></labelExpression>				<itemHyperlink >				</itemHyperlink>						</categorySeries>					</categoryDataset>					<bar3DPlot >						<plot />						<categoryAxisFormat>							<axisFormat >							</axisFormat>						</categoryAxisFormat>						<valueAxisFormat>							<axisFormat >							</axisFormat>						</valueAxisFormat>					</bar3DPlot>				</bar3DChart>			</band>		</summary></jasperReport>

July 8, 2009

Hi,

Apoligies. I'm not sure how I ended up posting an incomplete JRXML file. I've double checked and ensured that this one is correct. The connection is passed in at the time of launching.

I have yet to test with differing output but will do in the next couple of hours and post the results.

Cheers

Code:

Post Edited by lukus at 07/08/2009 22:44

July 8, 2009

Anyone got any suggestions on this? I'm willing to try almost anything...

July 8, 2009

If I were you I would pass it in as a string and then perform any casting that may need to be done in the actual report.

July 8, 2009

Or you could try this in the "Print When Expression" for the rows...

Code:

new Boolean(($V{REPORT_COUNT}.intValue() % 2) == 0)

July 7, 2009

Hi Teodord,

Thanks for your feedback.

Here is my JRXML... There is really very little going on here and I have left all the font settings as the default in iReport.

I did have a read of FAQs regarding the fonts and I will have a crack at explicitly packaging them up for reference and let you know how I go.

Cheers

Lukus

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="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">	<subDataset name="Piegraph">		<queryString>			<![CDATA[sELECT COUNT(h.id), h.statusFROM dheader hWHERE h.projectid = 179AND h.visitdate > '2009-06-01'GROUP BY h.status]]>		</queryString>		<field name="count" class="java.lang.Long">			<fieldDescription><![CDATA[]]></fieldDescription>		</field>		<field name="status" class="java.lang.Integer">			<fieldDescription><![CDATA[]]></fieldDescription>		</field>	</subDataset>	<queryString>		<![CDATA[]]>	</queryString>	<background>		<band splitType="Stretch"/>	</background>	<title>		<band height="64" splitType="Stretch"/>	</title>	<pageHeader>		<band height="6" splitType="Stretch"/>	</pageHeader>	<columnHeader>		<band splitType="Stretch"/>	</columnHeader>	<detail>		<band splitType="Stretch"/>	</detail>	<columnFooter>		<band splitType="Stretch"/>	</columnFooter>	<pageFooter>		<band splitType="Stretch"/>	</pageFooter>	<summary>		<band height="337" splitType="Stretch">			<bar3DChart>				<chart>					<reportElement x="16" y="14" width="515" height="309"/>					<chartTitle/>					<chartSubtitle/>					<chartLegend/>				</chart>				<categoryDataset>					<dataset>						<datasetRun subDataset="Piegraph"/>					</dataset>					<categorySeries>						<seriesExpression><![CDATA[$F{status}]]></seriesExpression>						<categoryExpression><![CDATA[$F{status}]]></categoryExpression>						<valueExpression><![CDATA[$F{count}]]></valueExpression>						<labelExpression><![CDATA["Status"]]></labelExpression>					</categorySeries>				</categoryDataset>				<bar3DPlot>					<plot/>					<categoryAxisFormat>						<axisFormat>							<labelFont/>							<tickLabelFont/>						</axisFormat>					</categoryAxisFormat>					<valueAxisFormat>						<axisFormat>							<labelFont/>							<tickLabelFont/>						</axisFormat>					</valueAxisFormat>				</bar3DPlot>			</bar3DChart>		</band>	</summary></jasperReport>

July 6, 2009

Does anyone have any idea on this? I could really use some help...

July 6, 2009

you could use a crosstab to show the table and just ensure the field is set to wrap.

July 6, 2009

You could always download the .zip (platform independent version) and run that. I know it may not be ideal but it will get you going.

July 5, 2009

Hi There,

I'm using a JasperFillManager.fillReport to create the report. To make this work I am passing in a hashmap.

eg.

Create the parameter in iReport or your XML doc (in this case 'ITEM_ID')

Map parameters = new HashMap();
parameters.put('ITEM_ID', '15846');
JasperFillManager.fillReport(jasperReport, parameters, dataSource);

When this is done your parameter should be available for use in your query at report launch time. You can reference it like this...

SELECT item, otheritemdetail

FROM items

WHERE id = $!P{ITEM_ID}

Be sure to include the '!' in the parameter reference or else it will enclose its value in "".

Hope this helps.

Code:

July 5, 2009

Hi There,

None of my graphs display any lables, ledgend or numbers. I've attached an example

I have been using ireport and jasperReports for a whle now and have just migrated all my reports fomr an old OSX 10.3 server to a new CentOS setup. As a result none of my PDF reports that use graphs now display any lables of any sort. I've upgraded all components from 3.0.0 libraries to 3.5.2 in an effort to get this fixed but to no avail.

I've even written a very simple report that just displays a bar graph. The graph renders fine but again no lables or anything. Not even any numbering on the axsis.

I am thinking that this is a system font issue maybe but have no idea as to how to solve it...?

Any help will be greatly apreciated.

I have already posted this on the 'JasperReports Discussion/Help' but have had no responce over the last 3 or 4 days so apoligies if you have already read this...

Cheers

Post Edited by lukus at 07/05/2009 23:35

July 2, 2009

Hi There,

I have been using ireport and jasperReports for a whle now and have just migrated all my reports fomr an old OSX 10.3 server to a new CentOS setup. As a result none of my PDF reports that use graphs now display any lables of any sort. I've upgraded all components from 3.0.0 to 3.5.2 in aneffort to get this fixed but to no avail.

I've even written a very simple report that just displays a bar graph. The graph renders fine but again no lables or anything. Not even any numbering on the axsis.

I am thinking that this is a system font issue maybe but have no idea as to how to solve it.

I've attached a copy of what I'm getting.

Any help will be greatly apreciated.

Cheers

July 2, 2009

Hi I found that the best way to do this was with my own class. I used the awt Toolkit to create the image from a bit stream, then used MediaTracker to load it and pass it to a BufferedImage where its resized and drawn on a Graphics object. The Graphics object is then returned. The class is invoked in jasper report.

Hope this gets you started

November 11, 2008

Hi fc_rba,

Sounds like your parameters are not being passed correcty. How are you passing them in? They need to be passed as a hashmap to the JasperFillManager.fillReport.

Cheers

Lukus

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by lukus

Products

Explore