Author Topic: User Report Maintenance values  (Read 3853 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
User Report Maintenance values
« on: July 16, 2013, 05:56:15 PM »
On the /URM screen, besides the dictionary names entered, where are the values stored?

Can the screen get refreshed?

Here's the issue.  I have two prompts.  If I make an entry on the first prompt I want the second one to be cleared and vice versa.

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 224
  • Tom Pellitieri - Toledo, Ohio
Re: User Report Maintenance values
« Reply #1 on: July 17, 2013, 08:02:05 AM »
The GRIM / URM processes let you build parameter selection screens for reports, usually using the /RD REPORTS TEMPLATE as a basis.

Once the screen is completed, report title information is stored in @WORK<26> and the selection criteria is stored in @PARMS(39).

If you need more control over your selection criteria, I would recommend that you use @WORK values on your /URM screen, then build your selection based on that information.

I don't know of a way to have the screen automatically skip the second field if the first field is empty.

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: User Report Maintenance values
« Reply #2 on: July 17, 2013, 11:59:10 AM »
 :)  I am so blessed to be given the opportunity to solve some of my own issues.

Here's the solution.
Everything on the /URM screen is in @RECORD
I have most things documented if you are interested; but not all.

@RECORD<30> has all the values entered for all the prompt questions
@RECORD<30,1> is the first question, @RECORD<30,2> the second,...
and the @RTN.FLAG works like expected and so does the @REFRESH

To solve my issue ' blank out #2 if you enter #1 and blank out #1 if you enter #2'
Create a process-after question #1
   IF @RECORD<30,1> # "" AND @RECORD<30,2> # "" THEN
      @RECORD<30,2> = ""
       @WORK<3,2> = ""  ;*** this was my /URM line item for question #2
       @REFRESH = -2      ; *** refresh screen
   END

Create a process-after for question #2
   IF @RECORD<30,1> # "" AND @RECORD<30,2> # "" THEN
      @RECORD<30,1> = ""
       @WORK<3,1> = ""  ;*** this was my /URM line item for question #1
       @REFRESH = -2      ; *** refresh screen
   END