Hi all,
I have a CrossTab (Telerik Reporting V4.0.10.317 - 2011) with two grouping settings on "Fields.ASSET" and "Fields.PRDCT_NM" (product name) columns and a "=SUM(Fields.AMOUNT)" expression relative to the product.Basically, there are 4 types of products (generating 4 rows for every asset) : "p10", "p50", "p90" and "det", each with his subtotal amount.What I need is to access and store for every asset, to the subtotal, and use these 4 values in a logic like this:
when the subtotal for "det" product (for the current asset) is greater than "p90" sub -> use a formula to calculate ,when the subtotal for "det" product is between "p90" and "p50" subs -> use other formula
and so on ... storing the result of that formula in another cell of my crosstabI've found the "Exec(scope, expression)" Expression, but don't know how to implement the "when" logic based on the product nameCan this be done directly with an expression or I need to catch che item data bound event and search for a workaround?
Thanks in advanceMichele
I have a CrossTab (Telerik Reporting V4.0.10.317 - 2011) with two grouping settings on "Fields.ASSET" and "Fields.PRDCT_NM" (product name) columns and a "=SUM(Fields.AMOUNT)" expression relative to the product.Basically, there are 4 types of products (generating 4 rows for every asset) : "p10", "p50", "p90" and "det", each with his subtotal amount.What I need is to access and store for every asset, to the subtotal, and use these 4 values in a logic like this:
when the subtotal for "det" product (for the current asset) is greater than "p90" sub -> use a formula to calculate ,when the subtotal for "det" product is between "p90" and "p50" subs -> use other formula
and so on ... storing the result of that formula in another cell of my crosstabI've found the "Exec(scope, expression)" Expression, but don't know how to implement the "when" logic based on the product nameCan this be done directly with an expression or I need to catch che item data bound event and search for a workaround?
Thanks in advanceMichele
1 Answer, 1 is accepted
0
KS
Top achievements
Rank 1
Rank 1
answered on 17 Oct 2014, 04:45 PM
Hi,
Products rows will appear dynamically and their data scope is the same... I think the Exec function, and a custom aggregate or custom user function which works with the group's data will do the work.
-KS
Products rows will appear dynamically and their data scope is the same... I think the Exec function, and a custom aggregate or custom user function which works with the group's data will do the work.
-KS