but for some reason the custom code that I write in the Report properties simply disappears when I reopen the VS. And also all the functions I write they are not not recognizable by the compiler in the Expressions, e.g if I write “Code!MyFunc()” - I get an error that MyFunc doesn’t exist.
I guess the above is some bug of VS(SSRS) & AX integration
I appreciate your response, but in my case there is a grouping in the tablix, therefore the expressions in cells look like iif(sum(DS.FieldA)/something, ValueA, ValueB), where sum is for group
As such following your suggested approach Totals expression would look like
Sum (iif(sum(DS.FieldA)/something, ValueA, ValueB))
where inner SUM looses it’s sence as it should be in my case taken per group whilst here it just becomes a normal sum
Sum has a parameter for this scenario. Let me quote the documentation:
scope
(String) Optional. The name of a dataset, group, or data region that contains the report items to which to apply the aggregate function. If scope is not specified, the current scope is used.
Expression must not contain First, Last, Previous, or RunningValue functions.
"
As such i can’t use my formulas in the totals ((
It could be wonderful if I could use custom code for the running total(as I’ve described at the beginning), but still have got no clue, why I cant(code written in the Report parameters doesn’t get saved for some reason)