marianela

Please!!!! I really need to solve this issue... somebody? is my explanation clear? do I need to explain my self better??? Please... :S Marianela

Sorry... I can't attached the image.. Post edited by: marianela, at: 2008/05/21 21:35

Hi everyone¡¡ I'm facin a similar problen in my web app. I used to use Ireports 1.2.7 (JR same version) to export my reports to PDF or XLS files. 2 weeks ago, we decide to upgrade the tool to Ireports 2.0.2; I change all the necesary jars in my classpath; but now I'm facing a big problem: Since that change, my xls reports are not as cool as they used to be (with my old version of IR), now it seems that my app just ignore all the sentences where I try to set the parameters to export (like: IS_WHITE_PAGE_BACKGROUND) so my reports looks like the image attached. Here is a part of my code: JasperPrint jasperPrint = JasperFillManager.fillReport(new FileInputStream(reportFile), parameters, conn); JRXlsExporter xlsExporter = new JRXlsExporter(); xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, outFileName); xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); xlsExporter.exportReport(); What am I doing wrong?? Why the export parameters are ignore with the upgrade?? Pleaseeeee... I relly need help... I'm desperate... Thanks a lot... Marianela Post edited by: marianela, at: 2008/05/21 21:29 Post edited by: marianela, at: 2008/05/21 21:31

Hi everyone¡¡¡ I'm facing the same issue here. I need to show an amount in words in my report.... Can anyone guide in order to achive this??? I really have no clue.... Thanks a lot in advanced... Regards Marianela ;)

Hi everyone¡¡ I'm facing the same problem that you were talking about here... I was trying to understand what to do in order to call a StoredProcedure from Oracle that returns a cursor with a lot of rows to display in the report...but sadly I'm so confused that I really lost track here.. Please.... Does anyone can provide me the steps to follow to achieve this requirement? Pleaseee¡¡¡ I really need help... Thanks a lot in advanced... Regards for everyone... Marianela :S

Hi hmehta, Did you find a solution?? I'm facing the same requirement here... If you have a solution, Could you please help me??? Thanks a lot in advanced.. Regards, Marianela ;)

Hi nairsunil and everyone¡¡ I'm facing the same problem here, but I could find a solution in the forum.... If anyone has a sugestion or something, please let me know...I really need to achive this.. Thanks a lot in advanced.. Regards, Marianela

I'm facing the same situation here¡¡ I need to achieve an hyperlink to generate a new report passing a Parameter. Any idea how to do that??? Any suggestion, help or something will be really appreciated... Thanks a lot in advance... Regards, Marianela ;)

Hi aniruddh4u, Thanks a lot for your awswer, but I'm still having my problem... I decide to look for another way to achieve what I need. Thanks a lot again... Regards, Marianela ;)

Hi cHaOs667, Thanks a lot for your answer... I tried use your idea but I obtain the following error... Code:it.businesslogic.ireport.ReportClassLoader@14f1544 net.sf.jasperreports.engine.JRException:Â ErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂTheÂoperatorÂ!ÂisÂundefinedÂforÂtheÂargumentÂtype(s)Â int valueÂ=Â(java.lang.Boolean)(newÂBoolean(!((java.lang.Integer)variable_SubrptCount.getValue()).intValue()Â==Â0)); ...ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 3Âerrors ... ÂÂÂÂ Any suggestion??? anyone??? Pleaseeeee, I really need help. Thanks in advanced, Regards, Marianela ;) Post edited by: marianela, at: 2007/03/28 16:17

Hi, I'm facing the same problem here, Did you ever found a soolution for this??? If so, Could you please share it with me???? Thanks a lot in advenced, I will really appreciate your post... Regards, Marianela

Hi everyone¡¡ Sorry to bother you with this (apparently silly) problem, but I hope some body can help me... I have a report that has a group and in the detail band has a subreport. What I want at first (and already achieve) is to return the REPORT_COUNT from the subreport to master report. Now that I have that variable in my master report, I want to use it in an expresion that let me not print the groupheader if there is no data return by the subreport. I think that maybe this expreesion should work: Code:( $V{SubrptCount}.intValue()==0 ? Boolean.FALSE : Boolean.TRUE )But I was wrong.. :( Then I think that could be something like... Code:[code]new java.lang.Boolean($V{SubrptCount}.intValue()!=0)But this didn't work either.. I don't understand what is the problem, but when I use any of those espression it oly works with some records..It's like some numbers (167,133,etc) are taking like 0 and some 0 are taking like others...:blink: I know this sound a little confuse...but this is my problem... Pleaseee I really need help..Anything will be appreciate Marianela

My problem was actually in my query, I was passing the parameters correctly. Well I fix my problem... Thanks a lot¡¡¡ Regards, Marianela ;)

