rbojja

Hi, I had worked with jrxml files in my java. But i want to reduce the compilation time of jrxml file converted to .jasper file. I want to use directly the .jasper file instead of jrxml file (.jasper is generated using iReport) Can any one give me a solution for this? i had searched the forum but i didnt get any.

Hi, I have a requirement such that the total sum amount should be printed in words. ie if my sum amount is 125.00 $ then it should print as "One Hundred Twenty Five" How is this possible in jasper? or any ways of doing it in Oracle

Hii Am getting the below exception when try to run the report.what might be the issue.I tried all the possibilities?can any one help me out..its urgent plz Query: is as follows! SELECT XMRH.MR_NUM ,XMRL.MR_LINE_NUM ,XMRH.MR_DATE ,XP.NAME ,XMRH.LOCATION ,XMRH.EMP_NUM ,XMRL.MR_LINE_ID SEQ_NUM ,XI.SEGMENT1 ITEM_CODE ,XI.DESCRIPTION ,XI.PRIMARY_UNIT_OF_MEASURE UOM ,REQUESTED_QTY QTY ,XMRL.STATUS ,XE.FULL_NAME REQUESTED_BY , CB.EMP_NUM PREPARED_BY , UB.EMP_NUM APPROVED_BY FROM XXSEW_MR_REQ_HDR XMRH ,XXSEW_MR_REQ_LINES XMRL , XXSEW_LOCATIONS XL ,XXSEW_OA_LOC_USERS CB ,XXSEW_OA_LOC_USERS UB ,XXSEW_ITEMS XI ,XXSEW_PROJECTS XP ,XXSEW_EMPLOYEES XE WHERE XMRH.MR_NUM =XMRL.MR_NUM AND XMRH.REQUESTED_BY = XE.PERSON_ID AND XI.INVENTORY_ITEM_ID=XMRL.ITEM_ID AND XI.ORGANIZATION_CODE = XMRH.LOCATION AND XI.ORGANIZATION_CODE = XL.ORGANIZATION_CODE AND XMRL.CREATED_BY = CB.EMP_ID (+) AND XMRL.LAST_UPDATE_BY = UB.EMP_ID (+) AND XMRH.PROJECT_ID =XP.PROJECT_ID AND XMRL.STATUS = NVL($P{status},XMRL.STATUS) AND XMRH.MR_NUM LIKE NVL($P{mrNumber},XMRH.MR_NUM) AND XMRH.PROJECT_ID = NVL($P{projectId},XMRH.PROJECT_ID) AND XMRH.MR_DATE = NVL($P{mrDate},XMRH.MR_DATE) ORDER BY XMRH.MR_NUM, XMRL.MR_LINE_ID Error trace: net.sf.jasperreports.engine.JRException: Unable to get value for field 'MR_DATE' of class 'java.sql.Timestamp' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:314) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1438) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:895) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:798) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at com.osi.sew.model.ReportBean.materialRequisition(ReportBean.java:169) at com.osi.sew.servlet.InventoryReportServlet.doPost(InventoryReportServlet.java:72) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at oracle.lite.web.JupServlet.service(Unknown Source) at oracle.lite.web.AppServletHandler.handle(Unknown Source) at oracle.lite.web.JupApplication.handle(Unknown Source) at oracle.lite.web.JupApplication.service(Unknown Source) at oracle.lite.web.JupHandler.handle(Unknown Source) at oracle.lite.web.HTTPServer.process(Unknown Source) at oracle.lite.web.HTTPServer.handleRequest(Unknown Source) at oracle.lite.web.JupServer.handle(Unknown Source) at oracle.lite.web.SocketListener.process(Unknown Source) at oracle.lite.web.ClientListener.process(Unknown Source) at oracle.lite.web.SocketListener$ReqHandler.run(Unknown Source) Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at java.sql.Timestamp.valueOf(Unknown Source)

Hi All, When i try to open the pdf in jasper viewer the below expection is seen and the jviewer hangs/doesnt respond? Can any one tell me where the issue is? code: JasperPrint jasperPrint = JasperFillManager.fillReport(masterreport, parameters, conn); JasperViewer.viewReport(jasperPrint,false); Error log: 09/07/10 14:56:14 java.lang.NullPointerException 09/07/10 14:56:14 at net.sf.jasperreports.view.JasperViewer.exitForm(JasperViewer.java:239) 09/07/10 14:56:14 at net.sf.jasperreports.view.JasperViewer$1.windowClosing(JasperViewer.java:198) 09/07/10 14:56:14 at java.awt.Window.processWindowEvent(Window.java:1121) 09/07/10 14:56:14 at javax.swing.JFrame.processWindowEvent(JFrame.java:266) 09/07/10 14:56:14 at java.awt.Window.processEvent(Window.java:1079) 09/07/10 14:56:14 at java.awt.Component.dispatchEventImpl(Component.java:3615) 09/07/10 14:56:14 at java.awt.Container.dispatchEventImpl(Container.java:1627) 09/07/10 14:56:14 at java.awt.Window.dispatchEventImpl(Window.java) 09/07/10 14:56:14 at java.awt.Component.dispatchEvent(Component.java) 09/07/10 14:56:14 at java.awt.EventQueue.dispatchEvent(EventQueue.java:458) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146) 09/07/10 14:56:14 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) 09/07/10 14:56:14 at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

