Forum Discussion
Values Change in Append
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".
Did you figure out why this is happening? I'm having the same issue.
I have two queries being appended into one. Each time I refresh the values from the appended table change, even though the values in the original two queries stays the same.
No I have not. I think I am going to have to open a ticket with Microsoft to help with this issue.