Hello,
I have another issue. I am making a report based on the query that I solved the issue with yesterday.
It is in the report called “Billing Summary” in the attached file.
Whenever I try to add a accumulation function to “price” field, Base crashes.
I would like to make this filed the sum of prices for the transaction (TRX_ID).
It seems a simple thing but somehow it crashes every time…
I’d appreciate if someone could take a look.
Thanks in advance.
inquiryfile.odb
Hello,
Got main (overall) total to work but after adding the necessary footer for TRX the additional accumulator kept hanging.
Based on this, it is probably a bug. Check Bugzilla for existing and if none report.
However, you can still have this total. Instead I created a function (TRXprice) to accumulate this total:
The attached contains the revised report: FixedReportTotal.odb
Edit 2018-05-25:
As stated above, first I created the new Function before I used it in a field. Using the Report Navigator (from toolbar) double clicked on TRX_ID then right clicked on Function and selected New Function and entered as:
Once this was created, it can be used in a field:
Just select for Data Field Type User Defined Function and the newly created function should be in the Function dropdown list.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
Thank you for the above. However, I cannot create the accumulated field of TRXprice. I placed new field by labeling "Total TRX Billed. Then in the property of the field, I try to set up the function - “TRXprice” . I cannot see this field name as an option to choose from. I checked the underlying query (PriceAppendQ) if there is a new field set up there. I cannot find it there either. Can you explain how you could choose the newly created field under the pulldown menu of function ?
Thank you for the above. However, I cannot create the accumulated field of TRXprice. I placed new field by labeling "Total TRX Billed. Then in the property of the field, I try to set up the function - “TRXprice” . I cannot see this field name as an option to choose from. I checked the underlying query (PriceAppendQ) if there is a new field set up there. I cannot find it there either. Can you explain how you could choose the newly created field under the pulldown menu of function ?
Thank you. I will look into the list of bugs on Bugzilla. I could create a new field and get the total billed for TRX_ID. Thank you again!
