reallydolly

More of an example is I am trying to group and total on days found in my report. For example if I select data from 10/1/2013 - 10/5/2013 I need to get 5 groups - one for each day the report encounters.

Hi, I am hoping someone can help with this Group Expression. Essentiall I need to group on: $F{DATE1}.after $P{Start Date} || $F{DATE1} ISNULL Can anyone please throw me a clue? Thanks!

Greetings! I previewed a report and saved the occurance with the default .jrprint extension. How can I open/view this occurance of the report? I'm sure it's something ridiculously simple but I'm not having any luck today.

Thank you so much for your reply! I just got the following to work as the Print When expression: $F{fieldname} == "value1" || $F{fielname} == "value2" || $F{fielname} == "value3" Just posting this here in case someone else might find this of value.

Greetings! I want to supress the detail band when a character field in the band contains any of 6 or so possible entries. I have been unnsuccessful in doing this, can someone please give me an example? Thank you!

Thank you, at least now I can stop trying.

Greetings! In my search to print text fields in RTF Markup I find the only way to get all the data returned is to enclose the data in "double quotes". I am hoping that someone knows how to pad the data this way in ireport to return the data this way? Like: $F" + fieldname + "

The only way I've found to work around this is to enclose the data I am printing in "double quotes". I think this may lead to the start of another topic because I'm having no luck doing that.

Regarding the PDF view, click on the element in your report, display it's properties, and check the "PDF Font Name". Perhaps it is set to something screwy. Regarding the second part of your question, the only way I have been able to do that is to use seperate elements in the report, but I'm kinda a newbie too. Good luck!

Doh! Never mind, found it. Used $X{IN, table.column, parameter} and parameter class java.util.list.

I need to supply multiple "in the list" parameters at runtime for a report so my where statement is: Where columnname in ($P!{parameter}) The parameter class is java.lang.String. Is there a way I can set the Default Value Expression, Property, or anything else so the user does not have to remember to enter each value in 'quotes'? Currently the user has to supply something like 'A01','B99','XYZ' when responding to the parameter. They always remember the commas but they have trouble with the quotes (leave them out, use a double and a single, etc.) and then the report produces an error. Is there someway to automatically supply them or make them unnecessary? Thanks!

I have some notes that I need to print using rtf as the Markup type. When iReport encounters records in these fields that begin with a date (01/10/2011, 01/, or 1/) it does not print the entry in the field. I have to assume it's being seen as somekind of RTF code and choking on it. Anyone have any ideas for a work around on this?

Greetings! Due to a comedy/tragedy of errors I got a new computer and need to reinstall iReport Professional 3.7. I saved the installation file, iReport-Professional-3.7.0-windows-installer.exe, but when running it get a message " not a valid win32 application". I cannot download the original from the purchase again, it was only good for a few days and that was several months ago. Anybody throw me a clue?

Using iReport Professional I made a Dashboard which outputs to Flash. I want it to update every n minutes. I cannot figure out where that happens. Any help? Thanks!

I am finding the same to be true.

I need to prompt for multiple filter expressions when my reports are run. This works fine if I add them to the SQL WHERE. But because there are so many I want to build a series to select from when writing different types of reports plus share them with my co-workers. The Filter Expression form allows for Importing saved expressions so that would be swell, but I cannot figure out how to have more than one valid expression at a time here. I'm a noob, please forgive me if I am missing something terribly obvious. Any suggestions are most sincerely appreciated! Code:Example of filter expression that I am using in SQL:WHERE C6CHGHST_TRANS_DATE >= $P{from_date} AND C6CHGHST_TRANS_DATE <= $P{to_date} AND C6CHGHST_CLOC >= $P{from_location} AND C6CHGHST_CLOC <= $P{to_location} AND C6CHGHST_CDEPT >= $P{from_department} AND C6CHGHST_CDEPT <= $P{to_department} AND C6CHGHST_QPROGRAM >= $P{from_program} AND C6CHGHST_QPROGRAM <= $P{to_program} AND C6CHGHST_SERV_CODE >= $P{from_service} AND C6CHGHST_SERV_CODE <= $P{to_service} AND C6CHGHST_MCOCODE >= $P{from_payor} AND C6CHGHST_MCOCODE <= $P{to_payor}