jhickling
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by jhickling
-
-
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.
Set Report Properties with Expression
in Products
Posted
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