Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » New To BIRT(column aggregation)
New To BIRT [message #692953] Tue, 05 July 2011 14:38 Go to next message
Rory  is currently offline Rory Friend
Messages: 7
Registered: July 2011
Junior Member
Hello Everyone,

I'm new to BIRT and my first project requires an aggregation of columns. If I have a data set with columns "Item Cost" "Level 1 Markup" "Level 2 Markup" and "Level 3 Markup" how can I multiply "Item Cost" and "Level 1 Markup" in a new column? after I do this I need to Multiply the new column by the "level 2 markup" in another new column. any help would be greatly appreciated.

Rory St. Jean
Re: New To BIRT [message #692990 is a reply to message #692953] Tue, 05 July 2011 14:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Rory,

You can do this by adding computed columns to the dataset or adding
columns to the table bindings. Look at the attached example that shows
both methods. Table one uses the dataset computed columns and table two
uses the new bindings for the table report item,

Jason

On 7/5/2011 10:38 AM, Rory wrote:
> Hello Everyone,
>
> I'm new to BIRT and my first project requires an aggregation of columns.
> If I have a data set with columns "Item Cost" "Level 1 Markup" "Level 2
> Markup" and "Level 3 Markup" how can I multiply "Item Cost" and "Level 1
> Markup" in a new column? after I do this I need to Multiply the new
> column by the "level 2 markup" in another new column. any help would be
> greatly appreciated.
>
> Rory St. Jean
Re: New To BIRT [message #693003 is a reply to message #692990] Tue, 05 July 2011 15:53 Go to previous messageGo to next message
Rory  is currently offline Rory Friend
Messages: 7
Registered: July 2011
Junior Member
Thank You Jason! Sorry for the simple questions, I'm trying to read through the Birt: Afield Guide to Reporting Book, but I'm a finance guy and I'm trying to get used to writing reports with sql and this BIRT software so thanks for bearing with me. Are there any classes or seminars related the BIRT software?
Re: New To BIRT [message #693026 is a reply to message #693003] Tue, 05 July 2011 16:16 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Rory,

BIRT Exchange has webinars on various features and a lot examples in the
dev share. You may want to look at:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/974-webinar-archive-using-the-birt-designer/

Jason

On 7/5/2011 11:53 AM, Rory wrote:
> Thank You Jason! Sorry for the simple questions, I'm trying to read
> through the Birt: Afield Guide to Reporting Book, but I'm a finance guy
> and I'm trying to get used to writing reports with sql and this BIRT
> software so thanks for bearing with me. Are there any classes or
> seminars related the BIRT software?
Previous Topic:Visibility: hide cross tab when null cube
Next Topic:(no subject)
Goto Forum:
  


Current Time: Mon Dec 22 00:43:18 GMT 2014

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

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