Eclipse Community Forums: BIRT

Home » Archived » BIRT » New To BIRT(column aggregation)

Tue, 05 July 2011 10:38

Eclipse User

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 10:56

Eclipse User

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

Attachment: computedcolaggr.rptdesign
(Size: 29.81KB, Downloaded 234 times)

Re: New To BIRT [message #693003 is a reply to message #692990]

Tue, 05 July 2011 11:53

Eclipse User

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 12:16

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 14:31:13 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter