hangman01

I am sorry that did not help. Since that worked on the one report that I needed it for I have never had to find anything else. I hope that you find an answer for your problem.

If you look under the 'View' menu item for 'Docking Panes' you will see a 'Styles Library' this will add a styles window to IReport and give you access to the library that is constant between reports. There were several predefined styles and these can be modified or new ones can be added and they will all show up in every new report's styles window. The easiest way to use them I found was to drag and drop the desired style on the new text object. This seemed to only work when the properties window was closed though.

You did not say which version of IReport that you were using but if you are using 3.0.0 or 2.0.4 or earlier you can add the desired styles to the styles library then they will be availabe to any report or template constructed. You can also modify the styles already in the styles library. I have found that trying to add a style to a text item (text field or static text) will not work if you have the properties dialog box open. I am still trying to find a way to carry over styles used in IReport version 3.1.0 nb. I have had to recreate the style with each new report.

I have a report that displays a BLOB. the image object uses an "image expression type" of java.io.InputStream. After running the query to create the BLOB field edit that field's "Field Type Class" to java.io.InputStream to match the image object. That worked for me.

Try: select * from <any table of your choice> where <some date field> >= nvl($P{param1},<some date field> ) I have done this on reports where I needed to produce one report by an ID or the entire batch at one time. Hope that this helps.

Another thing to remember is that Java uses == for comparisons not and = for assignment. When comparing objects == will see if both are the same object not if the objects are identical, so the equals(object) method will be more useful.

I have found that sub-reports even those with static data work better when they include a query even if the output is not used. Such as this one I used in a recent sub-report that was actually a second page to a letter produced as a pdf and downloaded from a website. select xxxxx_id from adacbt.xxxxxxxxxx where xxxxx_id = $P{ID} The sub-report did not make use of the xxxxx_id but without the query the sub-reports would not appear.

I finally found my error. I needed to used "styled" in the markup properties. Once I did that I could use change the style of the text in both the static text and the text field elements.

I am using IReport 3.1.0-nb and I want to have a text field with normal text, bold text, italic text, and a variable field all in the same text field element. I can do this using version 3.0.0 but when I try to do the same things in the netbeans version the text is not changed. The <style......></style> tags are not printed but they are not being performed either. I like the look of the netbeans based standalone that I am trying out but I do this sort of thing a lot in the reports I build and it is much easier to be able to handle the different text styles in one field.

I have had some success creating multiple page reports by adding a sub-report at the very bottom of the page. Use the sub-report to produce the second page. This has worked for one 2 page report/letter I created. I have not tried adding a sub-report to a sub-report as would be necessary to create a report or 3 or more pages. I hope that this helps.

I am trying to connect to an Oracle 10 database using Hibernate and iReport 2.0.5. When I set up the connection and test it using the Test button it says that the connection was successful but then when I try to write a HQL query I get the message that iReport is unable to connect to the database. I can write a Java class and insert, update, read, and delete records from the database so I am sure that the hibernate.cfg.xml file, the .hbm.xml and Java class are configured correctly. Can anyone point me to a good tutorial on using hibernate with iReport? All I have found so far do not talk about how to set up iReport to actually use Hibernate.

You can send your sub-report the optionid as a parameter and use that parameter in a new query for the sub-report. I do something very similar to what you are looking for in the report I posted here earlier. It lists the exams for an individual and only that individual when there are several hundred people in the table.

Some more additional facts I have found are that the page number is not showing as increasing for the extra pages produced by this report. The page count shows as 0 in the page header band of the report and the page number starts as 1 and counts the pages produced correctly when the display is not in the detail band. Inside the detail band the report does not seem to recognize the fact that a second page has been produced. The text field displays the same values as on the first page even though these numbers have changed in the page header band. I have included a small screen shot of my report displaying very different page count (pc) and page number (pn) values on the same page. This actually an extra blank page after a report that requires 2 pages to complete. size=171]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/scr_sht.jpg

Thanks for the suggestions, but unfortunately, I have already tried them all, and many more. with no success at all. A little extra information I have found as I have been trying to find an answer to this problem. I can make the labels for the data in the detail band appear correctly by shifting those objects to the column header band. For any report that has expanded to 2 pages the layout lines will only appear on one page unless the "print when detail overflows" option is checked. If this option is checked then I get a blank page with all the layout and the data for the main report for each report regardless of whether the report has one or two pages required. I started building this report using version 1.3.3 and I recently started to use version 2.0.0 but it reacts the same with both. Also I have found out that the PAGE_COUNT variable is always equal to 1 for my single page reports but when the second page is produced the PAGE_COUNT for that page equals 0 not 2 as I was expecting. Sorry to make this so long but I am trying to give as much information as I can on this problem and hope that someone can find an answer for it.

I am currently working on a report that can at times expand into more than one page. This report is made up of a main report containing the individual’s contact information like name and address etc, and a sub-report containing that individual’s scoring information for each of a possible 11 exams. Along with the name of the exam and the date it was submitted the person’s score and a list of the number of each question missed is displayed for each newly listed exam for that person. It is possible that an individual has taken and submitted exams before and when that individual adds new ones taken only the name of the exam and some score information is shown but not the list of missed questions. There is a possibility that the list of numbers can become 8 lines long if the person missed every question on one of the exams. My problem is occurring when the report needs to add a second page to display all the detail data. When the second page is present the report loses the ‘layout’ lines in the detail band on the first page of that report. All other data is printed and correct. If the “print when detail overflows†box is selected I get blank report for every individual after their complete report is produced. The entire layout is there along with the contact information in the page header band but no sub-report data is displayed. Since this report can generate several hundred individual reports at one time it is not practical to produce that many blank pages. [file name=mksap14_scrpt.jrxml size=30889]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/mksap14_scrpt.jrxml[/file]