SQL Server 2000 Reporting Server
Windows Server 2003 Enterprise
IIS 6.0
I am having a problem with reports showing data that should be blank. I made sure all the queries work correctly and they do. When I run the same reports from within VS 2003 they render correctly. It seems that the server might have values saved in the cache and is then filling in the blanks with values it had from the same reports on different Permits.
I really am not sure what to do. If anyone has any ideas please let me know.