Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Joining Data from Multiple tables(Joining Data from Multiple tables)
Joining Data from Multiple tables [message #1266351] Fri, 07 March 2014 10:21 Go to next message
Pratik Gadiya is currently offline Pratik GadiyaFriend
Messages: 1
Registered: March 2014
Junior Member
Hi All,

I have a database consisting of total usage of a service for all the customers.
My requirement is I need to generate BIRT report for all the customers in which I need to calculate the difference between total usage of previous month and current month.

So, there will be just 2 parameters as input from the user:
1. Current Month Start Date time and
2. Current Month End Date time.

From both this input values, I have calculated the previous month start and end date time.

Finally, now I have 2 isolated tables in which I have calculated the total usage:
a. Current Month total usage
b. Previous Month total usage.

My page Layout for the tables is attached with the Post.

Please let me know how can I calculate the difference between column highlighted in the attachment.

Thanks,
Pratik




Re: Joining Data from Multiple tables [message #1266505 is a reply to message #1266351] Fri, 07 March 2014 14:50 Go to previous message
Eric Rizzo is currently offline Eric RizzoFriend
Messages: 3071
Registered: July 2009
Senior Member
Moving this to the BIRT forum.
Previous Topic:Cannot set the string value (value) to parameter 2. Invalid Column Index
Next Topic:Populating Arraylist from Dataset
Goto Forum:
  


Current Time: Wed Oct 17 09:27:21 GMT 2018

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

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

Back to the top