yapkm01

I cannot seem to make a connection to Oracle 10 or 11. Example (Using Oracle SID connection) a. Create a new connection. b. Enter necessary elements like SID, port, userid/password etc. c. Click 'Check' (as indicated on top of the dialog box). Nothing happens here. Wait and wait but nothing happens. I noticed after a while the cursor goes to the 'Null' field on the dialog box. Click finish. Nothing happens. Please advice. Thanks.

I encountered this strange behaviour where text on a page footer becomes bold on PDF (even when the isBold=false) : As shown in the code below, the pdfFontName = Helvetica and the isBold=false. But somehow the text "Partners Program" becomes bold on PDF. I noticed this peculiar behaviour when there is an image rendered say on the summary band. When i remove that image from the summary band, the text on the page footer become back to non-bold. Please advice. Thanks. Code:Portion of the code:<pageFooter> <band height="58"> <staticText> <reportElement x="49" y="1" width="74" height="18"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/> </textElement> <text><![CDATA[Partners Program]]></text> </staticText>

In short: 1. Main reports contains data to fill 2 graphs. Not a problem here. 2. Created a list component in the main report. This list component gets its own data from a subdatasets. Problem is if there are lots of elements in the subdatasets which causes the element in the list component to be printed on new page, there is always 1 missing elements on a new page. See attachment. Is this a bug? If it is please advice how to report this in the Tracker? Do i have privilege to report this as a bug? Post Edited by yapkm01 at 03/16/2010 18:42 Post Edited by yapkm01 at 03/17/2010 04:26 Post Edited by yapkm01 at 03/17/2010 04:38

The attachment would shows in simplicity the issues i am having. In summary: 1. When the above checkbox is unchecked, the rows and columns data are sorted nicely. No problem :O) The crosstab will sort the rows and columns according to the natural ordering of the elements. So this will override the sorted list which is the actual data source for this crosstab. 2. I checked the above checkbox to use the sorted data in the list. Instead of values being shown there are some being replaced by null values. Would appreciate your advice.

I'll try to make it simple on this issue which i am facing. 1. Master Report (has page footing on it). This master report call a subreport which in turn call 2 subreports. Example: Master 1st Subreport Account A Jane Low Logo for Jane Low (page 1 but not printed) (Logo subreport) Address for Jane Low (page 2) (Address subreport) Account B Kim Logo for Kim (page 3 but not printed) (Logo subreport) Kim Address for Kim (page 4) (Address subreport) 2. The page footing is done at the master report in order to get the correct page number as shown above. 3. The Logo subreport for Jane Low and Kim practically covers the whole page. There should not be any page footing here 4. Compilation is not a problem for master and subreport but when i do a preview on the master report .. the report will run indefinitely and nothing pops up. 5. When i make the Logo image smaller in the subreport so that it does not overlays the bottom of the page (in order to leave a gap for the page footing from the master report) .. it seems ok. I need to logo to cover the whole page. Is there a way to get around this? Thanks. Post Edited by yapkm01 at 03/01/2010 04:31 Post Edited by yapkm01 at 03/01/2010 04:34 Post Edited by yapkm01 at 03/01/2010 05:05

I'm having the same problem. Have you managed to solve the border plot using aegean?

Anyone there who can help? I am having a problem where the list component (a subreport - detail band) gets too many in a page and gets cut-off when it goes to the next page (refer to attachment - the leftmost column). I have read some forum thread on this issue (checking ignore pagination on this subreport or even the main report trying to solve this) and i have done this but it is still not working. Please help. Using: IReport 3.7.0 Post Edited by yapkm01 at 01/08/2010 00:55 Post Edited by yapkm01 at 01/08/2010 00:57 Post Edited by yapkm01 at 01/08/2010 02:23 Post Edited by yapkm01 at 01/08/2010 02:27 Post Edited by yapkm01 at 01/08/2010 13:20 Post Edited by yapkm01 at 01/09/2010 04:49

Thanks for your reply. However on ireport 3.7.0 that Pdf font name drop now menu - stated there deprecated. Post Edited by yapkm01 at 01/07/2010 16:04

Text say 'Client Quarterly Reports' retains its bold attributes in iReport but lost in exported PDF (Using JRPdfExporter) Using : ireport 3.7.0 Attachment: ireport -> ireport.doc; pdf -> pdf.doc Dont worry about the data. They are using same report. Post Edited by yapkm01 at 01/06/2010 21:34 Post Edited by yapkm01 at 01/07/2010 15:58

Code:Have u found the solution to this problem ? I.'m having same issue

Is there any link to how to create a table of content .. The link on most thread about TOC returns page not found (example) http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/Samples

No. That is not the summay page cos' the summary band was deleted. It is just a normal last page without page header. So i dont think what you propose will work. I have tried using the 'Print when no data option' (checked) where i force a print when there is no data but still not working. Any other idea? Post Edited by yapkm01 at 11/10/2009 13:12

