At 06:18 AM 7/7/2009, John Docherty wrote:

Having two monitors on the desktop opens up a few more possibilities
and one thing that would be useful would be to be able to have some
more windows open while allowing the focus to be switched back to
database explorer etc. For example it would be useful to be able to
use the print preview window to display data using a report, and then,
while having the print preview screen open on one monitor, use that to
edit data on the other (similarly for the data dictionary). I was just
wondering if allowing such things to happen would be feasible? (I could
open two versions of the same database, but ....)

John,

Did you know that you can PRINT report(s) on SCREEN as MDI which will
allow you to move the report to the side (or other monitor) and give
control back to you to do other stuff without closing the report?

Here's how:

-- Example 01 (Printing single report as MDI)

   IF (CVAL('DATABASE')) <> 'RRBYW16' OR (CVAL('DATABASE')) IS NULL THEN
      CONNECT RRBYW16 IDENTIFIED BY NONE
   ENDIF
   CLS
   PRINT Invoice WHERE TransID = 1002 OPTION SCREEN MDI +
   |WINDOW_STATE MAXIMIZED +
   |ZOOM_TYPE PERCENTAGE +
   |ZOOMPERCENT 62 +
   |THEMENAME Vista CG +
   |PREVIEW_CAPTION Running R:BASE Your Way!
   RETURN

-- Example 02 (Printing multiple reports as MDI)
   IF (CVAL('DATABASE')) <> 'RRBYW16' OR (CVAL('DATABASE')) IS NULL THEN
      CONNECT RRBYW16 IDENTIFIED BY NONE
   ENDIF
   CLS
   -- First Report
   PRINT SalesSumAndSubTot WHERE CustID = 127 +
   OPTION SCREEN MDI +
   |ZOOM_TYPE PERCENTAGE +
   |ZOOMPERCENT 90 +
   |THEMENAME Vista CG +
   |PREVIEW_BACKGROUND_COLOR [R234,G234,B234] +
   |PREVIEW_CAPTION Running R:BASE Your Way! +
   |TOP 100 +
   |LEFT 100
   -- Second Report
   CLS
   PRINT Invoice WHERE TransID = 1002 +
   OPTION SCREEN MDI +
   |ZOOM_TYPE PERCENTAGE +
   |ZOOMPERCENT 90 +
   |THEMENAME Convergence +
   |PREVIEW_BACKGROUND_COLOR 16180442 +
   |PREVIEW_CAPTION Running R:BASE Your Way! +
   |TOP 130 +
   |LEFT 120
   -- Third Report
   CLS
   PRINT Invoice WHERE TransID = 1009 +
   OPTION SCREEN MDI +
   |ZOOM_TYPE PERCENTAGE +
   |ZOOMPERCENT 90 +
   |THEMENAME Wood +
   |PREVIEW_BACKGROUND_COLOR [R234,G234,B234] +
   |PREVIEW_CAPTION Running R:BASE Your Way! +
   |TOP 160 +
   |LEFT 140
   -- Fourth Report
   CLS
   PRINT Invoice WHERE TransID = 1010  +
   OPTION SCREEN MDI +
   |ZOOM_TYPE PERCENTAGE +
   |ZOOMPERCENT 90 +
   |THEMENAME Homestead  +
   |PREVIEW_BACKGROUND_COLOR [R81,G81,B81] +
   |PREVIEW_CAPTION Running R:BASE Your Way!' +
   |TOP 190 +
   |LEFT 160

That's all there is to it!

Very Best R:egards,

Razzak.


Reply via email to