Method Community

Hi Karen, You could use calculated fields in the Report Designer.  Just right click on the table at the top right of the designer and add a calculated field.  You can then create an expression to add the values of the fields you want.  It should look like this: First right click to add the field, then right click again and ...

Hi LaCrews, I don't think it is. I'm also gonna suggest you take a quick gander at this post...it should answer your questions (but if you have more feel free to ask) http://www.methodintegration.com/cs/forums/t/3820.aspx Dave

Hi, You can find a list of Method actions and some examples on our Action References section of the Help Center.  If you have any additional questions, let us know and we'll be happy to help. - Adam

Dear Mr. Adam,  Thank you for prompt response and applogies for late thank note... Anyway Thank you a lot... Where can find complete reference of all Method actions along with examples?  Regards, ASK AINiT.net.au

Dave I may have answered my own question.  It looks like I can use a select call to download the document field from the document library table.  Would you happen to know if this is base64 encoded?

Adam, No, actually I was hoping there was a way to add values in fields on the report together - but it seems like this is not possible.  They are not fields in a Method table/screen.  They are label fields on the report that are summing the amount field from Method.  I want to add 3 "sums" together. Karen

Hi Karen, I'm assuming the other fields are field on screen?  If so, I would put this calculated field in whatever table/screen this report is generated from.  If you don't need the field on screen, you can hide it.  You can then do the calculations on screen, using the Basic Math Calculation ...

Hi LaCrews, Can you elaborate what calls in particular did you have in mind? Dave

A user asked how to find and update the calculations done on the EstimateLine grid on the stock Estimate screen. Karen,  The calculations for the items in the EstimateLine grid are done in the Text Change event in the actions for the Item field. If you would like to take out your purchase cost completely and use ...

Is there a way to have a calculated field that looks at 3 other fields on the report to calculate the total of those three fields?  For example, I have an Opening balance field, a total Charges field and a total received field.  I want to calculate the ending balance by taking the opening balance, subtracting the amount in the charges ...