4 Replies Latest reply: Apr 3, 2017 1:56 PM by Stacy Litke RSS

    Swap Database?

    Stacy Litke

      I have two exact databases, one is month end (me1), one is previous day (st1).  I wrote a pretty elaborate report on the month end database and now I'm being asked to provide it mid-month as well so I want to switch from the me1 db to the st1 version.  Same tables, same fields.  Is that even possible?  I can't find a spot anwhere that allows me to change the source.  It doesn't look like I have change path options like when I use PDFs or spreadsheets.  When I try going back to start page it adds in the whole second database, or if I start with the st1 database and then try and open the report workspace, it wants me to close my existing workspace. 

       

      BLARGH. Really hoping I don't have to rewrite the whole report...  Any ideas?