September 8, 2013 at 4:19 am
Hi all,
I want to reuse existing report to another database with same tabular structure. However, I want to preserve historic data as well. I mean if i have to create new report I will need to write new queries but I just want to use same query with only change in database name. is there any precise way??
Thanks in advance.
Mg
September 9, 2013 at 4:00 am
you can copy the report and then use the same query but change the datasource to the new database.
September 9, 2013 at 10:39 pm
Thank you for the reply. But in that case I have to manage two reports. let me describe my scenario in detail.
I have two database. A and B
previously I have been using A for my reporting. Now I want to use B database and also need to preserve historic reports from A. My reports are large so if i go through manual approach I have to change all the queries (i.e A$tablename to B$tablename). So exploring if there is any alternative approach. Hoping for your reply.
Many thanks!!
September 10, 2013 at 5:58 am
In that case, can you not just change the datasource (unless you have the database hardcoded)?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply