Forum Discussion
Helper IValues 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".
Resolver I
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!
Helper II really appreciate the update. Unforuatnely, I don't have an order by clause in mine.