Hi All,

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.

Thank you