How are Data Definition "Calculated Fields" calculated?!


(Adam Szymanski) #1

I understand how the calculated fields work in E9 BAQs, but how do they work in Data Definitions? For instance, the definition for Sales Order Pick List has the OrderRel table. Under that, there are a bunch of “report calculated fields”, one being “ShipToAddr”. Where is the system pulling “ShipToAddr” from?! Is there some way for me to view this? Is there a master list of calculated fields for particular tables?

Thanks.


(Jose C Gomez) #2

These are done in the program that puts together the RDD, not something you can modify


(Adam Szymanski) #3

I’m okay with not being able to modify them, but is there a way to see which ones are available?

Also, “RDD”?


(Jose C Gomez) #4

Report Data Definition = RDD
Everything that is available in the RDD is available to report


(Adam Szymanski) #5

I see how in the RDD I can include/exclude fields under the “Excluded Fields” tab, but on some RDDs someone added various “Calculated Fields” in the Calculated Fields tab. When I just arbitrarily try to add “Calculated Field” entries they never work. Isn’t there some way for me determine which Calculated Fields are available for particular tables?.. basically, I’m trying to figure out how to use the Calculated Fields area in RDDs… I see how to delete them, just now how to properly add one.

Thanks.


(Brian Garver) #6

You can not add calculated fields to an RDD. You can, however, add a calculated field to either the Crystal or SSRS report so long as you include the fields in the RDD that are needed for the calculation.


(Jose C Gomez) #7

You can’t add your own unless you are using the SDK


(Adam Szymanski) #8

Thank you. I guess I don’t understand why I am able to add lines to the Calculated Fields area on RDD.


(Andrew Saldivar) #9

I ran into the same frustration when I started modifying reports. The editor lets you chug along happily thinking that you are creating a calculated field. Nothing in the software tells you that it won’t work… until you look for your result which will never include the “calculated field” you thought you were creating. That functionality simply does not work - even though it appears to.


(Adam Szymanski) #10

Yup. I’m still a bit confused. For instance, two RDDs: 1) OrderAck and 2) SOPick. Both have the OrderHed table, but only OrderAck has the calculated field “MultiShipTo”. I need the “MultiShipTo” to show up in the SOPick RDD. Why doesn’t it?


(Jose C Gomez) #11

Calculated fields are unique to each RDD and they are coded in the RDD processing. They are not something that is available on the database they are as the name states “Calculated Fields”, there is a formula in the RDD code that calculates these values.
You can create your own calculated field in Crystal though to determine if there are multiple ShipTo’s or not


(Adam Szymanski) #12

So, the only point of adding a calculated field in a RDD is to just setup a blank variable to send to the report? (I don’t understand why Epicor allows me to create calculated field entries)


(Jose C Gomez) #13

It’s not for you :slight_smile: it is there to use if you buy the SDK don’t worry about it, just create your own fields in Crystal / SSRS


(Adam Szymanski) #14

Gotcha. That helps. Thank you.


(Michael Schmdt) #15

Not sure if I should piggy-back off this thread, or start my own. I’m trying to figure out how a data definition field is calculated, because there appears to be some duplicate values being added in a report (a certain charge is being added twice to a quote and it shouldn’t be), and I’m trying to track back where the duplication is occurring. However, I run into these fields such as “Calc_Misc” and it seems opaque and I cannot tell where the value is coming from or if it’s why I am getting a duplicate value. Is there some way to figure this out?


(Jose C Gomez) #16

No way to know without the sdk


(John Mitchell) #17

https://www.jetbrains.com/decompiler/ or https://www.telerik.com/products/decompiler.aspx