Hi christian, Thanks for your response. The data source is sql server 2008 and we are not using caching. I've got the cacheable checkbox unchecked in the RPD as well as cache enabled checkbox unchecked in the EM.

Thank you everyone for your responses!

Hi Sherry, Thanks for those links, i'm going to try to get a hold of our support identifier # so that i can see those documents and finally rebuild the whole union report to see if that does helps. Thanks a lot for your time!

Hi Sherry, We are on 11.1.1.7.150120. Yea i checked to make sure nothing was hard-coded, thats why i'm so surprised its getting hard-coded for the date that i used to test it! The date prompts are fetched from another saved report too so theres no chance of a hard-coded notion anywhere. I didnt use any selection steps but…