No one answered this question. Is this not possible?

HI all, I have a scenario where i need to show all the values of master report on the subreport. for example i am having scanCode values in detail band 1,2,3,4 in master report. i need to show the same values on subreport. i had tried with various option but all i see is the last value. I need to show all the values of 1,2,3,4. please its urgent

now its ok .... :)

it always displays only one image....not following the condition

got it .. under image tab - > image expression i added this expression...and got the result. $F{banner}.equals("Rogers & Hollands")?"C:\Receipts_Stores_New\AOLOGO-w-dia--Con_small.jpg":"C:\Receipts_Stores_New\RH-LOGO-w-dia--(2)_small.jpg"

hello, $F{StoreName}.equals("ABC")?"YourImageABC.jpg":"YourImageDEF.jpg" is what i tried.But issue is how to get the location of the image to display. I tried as $F{StoreName}.equals("ABC")?"C:\Images\YourImageABC.jpg":"C:\Images\YourImageDEF.jpg" ...but it is not displaying any image. it only prints the image name for the condition...am i missing any thing? should i try with image field or text field?

HI, i have a requirement to show the image/logo on the report. If i get store name as ABC then show an image/logo else if store name is some xyz show another image/logo. How should i display the image at the same location on the report based on the above condition?

HI i had queried the forum and read all the messages posted here. But i didnt udnerstand any...so is the reason i asked for tech help. can you elaborate me the webapp sample step by step and explain to me...and how to resolve the issue of client side printing. through out the forum there are many posts for the similar client side prinitng. but no one has explained how to implement it? can you please do the needful

HI i had developed few reports using jasper for my web application. The web application follows MVC. Now when i click on my print button the code executes and the report is printed on default printer of server. Till here its fine but now i want to print this print object on my client printer. How do we acheive this here? Please help me on fixing this issue. If any one have solved in their projects...plz

can we have a subreport inside a subreport?

Hi I want to print a line only when the page count is greater than one. If its a single page report then dont print the line.But when more than one page then only print the line. how do we acheive this on a line to print. thanks,

HI please see the two attachements. when the no of lines increases the reports is generated or spilled into two pages.But the issue is the line needs to be show at the bottom of first page. how can we acheive this to show the line at the bottom if the page line are exceeding? thanks

Hi I want to show the title info on each page. ie if the no of pages in the report exceeds more than one then for each next page i need to show the title info. how can this be done? I knew title info is printed only for the Starting of the page and only once :) but any other work around. thanks Post Edited by raghavender reddy at 12/03/08 04:24

Hi I am generating a report.The report has text "This merchandise is not covered under our “We Will” guarantee." This text should be printed based on a value.If the value is present then only display the text else dont print/display. values can be A,B,C,D either of these values are present then we should print the above text. (say OR condition) "A".equals($F{TRANSACTION_STATUS}) ? "This merchandise is not covered under our “We Will” guarantee" : "" and next is "B".equals($F{TRANSACTION_STATUS}) ? "This merchandise is not covered under our “We Will” guarantee" : "" and for c and d also. How do we check the same for multiple conditions. ? Post Edited by raghavender reddy at 12/01/08 06:29

Hi i need to display data as 3 rows / 3 cols. how do we display ? eg: value1 value2 value3 value4 value5 value6 select * from tabname; fetches me max of 6 records. so i need to display in the above format, how do we acheive this? i tired using report proeprties->colums-> horizontally /vertically either way...but didnt get the desired ouput.

Hi I need to print the value inside a box or rectangle. issue is when the value are repeating inside the rectangle the rectangle is also being repeated for each value. I need to restrict this? say i have a rectangle and inside the rectangle i palce a textfield.If the values of textfield are 10 then all the values should be printed inside the rectnagle. and if values increases then rectangle should automatically increase its size. can any one ever had come across this kind of req or issue...help me out plz...

Hi please see the attachment for design format of the report. Any suggestions /ideas for generating this kind of report. I tried using border for each textfield.But issue is i need border only the bottom.But using in detail band the border it repeating for each text field. how to over come this?

HI please see the attachment for my report. I need an closing line at the bottom of the report. How do we get this?

I am using JBOSS server.(jboss-4.0.0RC2 version) i had set the java.awt.headless= true on my linux classpath. help me plz..

Hi I need to print my reports on client side printer.For that i had set JasperViewer.viewReport( jasperPrint,false); to print on client side printer (user option to print on which ever printer he needs to) this is working on windows but not on linux machine. Please see the code in attachment .when i print on linux machine it says java.awt.headless exception. i had set this property ."java.awt.headless", "true"); in my code and also under classpath on my linux machine. i double checked to see if this property is missing on my linux box but its present. System.setProperty( but still i dont understand why do i get this exception of java.awt.headless. i tried searching the jaspe forums and tried all possible solutions. Its an production support issue. help me please. Thanks

Hi, I am using JRE 1.4