nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Accessing dataset input paramter inside onrender script of a control

ahmedmdm · 2014-08-06T19:07:32+00:00

Hi, I have a dataset with an input parameter "timezone" along with start time and start date. My use case is when report generates, it uses the provided timezone. So,When i am rendering the start time, inside onrender method i tried doing something like below with no success …

ahmedmdm

Hi,
I have a dataset with an input parameter "timezone" along with start time and start date. My use case is when report generates, it uses the provided timezone.
 
So,When i am rendering the start time, inside onrender method i tried doing something like below
with no success
 
importPackage(Packages.java.text.*); 
var dfmt = new java.text.SimpleDateFormat("MM/dd/yyyy");
var tz=inputParams["timeZone"] ; 
var tz1= params["timeZone"] ;

dfmt.setTimeZone(java.util.TimeZone.getTimeZone("America/New_York")); 
this.setDisplayValue( dfmt.format(this.getValue()) );
 
Is there a diff way to access the dataset parameter?
 
Also i am trying to format the date using the timezone hard coded as below, but i running into below error
 
Caused by: org.mozilla.javascript.EvaluatorException: The choice of Java constructor format matching JavaScript argument types (null) is ambiguous; candidate constructors are: 
class java.lang.String format(java.lang.Object) 
class java.lang.String format(java.util.Date)
 
Is there a better way to display date based on different timezones?
 
Thanks,
Ahmed
 
P.S : I cannot update default timezone for the report because it can have multiple timezones for various sections.

Find more posts tagged with

Comments

pricher

Hi,
 
I have attached an example that should help you. The technique I have used is to modify the initialize method of the report to instantiate the DateFormat Java object and read the value of the report parameter. Then, I use a Text element to display a date field by using the DateFormat.format() method.
 
The initialize method looks like this:
 
importPackage(Packages.java.text); 
importPackage(Packages.java.util); 
dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG); 
dateFormat.setTimeZone(TimeZone.getTimeZone(params["pTimeZone"].value));
 
and the Text item looks like this:
 
<VALUE-OF>dateFormat.format(row["MYTIME"])</VALUE-OF>
 
Hope this helps,
 
P.

yoovrajkhullar

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="130011" data-time="1407417642">
<div>
Hi,
 
I have attached an example that should help you. The technique I have used is to modify the initialize method of the report to instantiate the DateFormat Java object and read the value of the report parameter. Then, I use a Text element to display a date field by using the DateFormat.format() method.
 
The initialize method looks like this:
 
importPackage(Packages.java.text); 
importPackage(Packages.java.util); 
dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG); 
dateFormat.setTimeZone(TimeZone.getTimeZone(params["pTimeZone"].value));
 
and the Text item looks like this:
 
<VALUE-OF>dateFormat.format(row["MYTIME"])</VALUE-OF>
 
Hope this helps,
 
P.
</div>
</blockquote>
Hi P Richer
I have been your fan for different BIRT Reports. You make it simple to understand.
I need urgent help for this very Report.
My issue for this Timezone.rptdesign i dont have to pass the TimeZone as paramter like America/New_York.
The timezone should be automatically coming for the End User Time Zone.
 
Here is the scenario, my IHub Server is on GMT TimeZone.
I want a reliable way of converting GMT Time Zone into USer Time Zone.
 
Specifically, itâ€™s related to dynamic dates. For instance where report runs and there is a report parameter like â€œOrder Dateâ€ = â€œTodayâ€.
All our server run in GMT time zone. So, when report runs on â€œ3/16/2016 2:00AM GMTâ€, in â€œAmerica/New_Yorkâ€ itâ€™s still â€œ3/15/2016â€.
 
I want a reliable way of converting GMT Time Zone into USer Time Zone.
 
Please help in urgently required.
 
Thanks
Raj
 
 
Hi Richer
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;">In continuation to my post, basically i want the second line(User Time Zone) working not the first one as first gives me IServer GMT Time zone where Server is .</div>
<div style="font-family:arial, sans-serif;font-size:small;"> </div>
<div style="font-family:arial, sans-serif;font-size:small;">
<div>var tz = reportContext.getAppContext().get("AppRuntimeTimeZone");</div>
<div>//var tz = reportContext.getAppContext().get("UserTimeZone");</div>
<div> </div>
<div>I mean what is the name of AppContext For UserTimeZone</div>
<div> </div>
<div>Thank you so much in advance</div>
</div>