I’ve created a copy of the OrderAck RDD for a custom SSRS report and I’ve ran into an issue adding in a custom calculated field.
I can add single fields that are in the table (e.g. OrderComment in OrderDtl) however I would like to add a calculated field that takes two decimal columns and performs a calculation on them (so the calculated field would be the results from column1 - column2).
I’ve had a look at the OrderHed DataSource for the RDD and it has a calculated field called BillToAddressList but when I look in the OrderHed table I can’t see this column so I assume it’s a concatenation of some of the address columns in OrderHed.
However when I look through the RDD I can’t see where this concatenation takes place I’ve looked in the DataSources > Report Table tabs (I thought it’d be in Calculated Fields but that’s just a list of them).
I tried looking at the data set in the RDL but that’s selecting the BillToAddressList column directly so the calculation isn’t performed there.
Is there somewhere I can find this calculation so I can add one for my custom calculated field? I can do it in the RDL directly if I have to but I was hoping to avoid that if possible.
Many thanks in advance for any assistance.