k1234

September 27, 2011

Thank you for the response.

We have set the Expression class to java.lang.String

Its a data base column of type varchar(its a numeric value - Varchar data type in DB) .

We have taken String in report for this field, When we export to excel,,its getting converted in to a number and shows in exponential format..

Kindly give some inputs..

September 26, 2011

Hi Everyone,

Can anybody give some suggestion on this.. This is a very urgent requirement to my client.

Please help in this regard, Any help would be greatly appreciated..

September 21, 2011

To create the report xml file we are using iReport tool.

But we are facing problem while exporting report to Excel format.We are getting one field in exponential format. We tried using TO_CHAR in SQL query, but not able to resolve problem.

For eg. we have SQL query as follows :

select column1 from xyz

column1 is containing values in format 11581000029014400

but when report is exported to excel, value in cell is shown in exponential format.(Formula bar in excel show 11581000029014400 ).

Kindly provide a solution to remove exponential format, and show value in proper number format in excel report

Thanks in advance,

May 16, 2011

Hi Everyone,

In a report i tried to put

"<style forecolor ='red' isBold='true' pdfFontName='Monotype Corsiva'>"+"PHARMACY"+"</style>"

This font shows 'Monotype Corsiva' in .doc, .xls. But in PDF format it s not showing in font 'Monotype Corsiva'.

if pdfFontName='Times-Bold' (any font which shows in pdfFontName dropdown we give here in style it works else it wont work.) then it works well in PDF too.

I am using iReport 3.1.4.

Any Help would be appreciated..

Thanks,

Keerthi

Code:

Post Edited by k1234 at 05/16/2011 09:58

April 29, 2011

Hello Everyone,

The same issue i am facing in my report.

Can anybody help in this regard ? Its an urgent one..

Any Help Teodor?

Any suggestions would be appreciated.

-Keerthi

October 7, 2009

Hi Everyone,

I have a report includes a crosstab, in crosstab i use 1 row group.

So, my need is to show the group count , i have 10 groups

(i did order by group_name in my query) .

for ex :

S.No. Group_Name

1 G1

2 G2

up to S.No 10 and Group_Name G10.

How i could i achieve this in cross tab?

Any help would be greatly appreciated.

Thanks in advance.

July 24, 2009

Can u attach the jrxml file, i am not clear about your problem in report.

Post Edited by k1234 at 07/24/2009 06:22

July 23, 2009

hi ktalarico,

I have not find any solution yet for this, if u find any solution please let me know.

Thanks in advance..

July 23, 2009

Hi everyone,

even i have come across this problem, and not yet got any solution for this. If any one can help in this will be appreciated.

Thanks in advance.

July 23, 2009

hi dgiulian,

Please check out the code, you wrote that the pen stuff is not working with u, but this should work fine.

If it doesn't work then use 4 lines around the textfield, but this may give u problem when the text field is stretched dynamically. Just try out once.

Thanks.

Code:

			<textField>				<reportElement x="291" y="0" width="128" height="20"/>				<box topPadding="1" leftPadding="1" bottomPadding="1" rightPadding="1">					<topPen lineWidth="0.5" lineStyle="Solid"/>					<leftPen lineWidth="0.5" lineStyle="Solid"/>					<bottomPen lineWidth="0.5" lineStyle="Solid"/>					<rightPen lineWidth="0.5" lineStyle="Solid"/>				</box>				<textElement textAlignment="Center">					<font size="12"/>				</textElement>				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{eid}]]></textFieldExpression>			</textField>

July 23, 2009

hi Yogaraj,

I can give u one simple example,
say there is a parameter called "OFFICE_ID", If u dont want to display one static text in your report when this "OFFICE_ID" parameter is null, Then do the following..

1. In printWhenExpression give this expression

            new Boolean($P{OFFICE_ID}==null) and also

           Set RemoveLineWhenBlank is true.

The Code should be like the following,

