skijop

Maybe i should be more specific: $V{category} - is the name of the header that I'm trying to place formatting on. The logic that I'm trying to apply is as follows: If $V{category} = 'B. Core Capabilities' then I want the box to display a red background color. If $V{category} = 'F. Specialty Programs and Units' then I want the box to have a Blue background color. Once i have the correct syntax, do i click on the crosstab window, and then the text field expression elipses in the $V{category} properties window and then apply this code to the text field expression? I am on iReport 5.1.0

How can i change the background color of one specific header based on if/then logic expression. Example - if [field] = Book, then color is RED; if [field] = Tree then color is GREEN.

Subreport is not displaying when No Data in Main report : The main report and a Subreport both pull from the same datasource, use the same parameter passed (region), yet have 2 separate Sql querys for each report. Main report has 'when no data' property set to :'no data section', for which has a message displaying "NO DATA FOUND FOR REPORT". The subreport runs successfully when ran separately. 1)The subreport does not display (even though when ran separately returns records) when the Main report's sql returns no values. The No Data section does in fact display the message as added to the No Data Band as a text field. 2)The variables created to show the date of the report(which is also do not display in the No Data Band, but display when there is valid data during the date range. How do I setup the report so that if the main report contains no data, i still get the No data section, with the date of the report (variable below) AND most importantly the subreport still displays? Start Date Variable : $V{day}=='1'?((($V{c_date}-2).getMonth()+ 1).toString()+"/"+ ($V{c_date}-2).getDate().toString()+"/" +(($V{c_date}-3).getYear()+1900).toString() + " 12:00:00 AM"):((($V{c_date}-1).getMonth()+ 1).toString()+"/"+ ($V{c_date}).getDate().toString()+"/" +(($V{c_date}).getYear()+1900).toString() + " 12:00:00 AM") Post Edited by skijop at 08/31/2011 19:53