Skip to main content



      Home
Home » Archived » BIRT » How do I manipulate two metrics from two data sources in a report ?
How do I manipulate two metrics from two data sources in a report ? [message #63104] Sun, 31 July 2005 21:02 Go to next message
Eclipse UserFriend
I have row["count(*)"] from data source 1 and row["count(*)"] from data
source 2, I want the difference of both, how do I do that in BIRT single
report ?

Thanks for any answer.
Re: How do I manipulate two metrics from two data sources in a report ? [message #64216 is a reply to message #63104] Wed, 03 August 2005 16:46 Go to previous messageGo to next message
Eclipse UserFriend
Hello,
Cross-data set scripting support is rather limited in Birt 1.0. However it
might still possible to do what you are asking for. See attached report for
example. In the afterOpen() method of each data set a global Javascript
variable is used to record the value of the count column. The 3rd data cell
then calculates the different betwee tht 2 variables.

There are probably other ways to achieve similar results. Let me know if
this works for you, and if not, how you'd like to see BIRT enhanced for your
usage scenario (filing a Bugzilla enhancement request is the best way to
make sure that such enhancements are tracked).

regards,
Gary

"JTan" <jamestanms@hotmail.com> wrote in message
news:dcjsbk$cev$1@news.eclipse.org...
> I have row["count(*)"] from data source 1 and row["count(*)"] from data
> source 2, I want the difference of both, how do I do that in BIRT single
> report ?
>
> Thanks for any answer.
>
>
Re: How do I manipulate two metrics from two data sources in a report ? [message #64235 is a reply to message #64216] Wed, 03 August 2005 16:47 Go to previous message
Eclipse UserFriend
Forgot the attachment


"Gary Xue" <gxue@actuate.com> wrote in message
news:dcradk$hds$1@news.eclipse.org...
> Hello,
> Cross-data set scripting support is rather limited in Birt 1.0. However it
> might still possible to do what you are asking for. See attached report
for
> example. In the afterOpen() method of each data set a global Javascript
> variable is used to record the value of the count column. The 3rd data
cell
> then calculates the different betwee tht 2 variables.
>
> There are probably other ways to achieve similar results. Let me know if
> this works for you, and if not, how you'd like to see BIRT enhanced for
your
> usage scenario (filing a Bugzilla enhancement request is the best way to
> make sure that such enhancements are tracked).
>
> regards,
> Gary
>
> "JTan" <jamestanms@hotmail.com> wrote in message
> news:dcjsbk$cev$1@news.eclipse.org...
> > I have row["count(*)"] from data source 1 and row["count(*)"] from data
> > source 2, I want the difference of both, how do I do that in BIRT single
> > report ?
> >
> > Thanks for any answer.
> >
> >
>
>


Previous Topic:Is it possible to set a jdbc driver at runtime?
Next Topic:charting over grouped aggregate functions?
Goto Forum:
  


Current Time: Tue Jul 22 13:52:51 EDT 2025

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

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

Back to the top