ilikejasper

December 27, 2007

Hi

I have the following series but is not being displayed in the XY LineChart.

FISCAL_YEAR MONTH YTD

2,006.00 1.00 3.30

2,006.00 2.00 6.84

2,006.00 3.00 9.27

2,006.00 4.00 10.29

2,006.00 5.00 13.05

2,006.00 6.00 15.06

2,006.00 7.00 18.01

2,006.00 8.00 19.89

2,006.00 9.00 23.59

2,006.00 10.00 26.15

2,006.00 11.00 28.95

2,006.00 12.00 30.68

2,007.00 1.00 2.66

2,007.00 2.00 4.39

2,007.00 3.00 6.42

2,007.00 4.00 7.90

2,007.00 5.00 9.71

2,007.00 6.00 12.24

2,007.00 7.00 15.47

2,007.00 8.00 17.29

2,007.00 9.00 18.37

2,007.00 10.00 21.01

2,007.00 11.00 22.07

2,007.00 12.00 22.16

I am using the

$F{FISCAL_YEAR} as series exoression

$F{MONTH} as X value expression

$F{YTD} as Y value expression

any suggestion ???

why is this happening??

thanks

ilikejasper

December 22, 2007

hi

I want to create the Report styles in the master report and pass the styles to sub report so that i do not need to create the styles in the sub report. I am sure there must be the way to do this.

Any pointers are highly appreciated.

Thanks

ilike jasper

December 21, 2007

hi

As you have mentioned "The rectangle solutions would not work for HTML and XLS, where overlapping elements do not show up."

so how to make the solution work for html and xls

ilikejasper

December 21, 2007

Hi

I have attached the pdf.

I can use the frame but what about doing rows with alternate colors. For this again i have to use the rectangle.

Thanks

ilikejasper [file name=LatestInteractions.pdf size=1810]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/LatestInteractions.pdf[/file]

December 21, 2007

hi

I have attached Pdf file. I am coloring the alternate rows. At the same time i have used "Stretch with overflow" to expand the text of the textfield.Now if the text overflows then the rectagle below the textfield does not overfow to cover the background the complete row.

Have a look.

How can i cover the complete background

Thanks

ilikejasper

December 19, 2007

Hi

If i want to call the utlilty method in the label expression then how to do that.

thanks

ilikejasper

December 19, 2007

Hi

I found solution for this. You can also drop "percentage" from the library. It also has the evaluation time to auto.

thanks for the reply.

ilikejasper

December 19, 2007

Hi

I tried doing this in this label expression

if ( $F{QUALITY_IND}.equalsIgnoreCase( "R" )){ return "Risk";}

but it gives me error.

Can u please point me to some sample showing how to call the utility method.

This will help me lot.

thanks

ilikejasper

December 19, 2007

Hi

Thanks for the reply.

I was looking for the same thing.

Thanks

ilikejasper

December 19, 2007

Hi

I have data in the format

Region ytd

Asia 5,789,777.43

Australia 1,553,008.88

Europe 30,546,788.71

Japan 8,134,018.72

US 113,661,762.06

I want to display Asia and percentage.

percentage = 5,798,777.43/159,685,355.80(sum of all the columns)

In the report i have made a sum function which calculate the total and the other field variable which point to ytd column

I am displaying the records in the detail band.

I do not get the correct percentage for any column because the total in the detail for the first time is

5,789,777.43 in detail band. In the second loop it changes to (5,789,777.43+1,553,008.88)

IS their any way i can calculate the total before execution of the detail band so that i get correct percentages.

Your expertise is required.

Thanks

ilikejasper

December 19, 2007

Hi

I have data in the format

Region ytd

Asia 5,789,777.43

Australia 1,553,008.88

Europe 30,546,788.71

Japan 8,134,018.72

US 113,661,762.06

I want to display Asia and percentage.

percentage = 5,798,777.43/159,685,355.80(sum of all the columns)

In the report i have made a sum function which calculate the total and the other field variable which point to ytd column

I am displaying the records in the detail band.

I do not get the correct percentage for any column because the total in the detail for the first time is

5,789,777.43 in detail band. In the second loop it changes to (5,789,777.43+1,553,008.88)

IS their any way i can calculate the total before execution of the detail band so that i get correct percentages.

Your expertise is required.

Thanks

ilikejasper

December 18, 2007

Hi

I am displaying the piechart. In the label expresion i am trying to show the percentage.

My data is in the following format

Quality_ind fiscal_year ytd

NR 2007 698471.19

P 2007 562028.86

R 2007 19751415.09

I am calulating the total of the ytd column and displaying in label expression of pie chart for the test purpose but it doesnot represent the correct data.

Please help me out. I am real stuck on this.

Thanks in Advance.

Below is the .jrml file.

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="FormatClientCreditsByTradeClassification"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="280"

pageHeight="310"

columnWidth="280"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString><![CDATA[select decode(quality_ind,'NR','Non Risk','R','Risk', 'P','Priority') quality_ind, fiscal_year, sum(mtd_gross_sales_credit) as ytd

from fimis_datamart.v_sales_credit_mtd

where client_name like 'JP Morgan Chase & Co (P), USA'

and fiscal_year=2007 and month<=10

group by quality_ind, fiscal_year

order by quality_ind, fiscal_year]]></queryString>

