purplepride1961

Hi Tirupathi. Thanks for response. My question is a bit different from the request in the link you provided. In that example, "instead of just text there should be a dropdown list in each cell filled with data from the database." For my request, i want it to be a dropdown list of predefined values, not from any query or data from within a database. I'm not sure if that matters or not. In that posting, it sounded like the only option was to "...create a custom exporter that will implement these properties. You would need to write java code to implement this custom java class. Understand this is a complex extension of Jaspersoft. " That is a bit more complicate than I was hoping for. As my request is not looking to populate from a query/access to the database, would the answer be different? Your response also notes I can add macro properties, but I'm not sure what that would look like in my case. Any add'l thoughts there? Thank you. Andrew

Hi everyone. I am a novice user in Jaspersoft/iReport designing. I am using version 5.6.0 (from work applications) to create a template for my report output from another application(OTM). I have created a few templates to do things like apply different styles to certain cells based on their values, a few simple calculations, etc. We create the query to pull the data within the other application, then apply the .jrxml template file to the output (which is being exported as Excel document). My SQL outputs a blank column, which what I want to be able to do, is to when the file is exported and sent to a user, have the user open the file, and go to that blank column. They will then have to select 1 of 5 values from a list (i.e., like it would be a drop-down list box in excel). For example, lets say the column is 'Region'. Every row in my report will be exported with a blank region, but when they open the file, they will have to go to that Region column and then populate it with one of 5 values from a drop-down list :(East/North/South/West/Mid-west) It seems as if this should be doable somehow, but I have not been able to find any documentation or prior examples doing this. Any help would be appreciated. Thank you. Andrew.

So, I couldn't get any date calculations to work, so I went and performed the them within the query that creates the date file used, and used that field in my logic instead.

So, I couldn't get any date calculations to work, so I went and performed the them within the query that creates the date file used, and used that field in my logic instead.

Hello I'm a newbit to iReports. I'm using version 5.6.0 I have a need to compare a string field that has dates (in MM/DD/YY format, like 01/09/2020 or a value of 'Missing' , look at the date and see if its more than 6 days old (from today, or the report date), and if so, change the font on the field. For now, i'm actually just comparing the date to todays date and if its before today, to change the font. If I can get it to work , then I'll add the criteria to look back 6 days. My thought was to create 2 variables. The first is called TEMP1, and is set as java.util.date using the variable expression below. I'm basically setting the character string 'Missing' to a dummy date, otherwise just use the date. $F{Scheduled Home Delivery}.trim().equals("Missing")? ("12/31/2049") : $F{Scheduled Home Delivery} My second variable is just called RptDt, is set as java.util.date and has the variable expresssion: Its meant to contain todays date new SimpleDateFormat("MM/DD/yyyy").format(new Date()) But I am getting this error: Error processing report - Error evaluating expression for source text: $V{tempSchdHomeDelvDt}.before $V{RptDt} I am using the following logic to help set a style for a field: $V{tempSchdHomeDelvDt}.before $V{RptDt} Any suggestions? Thank you.