Hi, Sorry to bother you, but I'm facing the same problem...Could you please tell me if you solved it?? Thanks a lot, i really appreciate your attention... Regards, Marianela ;)

Hi¡ The samples folder is in the jasperreports file, not in the ireports file. For example,in my case I have the file in: jasperreports-1.2.7demosamples That means that have to download JasperReports (if you don't have it yet) and you will obtain the samples file. I hope this helps. Regards, Marianela ;)

martynhiemstra, Thanks a lot for your answer, I already find the solution. I found it here, http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=21194#21194 I hope this helps to others, Regards, Marianela ;)

The reason I want to set the PrintWhenExpression is because I have some other fields in my detail band beside the subreport. So don't want to print those field when my subreport doesn't have any records to print. I attach a document where you can see how my report looks now. If you watch carefully you can notice that the second row Cliente: 68-Atlantel Inc doesn't have any rows from the subreport, so in this case that line shouldn't be print... I don't know if I explain myself clearly,but I hope somebody can help me. Thanks a lot in advenced, Regards Marianela ;) [file name=ReportView.doc size=77312]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ReportView.doc[/file] Post edited by: marianela, at: 2007/03/09 12:02

Hi everyone¡¡¡ Sorry to butter you all with this (silly) problem... I'm using a subreport that is include in my master report (of course...), I'm passing the REPORT_COUNT variable to the master report...everything works really nice until now. My problem is that, now that I have that variable in my master report, I need to use it in order to decide if my detail band is going to print or not (PrintWhenExpression). The problem that I'm facing is that the value of my variable is null when my subreport doesn't have any data; so I don't know what is suppose to the my expresion in the PrintWhenExpression of my detail...I was thinking maybe something like: Code:new java.lang.Boolean($V{Condicion}.intValue() > 0)But it doesn't work at all... :blink: I really don't know what to do,pleaseeeee any help will be appreciate. Thanks in advanced, Regards, Marianela ;) P.S. I hope I explain my self clearly, but If some body need more detail please tell me I will be more than happy to provide them.... Post edited by: marianela, at: 2007/03/08 19:49

There is a very good sample that shows you how to do that. Is in the jasperreports file, jasperreports-x.x.xdemosamplessubreport Take a look of that sample, I think that could help you a lot. I hope this helps. Best luck, Regards, Marianela ;)

Hi senthil_teen, I'm facing the same issue as you, if is not much to ask... Could you tell how did you solve this problem??? I will really appreciate your help, thanks a lot in advance. Have a nice day, Regards, Marianela ;)

Hi¡¡ I'm facing the same problem here, Could you (or anyone else) please tell me how did you solve your problem??? Any help will be appreciate, Thanks a lot in advance, Regards, Marianela ;)

Hi everyone¡¡¡ I have a little problem, I need to create some thing like the .doc that I attach. I mean, that I need to create several crosstabs grouping by client... Can I do that? Can Ireports let me do that? How can I achieve that kind of report? Pleaseeee, any help will be appreciate... Thanks in advanced, Regards, Marianela, ;) [file name=Format_Report.doc size=58368]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Format_Report.doc[/file]

Hi everyone¡¡¡ I have a big problem, I'm using IR y JR 1.2.7 and I need to create a report that shows some fields like a matrix, I mean... cli-per/PERIOD/TOTAL CLIENT/Data/xxx TOTAL/XXX/xxx Something like that (something like a crosstab)...I already try using crosstabs but the problem is that I need to do some operations with the Data base on some conditions :( . I really don't know what to do, I really need help. Is there a way to manipulate the display data in a crosstab? OR Is there another way to achieve a matrix report? Please¡¡¡ I really need Help Thanks in advanced, regards to all... Marianela ;)

Please¡¡¡??? Somebody¡¡¡??? I really need to achieve this.... :(

Hi all¡¡ i'm trying to use this query (Ireport 1.2.7): Code: ... where (fac.id_cliente = $P{p_cliente} or $P{p_cliente} = 0) and (srv.id_serv_gen = $P{p_servicio} or $P{p_servicio} = 0) and fac.fecha_caducidad >= to_date($P{p_vencini},'dd-MM-yyyy') and fac.fecha_caducidad <= to_date($P{p_vencfin},'dd-MM-yyyy') and sysdate > fac.fecha_caducidad and fac.factura_pagada in ('N','P') ... But I'm still getting an ORA-01858: a non-numeric character was found where a numeric was expected error. I don't understand where is my error¡¡¡ Please, if somebody could point to me the error or could explain me why I can't run this query, I will be very grateful :) Thanks alot in advanced... Regards, Marianela ;) Post edited by: marianela, at: 2007/02/15 11:42