chumansky

I made a scriplet the way they described in iReport Ultimate Guide. For my purpose I choosed beforeReportInit() method. I'm sure that I run my query before report initialization, but I'm not sure wether the report's recordset is ready in that moment ore not. On my sensations the report's query is executed and the event beforeReportInit() comes after it. How can I find it out?

We have ORACLE database configured not in common way. Some parameters are to be set after logging in declareorg_id int;begin org_id := set_org_id(1513);end; I'm trying to design a report in IReport with some simpliest query (select id, descr from contracts), but before it I need to execute function mentioned above. I'm using common JDBC connection for ORACLE and there I see no possibilities to execute anything on session starting. IReports returns Errors when I try to provide query like this declareorg_id int;begin org_id := set_org_id(1513);end; select id, descr from contracts other variant does not work either select * from contracts where exists (select set_org_id(1513) from dual) Please give me some hints to solve the problem. Thanks in advance

Hi! I'm using JasperReports and iReport. My web application is running on Tomcat. It usesSpring and Hibernate frameworks in its core. Also it has special servlet for reporting with JasperReports. By now it was enough for me to use simple jdbc datasource in my reports and I was happy because my job of creating reports was easy enough. I used iReport for visual development of reports and then deployed them into the web-application. Now I face the challenge of making a little more sophisticated report. It should have more then one datasource and I decided to use JavaBeans set datasource instead jdbc. I took sample from "iReport ultimate guide" where JavaBeans set datasources described well, made classes precisely like they say, changed classpath in iReport and enjoied the result. It works! But when I began to develop report for my web-application it striked me that I can't do anything to put my classes in classpath of iReport. I have only war - file, wich contain the classes I need, but even when I put this war file in classpath I had ClassNotFound errors. Then I took another approach and packed my classes in jar. It helped a lot. Instead of ClassNotFound exeption I got General problem: null At this point I inderstood I should try to ask Real Professionals what to do in my case How can I Use IReport to build reports when my webApplication is not even running? Where I can see th stacktrace of the exception: General problem: null which occures when i test JavaBeans set datasource in IReport? Thanks in advance!

Hi! I use jasperReports 3.7.4. The tomcat6 webApp which contain my reports firstly was installed on Linux 32 machine. When my WebApp was deployed on Linux64 machine the problems began. Everything works fine, only reports began sometimes lie. If the number value in textField is too large, for example 169,264,000.00 it showes 16,926,400.00 i.e. 10 times less then actual valueall this occures only when WebApp Deployed on Linux64. When Windows or Linux32 OS used, nothing happens, all values a actual. I was surprised with such a behaviour. The onle remedy I find by now is to make textField more wide. But I can't understand the root of a problem. Is It 64 OS or is it 64 -bit JVM? Or is it JasperReport? Thanks in advance!

Thanks, Giulio! In my case I have scanned documents, saved as pdf(s). Really - they are images, not more. It seems to be the most bad case? No text - only image

Hi! I'm looking for solution how to show PDF-s which are stored in BLOB fields with iReport. I have found some solutions how to show images. They are simple and works fine. But in case with stored in BLOB PDF-document this solutions do not work. What can I do to solve my problem? Thanks in advance!

I have DataBase table with BLOB field which contains scaned document, converted to pdf format. I want to view this scans in my WEBAPP in the way common reports (jasperReports) are viewed. I think there are no problems to do it with JR, but I can't find the solution. Please tell me what steps shall I do to transfer the BLOB field content to browser window with JR. Also I'd like not to save my scans into temporary files on disk. Is it possible? Thanks in advance!

Hello! How can I change dinamicaly font color for NEGATIVE numeric values in report? Thanks!

Hello! Is it a way to present NUMERIC or BIGDECIMAL 0 in some custom way? For example "-", or even with blank value. I do know that I can use "Blank When null" option but maybe it is possible not to transform NUMERIC or BIGDECIMAL 0 into nulls? If there is no way to do it, tell me please how can I convert Numeric report variable into null when it have initial value NUMERIC 0 and was not changed? Thanks in advance! Post Edited by chumansky at 12/17/2009 05:28

How can I set Initial Value Expression for BigDecimal variable I tried this way new BigDecimal("0"), but iReport didn't understand it and said : The initial value class is not compatible with the variable's class : cfo_total_plan, although variable cfo_total_plan and it's initial value are BigDecimals.... Help me please!

I'm trying to understand if it possible to embed javaScript into reports, and to enjoy it after report exported to html?

Thanks! It's what I need

Hello everybody! Please tell me! Can I make a report wich will have a kind of drilling? I guess it this way. I have a basic report, which present consolidated information on some items. Every item can be detaild by clicking on it. When I click any item, another report appears and represents what I want. At this moment I can do both of reports, but have no idea of how to do hyperlins that will cause starting execution of the detaild report after an Item was clicked. I have no idea of even how to add hyperlink to the first reports cell... Both reports should be exported to html, so it seems to me there must be a way to add a kind of <a href="bla-bla-bla.html?item_id=424234">SOME ITEM</a> Please help me to understand is it possible? Or may be you have some links on ther subject? Thankss ib advance

Thanks! Shame on me!

Hi everybody! I have a little problem with jasper reports. I can't stop showing number values like "0.00" or "0" in reports |s there any kind of presentation of "0" values in reports? thanks in advance

Dear sirs! Is there no solution at all?

I'm using iReport to make report and to convert it to Excel My query brings me above others BigDecimal values, but output Excel file understans BigDecimals only as text, whatever pattern I use for the cell. How to make it clear to Excel that I want to see a number in a cell, not text. And how I can tell Excel I need special format for the cell, not general

Hi everybody! I'm very new both to iReports and Jasper reports I have two datasourses for complex single report. One is ORACLE Database and another in MSSQL. Let us not think about who and why organize data in this way. I'm trying to understand is it possible to access more then one datasource whithin one report. And how to do it Thanks in advance