jhickling

Can anyone point me in the right direction to set Jasper Report Properties with an expression? I would like to set PDF metadata (Author, Title) with an expression. Thanks, Justin

Hi all, Wondering if it is possible to keep the Parameter Values I specify when running the report preview from Jaspersoft Studio. Currenty, every time I run a report, it prompts me for the parameter values which takes time to fill out. Then, if I make a simple change in the editor and try to preview it again, the paramter values dissapear and I have to re-enter them. Can anyone tell me if there is a setting for this?

Could someone please tell me how to correctly group by Month while allowing for multiple timezones in Jaspersoft? Our Mysql database is in UTC time, and I am in Australia, UTC +10:00, so a date that is '1st May 2015 08:00' for me is '30th April 2015 22:00' in the database. Using patterns in the designer converts UTC dates to my timezone correctly, but I cannot use one of these inbuild patterns in a group expression (at least not to my knowledge). How can I group by month while taking into account the timezone? Thanks, Justin UPDATE, I figured it out. Create a parameter (E.g. $P{DateFormatter}, not for prompting, class of DateFormat) in the report with the following default expression: $P{REPORT_FORMAT_FACTORY}.createDateFormat("dd/MM/yy", $P{REPORT_LOCALE},$P{REPORT_TIME_ZONE})[/code]This could be any date format, such as "MMMM, yyyy", etc etc. Then in the Group Expression its as simple as writing $P{DateFormatter}.format($F{TheDate}). This will then correctly group according to the local timezone, as opposed to the SQL database timezone.