In another thread, I asked about an ETA for the documentation for the expression editor. After looking through the properties on the expression editor using a break point and some sample/temp data, I see that the expression editor "does" do at least half of what I need it to do, which is calculate user defined formulas from an object that is passed in. Basically, what I'm doing here is, we have a report where the user can choose which columns are shown. These are all decimal values, with the exception of 3 columns. Well, the user can also "create" a column using a formula containing any of the available decimal columns.
In order to get the fields list displayed the way I wanted, I had to create another object whose only fields/properties are the the ones that contain the available columns from the report. The new object is then passed to the expression editor as the Item. Here's an example:
NewObject (contains the following fields):
Debit
Credit
DebitYTD
CreditYTD
DebitAnnual
CreditAnnual
So far at this point, the expression editor does what I want. I can create the formula using the expression editor (i.e. Debit + Credit). In the expression editor's result preview field, the values are calculated correctly. However, since there is no documentation, I haven't been able to figure out how to get the value of the result preview from the expression editor. It's in the view model for the expression editor, but it's not public. Is there anything that is exposed that will give me the result of that calculation, as long as the expression is valid? Thanks.
Eric G.
In order to get the fields list displayed the way I wanted, I had to create another object whose only fields/properties are the the ones that contain the available columns from the report. The new object is then passed to the expression editor as the Item. Here's an example:
NewObject (contains the following fields):
Debit
Credit
DebitYTD
CreditYTD
DebitAnnual
CreditAnnual
So far at this point, the expression editor does what I want. I can create the formula using the expression editor (i.e. Debit + Credit). In the expression editor's result preview field, the values are calculated correctly. However, since there is no documentation, I haven't been able to figure out how to get the value of the result preview from the expression editor. It's in the view model for the expression editor, but it's not public. Is there anything that is exposed that will give me the result of that calculation, as long as the expression is valid? Thanks.
Eric G.