Date Items

 When trying to insert a date value from a parameter onto a chart in Birt Reports, I was having difficulty extracting the year from the date parameter.  It seemed that the javascript function getFullYear() didn't work.  To get around that I did the following:

paramEndDate.getYear()+ 1900

For some odd reason when you use the getYear() method it subtracts 1900 from the value, so you have to add it back in.

I found this link which noted this as a bug

   https://bugs.eclipse.org/bugs/show_bug.cgi?id=244348  

which in the comments showed a way to use the getFullYear() method.

When used this script it worked fine
var titleYear = new Date(paramStartDate.getTime()).getFullYear();
var titleStartDate =  (paramStartDate.getMonth() + 1) + "/" + paramStartDate.getDate() + "/" +  titleYear;

How to subtract days from a date or today in a text element

d = BirtDateTime.addDay(BirtDateTime.today(), -7); 
Hope this helps someone that may need it.

Comments

Post a Comment

Popular posts from this blog

Installing Birt Reports

Each time I need to install Birt Reports designer on a new machine I seem to forget the various elements needed. First off - you do not need to install the Eclipse program.  All you need is the version of the Birt reports designer that is compatible with whatever software you are associating the reports with. In my case I needed version 4.8 (as of July 2021).  This is because the program being used was only approved up to version 4.8. The following link was helpful in dealing with when you get the java exit code 13 when trying to start Birt https://appuals.com/fix-java-was-started-but-returned-exit-code13-eclipse/ For installing Birt version 4.8 you need the following: The latest version of Birt 4.8  birt-rcp-report-designer.   https://download.eclipse.org/birt/downloads/drops/     Check the date on the directory link.  At this time I selected  I-R1-4.8.0-201905212138 .  Because I had previously selected an earlier version it would not r...
Read more

Global Variables

Image
 I had a report where I wanted to pass the values from one table to another so that I could do a calculation.  What I did was create a global variable.  Following is the process I took to do so: Initialize your global variables On the report level, using Scripting select the Initialize method Use the  reportContext.setPersistentGlobalVariable("variable_name", "variable_value")  function for initializing the variable Populating your variable with the value in the report Select the element in the report that will have the value for the variable and then go into the Scripting tab:
Read more

Display Parameter Text

   Parameters usually provide the option to put two items in a drop down list, the value and the description of the value.  If you want to grab either of the two items to put in a report, say the header, the reference to either of the two items is as follows: Displaying the parameter list item value:    params[" your_parameter_name "].value Displaying the parameter list item description:    params[" your_parameter_name "].displayText
Read more