[RBASE-L] - Re: REPORTS - Razzak's Reply

[Kyle]

Thanks Razzak.  Kyle.

At 01:19 PM 7/29/2003, you wrote:
At 10:48 AM 7/29/2003 -0500, Kyle wrote:

Is there a simple way to copy a single report
from one database to another? RBWin 6.5++
A converted report

A non-converted report


Kyle,

01. Start R:BASE 6.5++ (Build:1.866xRT03) for Windows

02. CONNECT DatabaseA IDENTIFIED BY OwnerPassword

03. At the R> Prompt:

    SET NULL -0-
    OUTPUT ReportNameW.RPT
    UNLOAD DATA FOR SYS_REPORTS2 WHERE SYS_REPORT_NAME = 'ReportName'
    OUTPUT SCREEN
    That will create two (2) files:
    ReportNameW.RPT and ReportNameW.LOB
    OUTPUT ReportNameD.RPT
    UNLOAD DATA FOR SYS_REPORTS WHERE SYS_REPORT_NAME8 = 'ReportName'
    OUTPUT SCREEN
    That will create only one (1) file:
    ReportNameD.RPT
04. Now COPY above three (3) files in the same directory of DatabaseB

05. Change the current working directory to CONNECT DatabaseB

06. CONNECT DatabaseB IDENTIFIED BY OwnerPassword

07. At the R> Prompt:

    SET NULL -0-

    DELETE ROWS FROM SYS_REPORTS2 WHERE SYS_REPORT_NAME = 'ReportName'

    DELETE ROWS FROM SYS_REPORTS WHERE SYS_REPORT_NAME8 = 'ReportName'

    INPUT ReportNameW.RPT

    INPUT ReportNameD.RPT

    Now you have both reports copied from DatabaseA to DatabaseB.

That's all there is to it!

Enjoy and make sure to have fun!

Very Best R:egards,

Razzak.