CrossTab and Expressions

2 posts, 0 answers
  1. Michele
    Michele avatar
    1 posts
    Member since:
    Sep 2014

    Posted 15 Oct 2014 Link to this post

    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
  2. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 17 Oct 2014 in reply to Michele Link to this post

    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
Back to Top