Calculating fields on an ssrs report? is it possible? Or should I do it different

Epicor ERP 10
,
1

I am working on producing a Customer facing ssrs quote worksheet in report builder. I have some clients that want to see line by line costs of the equipment going into the final product, BUT it shows our cost, not theirs on this report out of the box.

I really just need to calcuate the Fields!TotalCost.Value on the raw mtls report by the percentage of Fields!dspMtlMarkup on the estsummary report. so far I have been unsuccesful in this, but I am VERY novice at expressions. Is this even possible? or should I look at it a different way?

Basically part MTL cost $100 and I need to add the Markup percentage we have put into the quote sheet, so if we use a 40% markup, it calculates out MtlCost+(100*.4)

Is there a better way to do this?

2

Are you creating a BAQ to populate your SSRS? If so, you could add this as a calculated field in that BAQ. That is usually the easiest way to go. You can then preview your results in the BAQ before you start fussing with the SSRS.

3

the population is coming from the original SSRS report generated at the quote screen.

I assume to start on this,I make a baq to get my data and then add that to the data definition?

Forgive me, i pick stuff up quick, but I have never added a baq grid to the data definition or related it back.

4

If the fields are in the Dataset, I think it should be easy?

Isn’t it: MtlCost * ( 1 + MtlMarkup ) ?

5

if it is I gotta get my expression right, it errors so far…
=(Fields!TotalCost.Value, “RptParameter”)* (1+ First(Fields!dspMtlMarkup.Value, “MainDataset”))

6

It would be odd for “RptParameter” to be used as a Dataset. I would expect there to be costs for every part on every line on the estimate. Therefore, I would expect both to be “MainDataset”. I think it would make sense that the Markup is probably more of a global value for the customer, so perhaps it is the “parameter”. But you have to look at your RDL and see.
Are you using one of the canned RDLs and trying to modify it?
You may also have to lookout for data type conversions and call out to number explicitly.
You can troubleshoot that by replacing those fields with numbers until you determine what the expression error is really trying to tell you.