Forum Discussion
Solved
Values Change in Append
I am wondering if anyone has come across this before. We have 4 seperate databases that are all setup with the same table structure. I am pulling from the data for general ledger transactions from ea...
My apologies for the delay in response here. I was on vacation when you asked the question and the email was lost in my inbox until now. I did solve this purely by luck. It appears that if you have conflicting privacy levels (and sometimes even not) the append will give different results. I turned off the following option in my reports and things stablized:
File=> Options and Settings => Options=> Privacy
From there I chose the other radio button option "Ignore the Privacy Levels and potentially improve performance".
That reduced the magnitude of the change in the number, but it will isn't adding up correctly and changes every time I hit refresh.