jkeri

I found an even easier way to do this: 1- create a rectangle around the area to be shaded. 2- push rectangle to the back of the band 3- create a 'PRINT WHEN TEXT EXPRESSION' for the band. Use the following: new Boolean($V{PAGE_COUNT}.intValue()%2==0)

My user wants every second line in DETAIL band shaded. Any one have any clue how to do this?

This is the correct EXPRESSION that i needed: new Boolean($V{AMOUNT_MEASURE}.toString().equals("0"))? " ":$V{AMOUNT_MEASURE} This work... thank you for pointing me in the right direction and your time.

$V{AMOUNT_MEASURE}.equals(0)? "":$V{AMOUNT_MEASURE} I tried that ExPRESSION and got : java.math.BigDecimal cannot be cast to java.lang.String error

I just checked my code, looks like the field i want is a measured field $V{AMOUNT_MEASURE} == 0? "":$V{AMOUNT_MEASURE} if the value is zero then print blanks. When i do this expression i get 'incompatiable operands types BigDecimcal and int'

I created my first crosstab report and some of the cells have zero value and its printing a zero.. I want the cell to be blank if its a zero. Im not a Java devloper, is there any way I can supress the zero values?

I found a solution to this problem. 1- Select the PROPERTIES of .METDATA folder 2- Select PREVIOUS VERSIONS select the most current previous versions and select RESTORE. This worked for me. Just be aware that you should have a recent backup of any .JRXML files before attemtping the RESTORE of PREVIOUS VERSIONS

I am trying to open up my application and i keep getting 'An error has occured. See the log file C:UsersxxxxJasperSoftwaorkspace.metadata.log' I opened it up and said, but the .JASPER file its referrign to does exists.: ... 35 moreCaused by: org.eclipse.core.internal.dtree.ObjectNotFoundException: Tree element '/JK-Prototype/PLO1000.jasper' not found.at org.eclipse.core.internal.dtree.AbstractDataTree.handleNotFound(AbstractDataTree.java:257)at org.eclipse.core.internal.dtree.DeltaDataTree.getData(DeltaDataTree.java:596)at org.eclipse.core.internal.dtree.DataDeltaNode.asBackwardDelta(DataDeltaNode.java:51)at org.eclipse.core.internal.dtree.NoDataDeltaNode.asBackwardDelta(NoDataDeltaNode.java:60)at org.eclipse.core.internal.dtree.DataDeltaNode.asBackwardDelta(DataDeltaNode.java:48)at org.eclipse.core.internal.dtree.DeltaDataTree.asBackwardDelta(DeltaDataTree.java:88)at org.eclipse.core.internal.dtree.DeltaDataTree.reroot(DeltaDataTree.java:832)at org.eclipse.core.internal.dtree.DeltaDataTree.reroot(DeltaDataTree.java:831)at org.eclipse.core.internal.dtree.DeltaDataTree.reroot(DeltaDataTree.java:808)at org.eclipse.core.internal.watson.ElementTree.immutable(ElementTree.java:518)at org.eclipse.core.internal.resources.SaveManager.restore(SaveManager.java:740)at org.eclipse.core.internal.resources.SaveManager.startup(SaveManager.java:1588)at org.eclipse.core.internal.resources.Workspace.startup(Workspace.java:2386)at org.eclipse.core.internal.resources.Workspace.open(Workspace.java:2157)at org.eclipse.core.resources.ResourcesPlugin.start(ResourcesPlugin.java:463)at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:771)at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:1)at java.security.AccessController.doPrivileged(Native Method)at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:764)... 42 more d

I have a $X parameter that needs to select from table NAMES a field named AUD$USER Jasper or Oracle seems to be having a issue with the $ in the fieldname. ANyone run into this before? This is the WHERE statement WHERE $X{IN, names.aud$user, TECHNICIAN}

I has a SQL query that has 4 Jasper praemeters. Everything was working fine until i chnaged one of the paramters $P to $X(IN). I need the user to be able to select from a list of values rather than just entering a single value. The problem seems to be arount the 'WHERE $X{IN' statement. Anyone have any ideas? select UPPER(st.aud$user) Technician, substr(n.name_last,1,15)||' '||substr(n.name_first,1,15) DonorName, st.donor_id donorId, dn.donor_number Donor, v.visit_date VisitDate, v.visit_number VisitNumber , st.scrntype_id, (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) ScreeningCode, d.birth_date DonorBirthDatefrom stdnr.aud$screening_tests ST, stdnr.visits V, stdnr.donors D, stdnr.donor_numbers DN, stdnr.names NWHERE $X{IN, ST.AUD$USER, TECHNICIAN} and st.visit_id = v.id and v.donor_id=d.id and d.id = dn.donor_id and d.id = n.donor_id and v.visit_date between $P{VISITFROM} and $P{VISITTO} and (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) = UPPER($P{SCREEN}) order by technician,donorname , visitdate

I want to roll out jasper reports to several users. What I woudl like to do is to have the user click icons that will launch the Jasper report. I dont want to have to design a menu app from where they select the reports. Can Jasper reports executables(.JASPER) be run as an icon?

Need help to code PRINTE EXPRESSION , and not being a JAVA coder I dont know how. IF fieldA starts with 'A' OR fieldB starts with 'B' OR fieldc starts with 'C" This is what i coded but its not working: Boolean.valueOf($F{U_TYPE}.startsWith( "Deglyc"))//Boolean.valueOf($F{U_TYPE}.startsWith( "Glyc"))//Boolean.valueOf($F{U_TYPE}.startsWith( "WB"))

I am getting an error (CANNOT CAST FROM BOOLEAN TO BOOLEAN).

I want to control printing of my DETAIL band with a condition. IF PARAMX = 'Y' then print the detail band OR (IF FIEILDX ="PrintMe" and PARAMX = "N") then also print the detail band

My Jasper reports are launched from a java webpage that has multiple items on it. I want to select multiple items from the webpage and pass all of them into my Jasper report. My report has a simple SQL query SELECT SAMPLENUMBER from SAMPLE_TABLE WHERE SAMPLENUMBER in the list of samples i checked off on the webpage. Can anyone help me with the coding that need to be in the SQL query and any other tips on this? Thanks in advance.