<staticText>
                    <reportElement x="196" y="0" width="100" height="20" isRemoveLineWhenBlank="true">
                          <printWhenExpression><![CDATA[new Boolean($P{OFFICE_ID}==null)]]>     </printWhenExpression>
                    </reportElement>
                  <textElement/>
                    <text><![CDATA[static text]]></text>
   </staticText>

Please try out this.

Thanks,
Keerthi

July 1, 2009

No one knows the solution for this problem ???

This is the very important issue in my report...

July 1, 2009

Hi Everone,

In my report i am using 2 Columns and with a single group.

i set for group Start on a new column = true

then i get the page break for each 2 columns....What i shld set to overcome this page break problem...

This is very urgent ..............Please if any one can help ASAP will be appreciated..

i have added my jrxml file and also PDF shows the page break..

Thanks in Advance...

Post Edited by k1234 at 07/01/2009 10:09

April 23, 2009

When i try to create row groups it gives the first created group variable not found.

For Eg :

I first create G1 and it works fine, When i Create a 2nd Group it gives me $V{G1} not found.

Y it is giving this error.

April 23, 2009

Hi Lucian,

Thanks much for the reply.......

AS u said to use single cross tab, I need One Row group and 3 col groups.

I need to have 3 measures too for the diff col groups.

How to take 3 measures ?

The problem while creating the measure is, while dragging cross tab on to the report designer pane i can give only one measure right, so after crosstab is done, am trying to add a measure again.

How to take measures ?

April 20, 2009

NO one can solve this problem ?

I need this very ungent......

April 17, 2009

April 6, 2009

hey no one knows the solution for this problem...???

Plz help if anyone can do this..

March 31, 2009

Hi Everyone,

I have got a problem when i open my iReport and trying to open a template is gives me this exception. I trie after restarting my sys also,,,the same thing repeats.

Please can any one solve this problem..That would be greatly appreciated...

the following is the error........

java.lang.IllegalArgumentException: Called DataObject.find on null
    at org.openide.loaders.DataObject.find(DataObject.java:474)
    at org.openide.loaders.DataFolder.findFolder(DataFolder.java:515)
    at com.jaspersoft.ireport.designer.standalone.menu.NewReportAction.performAction(NewReportAction.java:47)
    at com.jaspersoft.ireport.designer.standalone.menu.NewReportAction$1.actionPerformed(NewReportAction.java:112)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.AbstractButton.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
[catch] at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

March 12, 2009

hi i tried in both the ways...but that didn't reach my requirement ....

can anyone help in this?...or any other way of doing this...that would be really appreciated.

March 5, 2009

sorry ...here is the main report

March 4, 2009

yes see the second report (master report ). the file name is Nurses_Daily_Register.jrxml.

subreport is Nurses_Daily_Reg_sub.jrxml.

Post Edited by smiley k at 03/04/09 12:36

March 4, 2009

this is a subreport am using in another report so the width am using is less(only for 2 columns). As the height of my report is more than the field height and band height.....y can't i get the result in the first page...is this not possible ?

March 4, 2009

Hi,

Thanks much for the response, i tried with the change u asked to make. But again the result is same.

I want to display the result in the first page as i hav the page height sufficient for my result.

Thanks in advance..

Post Edited by smiley k at 03/04/09 06:35

March 3, 2009

HI Everyone,

In a report i hav a group called dummy , for this group i set isStartNewColumn="true" , like below

in the group detail i put a field ( $F{DIET_NAME} ), it returns 3 values from the DB.

so the first 2 returned values are getting dispalyed in the first page and the 3 rd record is diaplayed on the 2nd page even though the page height is more than the detail band height.

Here i want to display the 3 rd recod also in the first page itself below the first 2 records. How to set this ? the version of iReports which i am using is 3.1.4.

Please see the attchment of jrxml file.

Any help would be greatful.............

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by k1234

Products

Explore