Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Multiply two columns in BIRT
vivekpv10
I am new in birt report tool.In my requirement i am calling 2 functions through query(Two separate datasets.ie dset2 and dset3) which yield 2 columns.Table is bind to another dataset(ie:dset1).Now i need to show these 2 columns along with another column by multiplying these 2 columns.How can i do this BIRT?
Find more posts tagged with
Comments
johnw
Using some scripting. Since you are working with sub-tables the values of the sub-tables are out of scope in the parent table. If you use a little scripting, you can set a global variable in the child table, and use them for calculations in the parent table. Take a look at the attached example. In it I am getting a number in child table A and B, and multiplying them in the parent table.
vivekpv10
@Johnw
..In my case there are not multiple table,only single table binding to a dataset dset1.In that table i am using data from another dataset dset2.Input Parameters for dset2 comes from dset1.In that case how can i implement your solution?
vivekpv10
thanks ..it is working..earlier forgot to add report variable.