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".
I really appreciate your thoughts! It is 4 sql statements that are written the same way, pulling the same columns and years, but connected to 4 differnent databases.
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.
I actually just fixed mine. In my original queries, I added an order by clause at the end. I don't know why this fixed it, but it did!
ORDER BY [TABLE_NAME].[COLUMN_NAME] ASC
Maybe this will fix yours as well? Good luck!
I really appreciate the update. Unforuatnely, I don't have an order by clause in mine.