Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Date subtraction in BIRT Report
Date subtraction in BIRT Report [message #368582] Thu, 11 June 2009 20:48 Go to next message
JP Redro is currently offline JP RedroFriend
Messages: 181
Registered: July 2009
Location: India
Senior Member
Hi All,

My birt Version is 2.2.1

I need to subtract two date in my report, could any one please suggest me
how to do this with example.

Thanks,
REDRO

Thanks,
JP

Report message to a moderator

Re: Date subtraction in BIRT Report [message #368588 is a reply to message #368582] Thu, 11 June 2009 21:38 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Take a look at this example.

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="date1" id="7">
<property name="valueType">static</property>
<property name="dataType">date</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2005-11-23</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="date2" id="8">
<property name="valueType">static</property>
<property name="dataType">date</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2006-12-10</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<data id="6">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression name="expression">var dt1 = new
Date("10/21/2003");
var dt2 = new Date("11/01/2004");
BirtDateTime.diffDay(dt1, dt2);</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
<data id="9">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">MMM d, yyyy</property>
</structure>
<list-property name="boundDataColumns">
<structure>
<property name="name">date1</property>
<expression
name="expression">params["date1"].value</expression>
<property name="dataType">date</property>
</structure>
</list-property>
<property name="resultSetColumn">date1</property>
</data>
<data id="10">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">MMM d, yyyy</property>
</structure>
<list-property name="boundDataColumns">
<structure>
<property name="name">date2</property>
<expression
name="expression">params["date2"].value</expression>
<property name="dataType">date</property>
</structure>
</list-property>
<property name="resultSetColumn">date2</property>
</data>
<data id="11">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression name="expression">var mydt1
=params["date1"].value
var mydt2 =params["date2"].value

importPackage( Packages.java.text );
var sdf = new SimpleDateFormat("MMM d, yyyy");
var mydtf1 = sdf.format( mydt1 );
var mydtf2 = sdf.format( mydt2 );
mydtf1 + "-" + mydtf2</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
</body>
</report>


JP wrote:
> Hi All,
>
> My birt Version is 2.2.1
>
> I need to subtract two date in my report, could any one please suggest
> me how to do this with example.
>
> Thanks,
> REDRO
>

Report message to a moderator

Re: Date subtraction in BIRT Report [message #368589 is a reply to message #368588] Thu, 11 June 2009 21:48 Go to previous messageGo to next message
JP Redro is currently offline JP RedroFriend
Messages: 181
Registered: July 2009
Location: India
Senior Member
Hi Jason,

Could you please give me this example in BIRT2.2.1 version.

Thanks,
Redro

Thanks,
JP

Report message to a moderator

Re: Date subtraction in BIRT Report [message #368600 is a reply to message #368589] Fri, 12 June 2009 22:06 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<parameters>
<scalar-parameter name="date1" id="6">
<property name="valueType">static</property>
<property name="dataType">date</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2005-11-23</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="date2" id="7">
<property name="valueType">static</property>
<property name="dataType">date</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2006-12-10</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<data id="8">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression name="expression">var dt1 = new
Date("10/21/2003");
var dt2 = new Date("11/01/2004");
BirtDateTime.diffDay(dt1, dt2);</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
<data id="9">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression
name="expression">params["date1"].value</expression>
<property name="dataType">date</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
<data id="10">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression
name="expression">params["date2"].value</expression>
<property name="dataType">date</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
<data id="11">
<list-property name="boundDataColumns">
<structure>
<property name="name">Column Binding</property>
<expression name="expression">var mydt1
=params["date1"].value
var mydt2 =params["date2"].value

importPackage( Packages.java.text );
var sdf = new SimpleDateFormat("MMM d, yyyy");
var mydtf1 = sdf.format( mydt1 );
var mydtf2 = sdf.format( mydt2 );
mydtf1 + "-" + mydtf2</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">Column Binding</property>
</data>
</body>
</report>


JP wrote:
> Hi Jason,
>
> Could you please give me this example in BIRT2.2.1 version.
>
> Thanks,
> Redro
>

Report message to a moderator

Re: Date subtraction in BIRT Report [message #368611 is a reply to message #368600] Mon, 15 June 2009 13:34 Go to previous message
JP Redro is currently offline JP RedroFriend
Messages: 181
Registered: July 2009
Location: India
Senior Member
Hi Jason,

I got i, it works fine.. But in my case it is different manner. I am
getting date from xml file. so that i have some problem with that. i have
sent an email to you could you please reply back as soon as possible.

Thanks,
Red.

Thanks,
JP

Report message to a moderator

Previous Topic:beforeGeneration causing an NPE
Next Topic:XPath 1.0 or 2.0?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 20:20:27 GMT 2024

Powered by FUDForum. Page generated in 0.03248 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly