Re: Loading .rtm's with code
Greetings all,
I would like to load .rtm files into the database without any user. The
users are not going to have the privelege of creating, modifing, or
rearranging reports as of today. We might implement that functionality in
the future. I would like to insert .rtm's into the database and still have
reports, keys, and events hooked up correctly.
I tried to do a datapump but the reports were not hooked up correctly. I
copied all the "RB_TABLES" into a reports.gdb file and copied all tables
into a development/production .gdb file. The keys were messed up. When the
report was executed, an error poped up and said the the report was not found
but I looked in the database and it was there. I opened the report up in
design mode and tried to save it but I receieved and error saying that the
"Folder_ID" needed to be assigned. The folder_id value is 0(zero) which is
the root of the RB_Folder. Interesting little puzzle.
Regards,
Tim Armstrong
I would like to load .rtm files into the database without any user. The
users are not going to have the privelege of creating, modifing, or
rearranging reports as of today. We might implement that functionality in
the future. I would like to insert .rtm's into the database and still have
reports, keys, and events hooked up correctly.
I tried to do a datapump but the reports were not hooked up correctly. I
copied all the "RB_TABLES" into a reports.gdb file and copied all tables
into a development/production .gdb file. The keys were messed up. When the
report was executed, an error poped up and said the the report was not found
but I looked in the database and it was there. I opened the report up in
design mode and tried to save it but I receieved and error saying that the
"Folder_ID" needed to be assigned. The folder_id value is 0(zero) which is
the root of the RB_Folder. Interesting little puzzle.
Regards,
Tim Armstrong
This discussion has been closed.
Comments
Be sure that the folder_id property is being assigned to the proper field in
your database. TppReportExplorer.FolderFieldNames.FolderId := 'FolderId';
Take a look at the EndUser demo provided in the
\RBuilder\Demos\EndUser\ReportExplorer\... directory for an example of how
the ReportExplorer needs to be set up.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com