I want to build a word report.
I have two data cases: data_yes.json and data_no.json.
(I have enabled the AllowMissingMembers feature.)
However, when I was calculating the subtraction, It reported the wrong:
buildReport Failed:{“RequestId”:“Root=1-6107b8af-39132c372a072f026a2b35d5”,“Error”:{“Code”:“ErrorInvalidInputData”,“DateTime”:“0001-01-01T00:00:00Z”,“Description”:“Operation Failed. The input data is not valid.”,“InnerError”:{“DateTime”:“0001-01-01T00:00:00Z”,“Message”:“An error has been encountered at the end of expression ‘((totalSpace-availSpace)*’. Can not apply operator ‘-’ to operands of type ‘System.Object’ and ‘System.Object’.”},“Message”:“Error while build report”}}
I think when the data is missing,the following logical judgments should be skipped.
question1: Is there a way to solve it?(Attached is my sample code.)
build_word_report2.zip (16.5 KB)
question2: Sometimes my data looks like this: 10.1.1.1:8080.
When I build the word report,I want to split the string by “:” and get the first element in the array , such as IP 10.1.1.1.
Is there a similar function like “$var.split(’:’)[0]” in LINQ Reporting Engine?