In short: 1. 1st page has page header and also data. 2. The data so happen to fill up just that 1st page right to the bottom of the page 3. The variable (calculated fields which is not an actual data field) printed on the 2nd page. Problem: 2nd Page doesnt have page header. I believe this is due to no data. The variable is printed on the 2nd page but it looks awkward without the page header. Of course fiddling around the page margin might solve it temporarily but then again should another different number of records fill a page and no records after that .. same problem. The question is how do i print a page header on the last page with no data (so that the variable printed on the last page will look nice). Any advice is appreciated

Master report passing in the following to subreport .. (data source expression) new net.sf.jasperreports.engine.data.JRMapArrayDataSource ($F{reportingType}.values().toArray()) ** ($F{reportingType} is a map) in the subreport .. how do i find out the names of the fields in array? Post Edited by yapkm01 at 11/08/2009 05:54

I did the same thing but not working .. :O(

In simplicity .. say 1 master reports has 2 unrelated subreports .. example: group 1 sub1 data1 sub1 data 2 (sub1 belongs to subreport 1) sub2 data 1 sub2 data 2 (sub2 belongs to subreport2) without using grouping to start a new page (which is the usual case) .. how to i print each of those subreports on separate page? -------------------- I read some article from this forum .. i created 2 group header and put subreport 1 into 1st group and subreport 2 into 2nd group. Then i check 'start on new page' on those group properties. Still not working :o( Post Edited by yapkm01 at 11/08/2009 02:56

In short: 1. Master report has 1 subreport. 2. The master report has 1 field (hashmap). This field in ireport equivalent to the pojo java program as shown below: private HashMap <String, Object> reportingType = new HashMap <String, Object>(); 3. I need to pass this field reportingType to the subreport and use is in the subreport. 4. In the master report under data source expression, i used JRMapCollection new net.sf.jasperreports.engine.data.JRMapCollectionDataSource ($F{reportingType}.values()) Questions: How do i access that $F{reportingType} in the subreport? I dont find much information on the usage of JRMapCollectionDataSource. Please advice. Post Edited by yapkm01 at 11/08/2009 04:52

In simplicity: 1. One master reports contains say 3 subreports. 2. Each of those subreports are not related to each other. How do i create new page for each of those subreports? Right now i cant seem to do it. Please advice.

Please refer to attachments. I have put the cellpadding using ireport to be 0. If you look at attachments CellpaddingProblem.pdf .. you will see there is always cell padding between the text and the table wall on all sides. So i thought of increasing the size of the font but still the same problem. It seems there is no way to get rid of the cell padding at all. I want the text to fill the whole table. Please advice. Thanks.

I am using iReport to produce a report and export to excel. The text produced on the excel by default is set to text wrapping. How do i set it to non wrapping?

Hi, I have posted this problem on the iReport forum and they ask me to post this on the jasper report forum. Anyway here it is. *********************************************************************************************************************************** I am using ireport 3.5.2 to produce an excel report as per attachment. If you look at row 32 on the security column, a portion of the word are covered since the data is quite long. The band height is 17. How do i make this band height auto expandable depending on the data without changing the band height 17 to say 20 in ireport. If i make the band height to 22 .. the security data on row 32 looks fine but then all the rest of security data sits on a bigger cell - which doesnt really look pleasing to the eyes. Please advice. ============================================================================================== hm, I'm not sure, I assume you want to auto-adjust the cell height. Try posting this question to the JasperReports forums, maybe they have some trick. Giulio Post Edited by yapkm01 at 07/20/2009 20:25 Post Edited by yapkm01 at 07/20/2009 20:26 Post Edited by yapkm01 at 07/20/2009 20:29 Post Edited by yapkm01 at 07/21/2009 14:14

Hi, I am using ireport 3.5.2 to produce an excel report as per attachment. If you look at row 32 on the security column, a portion of the word are covered since the data is quite long. The band height is 17. How do i make this band height auto expandable depending on the data without changing the band height 17 to say 20 in ireport. Please advice.

Does anyone know if there is a ireport plugin for eclipse? It seems the download link for this plugin for eclipse is not correct. Also there is a jasper assistant but it is not free. Please advice.

I need some help here. Would appreciate any help. In simplicity: a. I have 2 classes with all the getXxxx methods. b. I need to display the beans of the first class on first page and the beans for the 2nd class on second page. For Javabean set data source, iReport requires a return of collection of the class. Problem is when i make that collection of generic type (meaning example <Object> cos' i need to populate instances of the first and second class), iReport cannot interpret those fields to which class it belongs to. It will work only for 1 class .. meaning i specifically make that return collection <first class> and that would work but then i dont have any data for the second class. Hope this is clear and would appreciate any help. Please refer to attachment. Thanks.

Hello .. i am also having exactly the same issue. Did you manage to solve the problem? Appreciate if you could share if you have solved it. /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif