I'm trying to run a Revelation Reporter report named "TEST" to the screen using REVRPT.

In a Button Control, I used the CLICK QuickEvent. I selected Execute a Procedure. Under Send Message To Entity I entered "SYSPROG*STPROCEXEREVRPT". Under Parameter I entered 1,"TEST",1. When I test run the form and click the button, I get the following windows in quick succession: Revelation Reporter Now Printing Report 1 of 1: "TEST" Open The report or query is locked by another user. OK I know there is no other user locking the report so I click OK and again try a test run. This time when I click the button, I only get the first window but still no report. When I click the close window X button the Revelation Reporter window opens but without my report. Any help would be appreciated. </QUOTE> —- === At 11 DEC 1998 05:56PM Cameron Revelation wrote: === <QUOTE>Hi Richard, Are you running this from a dialog? BTW, the 3rd param should be 0 to print preview (print to screen). Cameron Purdy Revelation Software </QUOTE> —- === At 13 DEC 1998 10:47AM Richard Richter wrote: === <QUOTE>Hi Cameron, I created a new window not attached to any data table and placed the button right in the middle. I also had the idea to run it in the System Monitor. I ran: Run RevRpt 1,'TEST',0 and got these results: Looking for:VCR*..OIWIN* … Looking for:SYSPROG*..OIWIN* … Forward_Event calling:SYSPROG*..OIWIN* … REPOSITORY (EXECUTE,SYSPROG*STPROCEXEREVRPT, …)

I got the same messages and no report in the Rev Reporter window.

Thanks for your help.

Richard

Richard,

So:

1) You have a report that works when you preview it from within Reporter

2) It does not work from a script (using REVRPT)

3) You are not calling this from a dialog (the engine does not say "Processing" before you try to run it)

A couple of questions:

1) What OI version?

2) If you search for "SYSPROG" in the source for REVRPT, does it find anything? (There was a bug where "SYSPROG" was hard-coded instead of having @appid).

Cameron Purdy

Revelation Software

Cameron

I'm using OI 3.7. I get the same problem at home on a Win98 machine and at my office on a WinNT4 Server SP3 and WinNT4 Workstation SP3.

I checked through the REVRPT source and it had already been changed to @appid.

Hi Richard,

We will solve this. People to print reports

Summary (please verify):

1) OpenInsight 3.7

2) Variety of OS's (Win 9x, Win NT)

3) Using RevRpt to launch a single report fails

4) Engine is not busy before the report is launched (OpenEngine window does not say "Processing")

5) Variety of reports (i.e. there is not just one report that fails)

OK, next lets see if we can get any report to launch. Try:

subroutine LaunchReport(Name, Preview)

* Name    - short name of the report as it appears in the outliner

* Preview - 1 to print preview, 0 to print



declare function EntID

declare subroutine Repository, Set_Status



ReportID=EntID(@appid, "OIREPORT", "RDLAYOUT", Name)



Set_Status(0)

Repository("EXECUTE", ReportID, "", Preview)



return

Cameron Purdy

Revelation Software

I figured out the problem. I needed ".RPT" as part of Name. When you said to enter it as it appears in the outline, you hit the button.

Thanks,

Richard

View this thread on the forum...