Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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?

Report message to a moderator

Previous Topic:Visibility: hide cross tab when null cube
Next Topic:(no subject)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 21:47:50 GMT 2024

Powered by FUDForum. Page generated in 0.03772 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