1. Elvis Cardenas
  2. PowerBuilder
  3. Friday, 23 August 2024 23:11 PM UTC

I have a report in a data window that calls functions within the application to make calculations when retrieving the report, however each action that a user performs on it the calculation is performed again, weighing the actions performed. I want to know how to do the calculation only once when recovering the report or if there is a function where I can enable or disable the data window from making these calls.

 

 

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 23 August 2024 23:28 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Elvis;

  I think that you might have answered your own question in that ... "Why are you allowing data entry within a report"? All columns in that DWO should be protected.

  You should be using a report DWO for only just that - reporting  Then have a detail DWO to interact with the App user ( no calculations) for data updates. Then when all the data changes are applied, then refresh the report DWO. Just my $0.02.

Regards ... Chris 

Comment
  1. Elvis Cardenas
  2. Friday, 23 August 2024 23:46 PM UTC


By requirement, a checkbox column is added to select which record will be processed and this will generate the recalculations. I will follow your advice to change this functionality. thank you so much.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Sunday, 25 August 2024 17:04 PM UTC
  2. PowerBuilder
  3. # 1

My understanding is that the Timer Interval controls how often expressions and calculated fields are processed. The default 0 is one minute (60000 milliseconds). You could try changing it to a higher number.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.