Merging reports in from another database

rbuser

Hi all,

I have a general database that we store all of our pre-canned reports in for
our customers. Our customers have their own databases which may or may not
already contain the reports that they have saved. I wish to hook up to each
database and move our canned reports into the report explorer of the user.

We are using Interbase as our database. We have no problem hooking up to
each database. But, when we try to move the reports (which are in several
folders), it seems to get confused and all of the reports end up in the
wrong folders, etc. And, when they add a new folder it gets screwed up.

Has anyone done this and can give some hints on how to move/merge reports
and folders into another database?

TIA,
Stacey

nicocizik

Hi Stacey,

When adding new reports or folders with the ReportExporer, you will see that
it automatically updates the Folders and Items tables accordingly. You need
to make sure that if you are updating these table manually that all the
values in these tables are sufficient for the specific table structure of
your user. For instance, if you want to create a new folder with all your
pre-canned reports in it, you will need to be sure the folder_id is unique
and that the parent_id is set to the root folder. My suggestion would be to
take a look at the data in one of these tables using the IBConsole and see
what can and can't be done.

--