Anyone has any idea how I can achieve this:
Dynamically changing calculation formula if parameter is changed.
so let's say I have table formula:
select '(Fields!A.Value + Fields!B.Value)/Fields!C.Value' as formula, 'A' as keycol union
select 'Fields!A.Value/Fields!C.Value' as formula, 'B' as keycol
and i have a value table:
select 1 as A, 2 as B, 3 as C
now, i then have a parameter which consist of 2 values (A and B).
if user selects A, it will use formula A from table formula, and obviously it will use B if user selects parameter B.
Is there anyway I can dynamically generate or update the xml to change the value of my table to show the correct formula?
Hopefully my question make sense.