swelch

Hello. I have a report with fields holding numeric data, namely a 0 for false and a 1 for true. I would like to display the result as a check box but this looks difficult so the other option would be to have the report show a 'Green' box for a 1 and a 'red' box for a 0. How is this done easily? I have tried adding a conditional expression '$F {Filed_Name}.equals('1') but the system does not like either '1' or "1". Any ideas? Kind Regards, S Welch

I take your point. My point was based on the Oracle OTF forum where there is a much higher level of participation. I have now bought 4 books on this subject trying to answer the questions myself and have been answering my own questions in the main. I have received some help which will encourage me to comment on posts myself but my frustration was evident. My point was really that I would have thought to give help you need to offer it and if everyone simply takes the view that because it is free then don't expect much no-one benefits. This product would have benefitted from information received from this forum so the developers are made aware of bugs and possible enhancements otherwise why host a forum and make the application available. Please don't get me wrong, this is a great product. Kind Regards, swelch

Excellent, thankyou very much. It worked.

Many of the replies are from the people who make the original post. There is little incentive in helping those who don't help!

JasperReports and iReport are fantastic products. Where I feel they are lacking is in the complete lack of real time support. I am new to the application and when I post I get no replies where as on the Oracle APEX forum the support from fellow developers is excellent. I have been able to work out most of my problems but I took me entire weekends to do it. I have now bought 4 books on iReports and JasperReports skimming through them for the information I require so this forum has been of no help to me. I will persist with both iReports and JasperReports because they are excellent products but I hold little faith in the forum. Sorry swelch55

Does anyone know how to get a date printed in a report without the time being appended? The field the data is drawn from holds only the date. Kind Regards, swelch55

I have created a report with 2 detail areas each containing an image in the background which is an official form that the database will fill. This form also carries an image of a signature and 2 sub forms which provide additional required information. I have got everything to work including adding a control prompting the user to choose a report number from a drop down list. My problems start however after I have uploaded the report to 'Jasper Reports'. Even though the report will run in Jasper Reports it is now broken at the source in iReports. All the sub forms and images are orphaned and I don't know how to get them back. I have checked the paths and they are unchanged. If I copy all the files to a different directory and put them back after the upload I can keep working. So something is being modified on the iReports side. Does anyone have any ideas what is happening. Kind Regards, swelch

I am new to these programs and am having a hard time getting things to work but I am getting there slowly. My first question is this: iReports is the GUI designer for Jasper Reports. Why can I create a parameter that prompts for user for an input (a report number) that works in iReports but when uploaded to Jasper Reports it doesn't? If I provide a default value it is that value that Jasper Reports uses and doesn't prompt for user input. The actual report query is simple:SELECT COMP_CTICK."ID" AS COMP_CTICK_ID, COMP_CTICK."MODEL" AS COMP_CTICK_MODEL, COMP_CTICK."MODEL_DES" AS COMP_CTICK_MODEL_DES, COMP_CTICK."CTICK_COMPLETE" AS COMP_CTICK_CTICK_COMPLETE FROM "TSAPEX"."COMP_CTICK" COMP_CTICK WHERE ID = $P{Filter} Kind Regards, Steve W