MSO080 Takes me to last report and not to Avail Rpts

[maddman]

I am using Ellipse 5.2.1

Can anyone tell me why when I try to access MSO080, I am taken to the Report Request Selection Screen of the last report that was run, rather than the Available Reports Screen?

I took a class at Mincom about this about a year ago, but I cannot get past step one in my notes because I cannot get to the available reports screen.

I am new to creating report request parameters, and I am only doing it because I need to be able to set up an RDL that normally runs in the overnight to run right now to troubleshoot another RDL problem.

If anyone has the time of an OTL discussion about report request parameters, I would appreciate it.

Dwight

Dwight Maddox Jr.
Database Administrator
Transit Authority of River City
1000 West Broadway
Louisville KY 40203

Office (502) 561-5130
Fax (502) 561-5154
Email dmaddoxjr@ridetarc.org

 

[sjwales]

From reading your post, I think you might have your program names a little confused.

MSO081 is the program you use to create report requests and modify request parameters.

MSO080 is used to request a report to run, after you have defined the parameters.

Does that help you any?

Steve

stephen.wales@riotinto.com

 

[maddman]

Steve, You are correct, and I was a little unclear. I was trying to see what reports were defined when I recognized this problem. If I access mso080, I should get the losting of all reports that are available to me, but what I get is the Report Request Selection Screen of the last report that I was working on.

So I run a report, lets say msb177, then later on I want to run some other report but I do not know the number. I type mso080, and I should get the available report list, but instead it takes me to the Report Request Selection Screen for MSB177.

So to fake it out I can type something like R,MSB then it takes me to the available reports screen like it should if I typed MSO080.

Does that make any sense? Or have I made it worse?

Dwight Maddox

 

[sjwales]

On a whim, I went and had a look at our source code (5.2.1.5) for mso080. Lookie what I found:

*** 21-Sep-02 lc1424 GE20 CWDU1 ---
*** ...................... Replaced a period introduced within
*** ...................... an IF statement in B000 under WO
*** ...................... TG695 with an END-IF. For CICS TP
*** ...................... clients the W50-SHORT-REPORT fields
*** ...................... were not initialized and the period
*** ...................... caused a MOVE statement to be executed
*** ...................... that resulted in always going to the
*** ...................... MSM080B request screen for the last
*** ...................... report requested (by any user), rather
*** ...................... than going to the MSM080A report list
*** ...................... screen when user simply entered
*** ...................... 'MSO080'. This fix also prevents an
*** ...................... abend with "start clause outside where
*** ...................... clause" that occurred for CICS clients
*** ...................... on first entry of 'MSO080' after the
*** ...................... program was refreshed by a newcopy
*** ...................... or a CICS restart.


I think you should raise a work order with the help desk and request this fix and your problem will go away.

Steve

stephen.wales@riotinto.com

 

[maddman]

Thanks man, I owe you a beer or something. I was beginning to think that I had lost my mind. I will raise a WO and deal with it from there. We are also working on applying the sp's as soon as 6 is relaesed. That will probably take care of it too.

Dwight