</variable>

</band>

</background>

<title>

<reportElement

x="6"

y="32"

width="260"

height="260"

key="element-1"/>

</chartTitle>

</chartLegend>

</chart>

</dataset>

</sectionHyperlink>

</pieDataset>

<piePlot

isCircular="true" >

</piePlot>

</pieChart>

<reportElement

x="6"

y="-437"

width="126"

height="25"

key="staticText-1"/>

</textElement>

</staticText>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Thanks

ilikejasper

December 17, 2007

Hi

How can i display the data in the tabel format.I want to display line to show the rows and columns. I have attched an pdf file which shows the data but how should i put line for rows and columns.

thanks in advance

ilikejasper [file name=ClientCredit_USD_.pdf size=1537]

December 15, 2007

Hi

I want to chnage the value of the labels of pie chart at run time.

I am displaying the data in the PiChart.

I have the data in the form

QUAL_IND , GROSS

NR 789

P 415

R 4898

These are column names QUAL_IND , GROSS.

Now in the PieChrat Label i want to display

"Non Risk" instead of "N"

"Risk" instead of "R"

"Profit" instaed of "P"

I am using the class

public class PieChartCustomize extends JRAbstractChartCustomizer {

public void customize(JFreeChart chart, JRChart jasperChart)

{

System.out.println("Hello Wold " + getFieldValue("QUALITY_IND"));

}

When i run this I get the out put only "R"

Why i am not getting the output for the other two rows?

and how to change the labels.

Please help me.

ilikejasper.

December 14, 2007

Hi

I am also facing the same problem. did u get the answer to this?

Thanks

ilikejasper

December 8, 2007

Hi

I have records which are coming form the datasource. after the records are displayed i display the graph.but i am unable to set the location of the graph because i am not aware hom many records are coming form the database. If the records are more then it overlaps the chart and if it is less then it works fine.both the graph and the table records are being used as sub reports.

any pointers are highl appreciated.

Thanks

ilikejasper

December 8, 2007

Hi svenn

You are 100% correct and it worked. thanks a lot.

thanks

ilikejasper.

December 7, 2007

Hi

I have two independent query. These two query gives me two different results. But i want the results displayed in the same report. so i am creating master report and one subreport.

but when i run the master report i does not get the results for the sub report. though i am able to get the records for the sub report if i run it independently.

Please help me. I am new to iReport and jasper. I am struggling for two days.

Thanks

ilikejasper

Master jrml file

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="ReportDoc"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

</parameter>

</band>

</background>

<title>

</band>

</title>

<reportElement

x="61"

y="14"

width="361"

height="26"

key="subreport-1"/>

</subreport>

</band>

</pageHeader>

<reportElement

x="39"

y="3"

width="84"

height="19"

key="staticText-1"/>

</textElement>

</staticText>

<reportElement

x="140"

y="3"

width="100"

height="18"

key="textField"/>

</textElement>

</textField>

</band>

</columnHeader>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</lastPageFooter>

</band>

</summary>

</jasperReport>

subReport.jrml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="ClientCredit(USD)"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="250"

pageHeight="300"

columnWidth="190"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false"

isIgnorePagination="true">

<queryString><![CDATA[select client_name, fiscal_year,month, global_manacs as ProductName, sum(ytd_gross_sales_credit) as YTDGrossSalesCredit from sales_credit_ytd

where client_name = 'JP Morgan Chase & Co (P), USA'

and fiscal_year=2007 and month=11

group by client_name, fiscal_year, global_manacs, month

order by fiscal_year, month, global_manacs]]></queryString>

</band>

</background>

<title>

</band>

</title>

</band>

</pageHeader>

<reportElement

x="5"

y="30"

width="69"

height="17"

key="staticText-1"/>

</textElement>

</staticText>

<reportElement

x="81"

y="30"

width="58"

height="17"

key="staticText-2"/>

</textElement>

</staticText>

<reportElement

x="5"

y="0"

width="174"

height="19"

backcolor="#CCCCCC"

key="staticText-3"/>

</textElement>

</staticText>

</band>

</columnHeader>

<reportElement

x="5"

y="2"

width="69"

height="17"

key="textField"/>

</textElement>

</textField>

<reportElement

x="80"

y="3"

width="59"

height="18"

key="textField"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

Post edited by: ilikejasper, at: 2007/12/07 14:57

November 29, 2007

Hi

I have a web application in which user will have customize panel.He can chose the font, chart types,langauges. Is it possible to generate the jrml file having to format depending upon the user selection at runtime.

1.Is it possible to print the data in the bar chart/pie chart or any other chart depending upon the user choice.

2.Is it possible to show the print view of the document before printing.

3.Can i make a jrml file at runtime.Do we have any limitaion to this?

4.Can the client design the report at runtime and print is generated without creating any file like pdf.

5.Can i do report scheduling?

Please reply so that i can make the correct decison.If any lonks can be forwarde then it will be great.

Thanks

ilikejasper

November 27, 2007

Hi

I am looking to use this tool but i cannot find information to generate the charts and export in to the excel sheet.

I know JFreeChart can be used for creating charts but how to export these charts to the excel is missing.

Any pointers are highly appreciated

Thanks

ilikejasper

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 ilikejasper

Products

Explore