I created an adhoc report model using SQL Server 2008 reporting services. I am using data from a SQL 2000 database sitting on a SQL 2000 server. I created
reports with start date and end date parameters, everything worked fine.
Now my ad hoc report model uses a SQL 2000 database (this database is a replication of the database I was using) sitting on a SQL 2008 server. When
I change parameters like start date and end dates, data doesn’t refresh. It shows the same data for any date range.
Has anyone seen this problem? What could be done to fix the issue. Is there any setting on the SQL server to fix this?
View Complete Post