Happy New Year!

I may be missing something, but where is "Report Builder"? BRW is great for presentation reports, but for fast development, Report Builder was great. I know my old RBLayout reports are present but I can't find them to save my life. Is Report Builder still in OI10 and if so where and where in the records can I find my RBLayout reports?

Richard Richter

The product seems to suggest that Report Builder is severely deprecated and will be removed in 10.1. For now it can be accessed by typing EXEC ORMAIN32_MDI from the system monitor.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

The product seems to suggest that Report Builder is severely deprecated and will be removed in 10.1. For now it can be accessed by typing EXEC ORMAIN32_MDI from the system monitor.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

This is my understanding as well. Although it is curious that the New Entity dialog provides for Reports > Report-Bulder Report but when selected it still launches the BRW. Perhaps that is part of the deprecation roll-out?

Don Bakke

SRP Computer Solutions, Inc.

Well it actually launches the Report Builder → BRW conversion tool with a limited option to launch ORMAIN32_MDI so I just thought EXECing was quicker :).

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

Well it actually launches the Report Builder → BRW conversion tool with a limited option to launch ORMAIN32_MDI so I just thought EXECing was quicker :).

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

Hmmm…if I attempt to open an existing Report Builder report then I see the conversion tool, but if I attempt to create a new entity then I only get the BRW Designer (which is what I think Richard is trying to do).

I get that new Report Builder reports is not supported, but it is confusing to have that entity class appear in the New Entity dialog.

Don Bakke

SRP Computer Solutions, Inc.

The report builder is not implemented in OI10. We intended to implement it as a tool that would assist you with constructing an RLIST statement, then pass it off to the BRW to where you could enhance the look and feel. A program named RTI_XBAND implements the RLIST to BRW conversion

The RBLAYOUT converter calls that program, or you can call it yourself by appending (X or (B to an rlist statement.

From TCL

LIST MYTABLE  MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" ...  (B

will generate a BRW report with the headings, fonts, colors, etc, then open the BRW report for further editing

LIST MYTABLE  MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" ...  (X

will generate and immediately execute the brw report without saving it

You can use the TCL assistant to help generate a quick report, then append (B to the statement to generate a BRW report from that rlist statement. That effective replaces the report builder.

You can also call run_report with an rlist statement and an option of (B or (X

call run_Report('', 'LIST MYTABLE  MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" ... ', '(X'  )

to programatically generate brw reports on the fly

BTW, in OI10, RLIST has better support for the OLIST/RUN_REPORT syntax, and

RLIST equates has been expanded to include options for BRW execution as well

Equ TARGET_BRWDESIGN$ To 9

Equ TARGET_BRWRUN$ To 10

You can use code like

statement = 'LIST MYTABLE  MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" ... '

call RLIST(statement, TARGET_BRWRUN$)

to get the same result as run_report(, statement, '(X' ) </QUOTE> —- === At 30 DEC 2020 09:48AM Andrew McAuley wrote: === <QUOTE>Post removed by author </QUOTE> —- === At 30 DEC 2020 09:48AM Andrew McAuley wrote: === <QUOTE>You are of course correct. I didn’t actually use entity new I used open :) The Sprezzatura Group The Sprezzatura Blog World leaders in all things RevSoft </QUOTE> —- === At 30 DEC 2020 10:22AM bob carten wrote: === <QUOTE> Sorry for the confusion and lack of documentation. The reporting has been a moving target. The goals for 10 were to improve performance, unify rlist / olist syntax, embrace the BRW as the tool for formatted reports. The reportbuilder was slotted for a re-write, so we left all the pieces there. We have some loose ends to clean up. </QUOTE> —- === At 30 DEC 2020 04:10PM Richard Richter wrote: === <QUOTE> <QUOTE> The report builder is not implemented in OI10. We intended to implement it as a tool that would assist you with constructing an RLIST statement, then pass it off to the BRW to where you could enhance the look and feel. A program named RTI_XBAND implements the RLIST to BRW conversion The RBLAYOUT converter calls that program, or you can call it yourself by appending (X or (B to an rlist statement. From TCL <code> LIST MYTABLE MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" … (B </code> will generate a BRW report with the headings, fonts, colors, etc, then open the BRW report for further editing <code> LIST MYTABLE MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" … (X </code> will generate and immediately execute the brw report without saving it You can use the TCL assistant to help generate a quick report, then append (B to the statement to generate a BRW report from that rlist statement. That effective replaces the report builder. You can also call run_report with an rlist statement and an option of (B or (X <code> call run_Report(, 'LIST MYTABLE MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" … ', '(X' ) </code>

to programatically generate brw reports on the fly

BTW, in OI10, RLIST has better support for the OLIST/RUN_REPORT syntax, and

RLIST equates has been expanded to include options for BRW execution as well

Equ TARGET_BRWDESIGN$ To 9

Equ TARGET_BRWRUN$ To 10

You can use code like

statement = 'LIST MYTABLE  MYCOLUMN COLHEAD "MYHEADING" COLFONT "CASCADIA" ... '

call RLIST(statement, TARGET_BRWRUN$)

to get the same result as run_report('', statement, '(X' )

Thank-you for your help. Now I've got a good work around and don't need Report Builder itself. Have a Happy and Healthy New Year!

Richard Richter

</QUOTE>

View this thread on the Works forum...