giobby

Hi everybody, i'm working with iReport 2.0.2. i'm trying to export my report in excel format but i find some troubles in my report formattation. I have some subreports in the Summary band; i want to print all the detail in the first sheet and the subreports in the second sheet, is it possible? thank you!! Giovanni ...La puissance est rien sans controle...

Hi everybody, i'll try to explain what i'm trying to do and what is the problem with iReport2.0.2: i have a "master report" which contains , in the summary band, two subreports. the subreports are divided by a page break. in the "report properties" of the master report i've chekked the property "print subreports in new page". in this way each subreport is printed in a new page. I have to put the page number in every page of the report (also in the pages of the subreports). the first time i've printed it in the summary band of the main report before each subreport but , if the report has more than one page, it doesn't work. Now i'm trying to get the number of pages passing to the first subreport the pages of the main report, adding the number of pages in the first subreport with a variable and retrieving it in a variable. it's ok, i can also print the correct number of pages returned from the first subreport after it. now i would like to pass this number to the second Subreport but it doesn't works. i've created a new parameter for the second subreport and i've tried to pass first a variable and then another parameter from the mai report but it doesn't work. is there an easier way to have the number of page in subreports? if not, what is the mistake in my way? In the attachment the source of my report and subreports Thank you ... Giovanni ...La puissance est rien sans controle...

Hi everybody. i have some problems exporting my report in Xls format. when i try to generate a xls file the report present the same PDF formattation. I see the same division in page and there's a page Header every 30 rows (like the page division of Pdf file formattation). The entire report is printed in the first sheet (and that's correct for me), but i wuold like to have one page header and all the detail withouth interruptions. I've changed the page size in iReport and the rows printed without interruptions are more but this change probably will destroy my Pdf formattation. Is there a way to force all the entries in a xls file withouth page formattation? Thank you!

Hi gcameo, if i've have understand your problem (i'm not very able with english...) if you want to show only the dataset (recordset) of your subrpt you should modify your subrpt making visible only the detail band. hope this help, bye Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/30/2009 10:03

hi javax_slr, i've tried to compile yor main rpt and i met the same exception. i solved the problem removing by the xml code this import: javax_slr Wrote: <...> <import value="com.cadence.mdv.reporting.ReportUtilities" /> </...> i don't know why you have to use this package but in all my jrxml files the import of the packages is always the same: <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> and i define the package that i need to use in iReport (options->classpath) hope this help you, bye

hi guys if i've correctly understand the matter it works with this expression: new Double($V{delta}.doubleValue() > 0.0 ? 1.0 : 0.0) my english is too scholastic, if this is not what you need can you explain me what you have to do in an easier way? Post Edited by giobby at 11/25/2009 10:36 Post Edited by giobby at 11/25/2009 10:46

i didn't unterstand that you're working with JRDataSourceProvider... this is another thing! i'm working in theese weeks on theese kind of data source but not on iReport (that i use only to read the fields from the dataSourceProvider and to pass the relative sub rpt already filled ) but with java app. I can help you only in this case... sorry Giovanni ...La puissance est rien sans controle...

just 2 question, Stig. what kind of datasource are you using to fill the rpt? A db connection? Giovanni ...La puissance est rien sans controle...

hi Stig i've tried to create the rpt by the xml code that you've posted and it works (two times to be sure) the only 2 changes that i've done are 1- to set, in the sub rpt, the property "when no datas prints..." with the value: " all sections without details". 2- to put the sub rpt in the summary band anyway i send you the 2 jrxml file and dont' forget to change the expression of subreport_dir param with your path (that was "C:\Users\stig.AXACONAD\Desktop\reports\New Folder\") ps: in the sample.zip there is the report create by your xml code, in the other one the same thing but with the insertion of subrpt created from scratch ps2: i've put the subrpt in the summary band because when there are no datas the details band doesn't show nothing.. hope this help you, bye :-) Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/23/2009 07:16

sorry but i've never met this problem and i hope it doesn't depends by your iReport version (i use the 2.0.0 vn and all the bands are ever settable by properties or "manual" resizing)... i'm sure is better to wait another one's opinion (more expert than me)... still sorry... bye Giovanni ...La puissance est rien sans controle...

Louise i don't know if is properly correct put page breaks in the detail band but if it works i think there are no problems (however ,humbly, i think is better to listen another one's opinion). Anyway i ever put the "page_number" textfield in the pagefooter or pageheader (the 2nd one, in my cases, works always). Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/11/2009 15:48

hi stig, probably your problem is to link the subrpt because the intructions that i've post previously (in relationship with passing parameters from subrpts) work perfectly (at least in a simple context:-)). try to follows theese steps: Add the sub rpt in your mainrpt with drag'n drop option from the palette than follow the wizard intructions. 1 - don't forget to choose the option "use an existing report" 2 - check the option use the same conecction used by the mainrpt 3 - in the 3rd step you can see a parameters called (as default) "SUBREPORT_DIR" 4 - choose the relative(dynamic)/static subrpt dir path (for me the 1st one is better) hope this help you bye Giovanni ...La puissance est rien sans controle...

hi stig, i've have only a curiosity: have you already tried to make a simple example in wich you pass a var from subrpt to mainrpt and try to show it (naturally in the mainrpt)? it works? ps: for "simple example" i mean a rpt that contains a subrpt situated in the summary band. Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/11/2009 12:15 Post Edited by giobby at 11/11/2009 12:17

hi louise,in wich band is situated the text field that shows the page number? Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/11/2009 12:04

hi manshack_one, my english is a little bit approximate, surely i've not understand very well what is your problem. I think is better to wait another one's reply... i'm really sorry but i can't understand the 2nd part of your post. Giovanni ...La puissance est rien sans controle...

hi, in my opinion you should only to pass the name of your subrpt like a param. Follows theese steps: 1- create a param (type String) and check the relative property that allows it to be used as prompt; call this param for example "subRptName"; 2- in your main rpt go on the sub rpt properties and modify the (default) subreport expression: $P{SUBREPORT_DIR} + "<nameOfYourSubReport>.jasper" with this one: $P{SUBREPORT_DIR} + $P{subRptName}. hope this help you p.s. Remember that it is also possible to pass direcly the subrpt jasper file like param Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/07/2009 08:27

when i said "PRATICALLY i don't know if this works" is properly for this reason... i ever used this method with sub reports located in the summary band (that shows dataset only once)... i'm really sorry but i'm a newbe too and i never dealt your situation... I think we have to wait for another one's opinion. have a great week-end you too. p.s. don't forget to post your results Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/06/2009 13:40

well, THEORICALLY we have to proceed in this way: 1- put the sub rpt in detail band 2-declare a variable in sub rpt that read the current "maxallowedweight" field (called for example "varMaxAllowedWeight") 3-declare a variable in main rpt (called for example "varMaxAllowedWeightFromSub") 4-in the main rpt go in the "sub rpt properties" => "return values" and try to match theese two vars (setting subreport var with "varMaxAllowedWeight" and destination var with "varMaxAllowedWeightFromSub") 5- dont' forget to set evaluationTime="Band" for the text field that shows the var. 6- the only problem is that i don't know if you want to display or not the dataset of the sub. PRATICALLY i don't if this works... Anyway try to have a look at theese two threads: a- http://www.jasperforge.com/plugins/espforum/view.php?group_id=83&forumid=101&topicid=11402 b- http://jasperforge.com/plugins/espforum/view.php?group_id=83&forumid=101&topicid=28040 the first it may help you to make the "difference operation" with a sub var; the second helps you to clarify what i've written... P.S. sorry for my english Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 11/06/2009 13:10

stig Wrote: The employee field from the master report should be fed to the subreport and thus determine which employee's value the subreport should show. Hi, i've a few problem with english... sorry but my english is too scholastic... do you mean "the emloyee FIELD" of the master report SHOULD BE FED by a sub report variable/parameter OR " EACH emloyee FIELD" SHOULD FEED the subreport dataset? I'm rather new with iReport but in this month i worked a lot on it and so i try to help you. Post Edited by giobby at 11/06/2009 10:56

hi, i'm new on iReport but if i've correctly understand your problem you should only use a subereport (located in the summary band) that displays the second dataset... otherwise, if this solution is not properly what you need, post more datails of your matter. Giovanni ...La puissance est rien sans controle...

...and if you want to learn more see theese topics: 1- http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=12317 2- http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=15193 bye Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 10/30/2009 16:19

Hi,I'm not properly able with english... My english is too scholastic , my iReport version is old (2.0) and also in Italian language... Anyway I try to help you... I met in this period your same issue and i solved with theese following steps. First of all we have to know that datasources are "consumable" objects, so we can use them only once a time. This is important ,for example,when we must to print multiple report in different formats. I think that your problem depends by this matter, but I'm a newbe and I'm not sure. 1- I have set theese subrpt properties (in the main rpt => rightclick on subrpt icon): "new JRBeanCollectionDataSource($F{fieldSubDataSource})" => Expression of data source (nb: note that is not a param, is a field). "net.sf.jasperreports.engine.JasperReport" => Class of SubReport. $P{<nameOfYourSubRptJasper>} => Expression of your subRpt passed like a param. 2- I have declared in my JavaBean another attribute called "private Collection fieldSubDataSource" (with naturally get and set methods). 3- in the main rpt i have added a field (called fieldSubDataSource with type java.util.Collection) that I have set in my java app with a Collection object (that returned an array list containing the resulset that represents my subrpt data source) when i have filled all the other main rpt fields trough the resultset. Resume: In this way i've passed the subrpt like a param and the subrpt data source like a field of the main rpt and all works perfectly. hope to help you bye. Giovanni ...La puissance est rien sans controle... Post Edited by giobby at 10/30/2009 11:43

hi try with this istruction: JRExporter exporter = new JRXlsExporter(); // exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, new Boolean(true)); // exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, new Boolean(true)); exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, new Boolean(true)); I hope this help you Giovanni ...La puissance est rien sans controle...

Sorry i've not another ideas at the moment... but if you find how to fix the problem don't forget to post the solution... Anyway i promise to return to this issue. Giovanni ...La puissance est rien sans controle...

I had an (odd) idea but i don't know if it works: try to use another (separated) text field to show the "color" (ever with the "hiding" property setted) and put this under the "items details", set all the other textfields (not the "item details" one) with the property "deforms"=>"relative to band height" (sorry... i've an italian version and i don't know if is the correct translation)... give me a feedback Giovanni ...La puissance est rien sans controle...