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