Edit and change RTM

rbuser

How can I Edit, Change a report in rtm ?

Is There an Utility or EXE ?

thanks...

--
ISCOPYME, S.L.
Servicios Inform?ticos.

C/ Pintores, N? 19.
03590 - ALTEA - Alicante
Espa?a.

www.iscopyme.com
Administraci?n : admin@iscopyme.com
Depto. Software : soft@iscopyme.com
SAT : sat@iscopyme.com

nicocizik

Hi Jamie,

If you would just like to change the report layout using the Report
Designer, you can open an existing .rtm file using the File | Open menu
option inside the Report Designer.

Check out the following example. This example extracts the .rtm text and
allows you to edit it by hand at run-time before saving it back down to the
hard drive.

http://www.digital-metaphors.com/tips/EditTemplatesAsText.zip

--

rbuser

I need the structure of the table tbitem...

rbuser

I'm working with IBX

nicocizik

Hi Jamie,

Here is the SQL used to create the rbItem table for the IBX enduser
solution. To view the rest of the SQL used to create the rest of the
tables, see the CreateEndUserTables.sql file located in the
\RBuilder\Demos\EndUser Databases\Interbase\... directory.

/* create Item table */

CREATE TABLE rb_item
(item_id INTEGER,
folder_id INTEGER NOT NULL,
name VARCHAR(60) NOT NULL,
item_size INTEGER,
item_type INTEGER NOT NULL,
modified DOUBLE PRECISION NOT NULL,
deleted DOUBLE PRECISION,
template BLOB SUB_TYPE 0 SEGMENT SIZE 400,
PRIMARY KEY (folder_id, item_type, name, modified));

CREATE INDEX item_id_idx ON rb_item (item_id);

CREATE INDEX item_folder_type_name_idx ON rb_item (folder_id, item_type,
name);


COMMIT;

/* create generator for item id */

CREATE GENERATOR item_id_gen;
SET GENERATOR item_id_gen to 1;

/* create trigger to add unique item id */

SET TERM !! ;
CREATE TRIGGER set_item_id FOR rb_item
BEFORE INSERT
AS
BEGIN
new.item_id = gen_id(item_id_gen, 1);
END !!
SET TERM ; !!
COMMIT;


--