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.