I can't get any response when I try to run reporter from a button on a form. Here is my code..

declare function Utility, msg

PARMS='

PARMS=Please enter the password you used to log on."

PARMS=RCE'

PARMS=1

PSWD=MSG(,PARMS,,,)

IF PSWD=CHAR(27) ELSE

PARMS='

PARMS=Please enter the AUDIT DATE"

PARMS=RCE'

AUDIT_DATE=MSG('',PARMS,'','','')

SELREC=QUOTE("WITH ROWID=COMPARE*" : OCONV(AUDIT_DATE, 'D2/'): "'" )

RPTCMD=REPORTER.EXE /AP=HRIS /UN=:@USERNAME:" /PW=:PSWD:" /SEL=:SELREC 

RPTCMD := /SELTYPE=REVELATIONBASIC /RP=BCAUDIT /ED=0 /PV=1 /QU=1"

retval=Utility('RUNWIN',RPTCMD,0)

End

ret=msg(,'finished',,,)

RETURN 0

It asks for the password and audit date then the finished msg is displayed ??

Paxton,

I can't get any response when I try to run reporter from a button on a form.

Before clicking on the button, go to the Open Engine window. Does it say "Processing" or "Idle" at the bottom.

Cameron Purdy

Revelation Software

OK, I guess I see the problem, but what is the solution.

The engine is idle, then, the button is clicked, and my script asks the user for information from which I construct the query, so I get the right record, and I ask for his log on password, since I don;t know how to get it from the system, if possible. I guess since I use the engine to ask for these data from which to construct the reporter command, I can't also use the engine to run reporter, right?

So, how does one get a report?

Cameron,

      Also, I tried substituting calling Rlist.  see code

declare function Utility, msg

DECLARE SUBROUTINE RLIST

/*

PARMS='

PARMS=Please enter the password you used to log on."

PARMS=RCE'

PARMS=1

PSWD=MSG(,PARMS,,,)

IF PSWD=CHAR(27) ELSE

*/

	PARMS='

PARMS=Please enter the AUDIT DATE"

PARMS=RCE'

AUDIT_DATE=MSG('',PARMS,'','','')

/*

SELREC=QUOTE("WITH ROWID=COMPARE*" : OCONV(AUDIT_DATE, 'D2/'): "'" )

RPTCMD=REPORTER.EXE /AP=HRIS /UN=:@USERNAME:" /PW=:PSWD:" /SEL=:SELREC 

RPTCMD := /SELTYPE=REVELATIONBASIC /RP=BCAUDIT /ED=0 /PV=1 /QU=1"

• /

RLIST("LIST AUDIT_RESULT MESSAGE WITH ROWID=COMPARE*":AUDIT_DATE:"'",1,'','','')

• retval=Utility('RUNWIN',RPTCMD,0)

*End

ret=msg(,'finished',,,)

RETURN 0

The engine goes from idle to processing as soon as I click. As soon as I enter the date, I get my 'finished' message. No output to screen or printer????

Well, maybe a little progress. Had the wrong field name. Messages in stead of MESSAGE. But Now I to get some printer output, but I get the col headings on one page and one line of the mv field on the next page. At least these symptoms are the same from the program and from the command line. When I use the '1' switch to go to the screen from the command line, it is displayed correctly. From the program, nothing is produced.

Questions: How do I get RLIST to print all the values in MESSAGES instead of one value (not the first or last???) which it does now.

And how do I get it to go to the screen programtically?

Thanks for your help! Paxton

Hi-

As far as the reporter not starting, I would have to look into that a little more, but the FINISHED message will display either way because the utility function is not (and cannot) opening the reporter as a modal application, so the subroutine is just proceeding onto the next line of code.

Are you running the form regularly or as a dialog box?

Tracy

Hi Tracy,

       Thanks for the reply.  Well, I've been gathering that my main problem is I'm not used to OI yet.  But, I've blundered into this area where I've learned I can't start another process that uses the engine until I finish the first process..Ok  If I understand your question, the form that has the button whose 'click' script is attempting to produce the report was launched from yet another form by a click button.

 Originally, I intended to run the report in response to user dialoge from MSG as a part of a program that compared two files.  That program is launched from a button on a form that contains my gas guage and so shows progress.  When I found that I could not start reporter from my program, I thought (not carefully) that I try from a button on the form.  i.e. let the program finish, then make the user click a 'report' button....

     So, problem remains.  How do I produce a report as part of this process in a reasonable way...hey, I might go for an unreasonable way if I can explain it to the user...ought to be simple to solve, I must have a brain cramp!

     Thanks for your response.  Nice to hear-see from another name.

Best regards, Paxton

Okay, first of all, just gathering the information to build the command line doesn't tie up the engine so that you can't run reporter, so you're okay there.

If you are calling this form with Start_window rather than Dialog_box, then you should be okay there as well (with regards to tying up the engine).

I would try hardcoding the complete command line (user name/password/anything else that you are pulling from the MSG functions) within the script just to see if the reporter starts. At that point we can determine if the reporter just isn't running because of something in the system, or if perhaps the command line just isn't getting built correctly.

Tracy

Tracy,

         Thanks for the debug help.  I had determined the command was ok, it;s just a conflict with the running engine that I don't understand how to solve....but, the good news is that I was working in a Ceridian application, and I found one of their routines called "run_rporter" which allowed me to send some paramaters to call the right report with select and sort information and BINGO it worked.

I have not yet taken the time to examine the routine,if I have the source, to see how it works, but I will. For now, I have to move on and get this work in production.

Thanks again for helping.

–Paxton

Paxton,

Questions: How do I get RLIST … to go to the screen programtically?

ORVIEW. (Search the web site for ORVIEW; you should find something.)

Cameron Purdy

[email protected]

View this thread on the Works forum...