Skip to main content
Solved

How to use reset expression in variables in report designer?


Forum|alt.badge.img

in a report when I do few calculations always, I got incorrect values, I have posted another question in the community. Link is below. 

Error in Calculations of simple formular in Reports

I guess this occurred due to the variable is not reset correctly. So how to use this reset option, please provide few examples.



 

Best answer by PDharmasena10

I was able to fix this issue. As I explained above my real problem is about error in calculation result. I delete that textbox (UI element) and recreate it. then it was solved. I hope it may be a onetime error. 

View original
Did this topic help you find an answer to your question?

7 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • July 9, 2024

@PDharmasena10  Have you already resetting the Group, is still not reset the variable value?


Forum|alt.badge.img
  • Author
  • Varsity I
  • 49 replies
  • July 10, 2024

@Naveen Boga As I shown in the screenshot, I have added resetGroup, my real issue is in a report I get project total income and total expenses from two separate report. when I print these values in the main report it prints correctly but when print the difference (totalIncome - totalExpense) it prints incorrect values. But there is pattern in that Value. As example 0 - 700 will print -1700, it always adds a prefix number to the correct answer, that prefix number changes time to time. I guess that issue occurred due to not resetting the variable correctly. 

This is the link for my previous question
Error in Calculations of simple formular in Reports


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • July 11, 2024

Understood! @BenjaminCrisman could you please shed some light on this?


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 626 replies
  • July 11, 2024

Unfortunately I don’t do very well with keeping track of variables and reporting in my head, having the report to check would be really useful.

Have you tried adjusting the process order of the variable or the subreports?

Is it possible to upload the .rpx file to review?


Forum|alt.badge.img
  • Author
  • Varsity I
  • 49 replies
  • July 15, 2024

Hi @BenjaminCrisman Herewith attached the report files. PM600014 is the main report. other two are the sub reports


Forum|alt.badge.img
  • Author
  • Varsity I
  • 49 replies
  • Answer
  • July 19, 2024

I was able to fix this issue. As I explained above my real problem is about error in calculation result. I delete that textbox (UI element) and recreate it. then it was solved. I hope it may be a onetime error. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • July 19, 2024

Thank you for sharing your solution with the community @PDharmasena10!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings