Jump to content
We've recently updated our Privacy Statement, available here ×

marianela

Members
 View Profile  See their activity

  • Posts

    43

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by marianela

    Reports in XLS (Excel) are not as cool as PDF ones

    in Products

    Posted

    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

    stored procedures

    in Products

    Posted

    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

    Drill Down / Sub reports using Jasper

    in Products

    Posted

    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

    Print when expression problem

    in Products

    Posted

    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

    Print when expression problem

    in Products

    Posted

    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

    samples/Demo

    in Products

    Posted

    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

    ;)

    REPORT_COUNT issue

    in Products

    Posted

    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

    REPORT_COUNT issue

    in Products

    Posted

    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

    Crosstab doubt

    in Products

    Posted

    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]

    Report like a matrix

    in Products

    Posted

    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

    ;)

    Problem with Date parameters

    in Products

    Posted

    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

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore