k1234

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..

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..

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,

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

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

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.

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

hi ktalarico, I have not find any solution yet for this, if u find any solution please let me know. Thanks in advance..

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.

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>

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

No one knows the solution for this problem ??? This is the very important issue in my report...

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

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.

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 ?

NO one can solve this problem ? I need this very ungent......

hey no one knows the solution for this problem...??? Plz help if anyone can do this..

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)

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.

sorry ...here is the main report

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

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 ?

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

HI Everyone, In a report i hav a group called dummy , for this group i set isStartNewColumn="true" , like below <group name="dummy" isStartNewColumn="true"> <groupExpression><![CDATA[$F{DIET_ID}]]></groupExpression> </group> 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.............