I have a sql database and a set of reports that point to that database. I have now copied that database to a 'new' database on the same sql server. I have made some changes to the data so that I would know the different but the structure and object names remain exactly the same. This 'new' database will be our demo version.
I went into CR9 and opened up one of the reports and then chose Set Database Location. I created a new SQL connect to the same server, same User ID, same password, but a different database. It seemed to work and when I looked at he properties under the server name the reading against 'Initial Catalog' was the 'new' database. However when I chose to preview the report it ran ok but it show data from it's original database not the 'new' database.
In VB/ASP code using connectionproperties.item("Initial Catalog") = . I also tried it in CR XI but got the same result. From experience I do know that changing server, user id, and password work.
My first thoughts was that I was doing something wrong, missing something but I cannot think what. Can you please help meOpen the report and do verify database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment