We have several reports that sometimes are executed from the dashboard by a user and sometimes (once a week) by reportcaster.

In the report we want to place a "signature" that holds "&MY_user" (and some other fields).

The challange now is that if we try to run it via reportcaster the value &MY_user gives us a problem, since it is not known in the reportcaster proces.

My idea now was to test if the process is executed by reportcaster I could jump over the &MY_user coding.
But how do I test that?

Is there a amper variable available that tests this?

Any other idea?

This message has been edited. Last edited by: Kerry,

How about testing for the existence of the variable:

-SET &RUNTYPE = IF &MY_user.EXISTS EQ 0 THEN 'RC' ELSE 'DB';

I was thinking to complex

thx Francis

Or how about 'defaulting' &MY_user to an empty string.

-DEFAULT &MY_user = ''

Check the values of variables &FOCFOCEXEC and &DSTJOBNAME when running a procedure interactively and in ReportCaster. We use one or both here to determine the origin of a job.

Dan

the DSTJOBNAME idea sounds good
I think I will find a solution with these answers

[quote]-DEFAULT &MY_user = ''quote]

Frank,
I had the same problem as you have. Only we run the reports directly from MRE and from RC. We check the last character of the domain name to determine the language for the report (N for Dutch F for French and E for English).

In every report that need to run both ways I put in this:

  -*###############################################################################################################
-*   ReportCaster -*
-*###############################################################################################################
-DEFAULT &RC_lang    = 'FOC_NONE';
-DEFAULT &RC_userID  = 'FOC_NONE';
-*
-SET &&LANGUAGE  = '&RC_lang.EVAL';
-SET &&SECUSER   = '&RC_userID.EVAL';
-*###############################################################################################################
-*  ReportCaster -*
-*###############################################################################################################

This way I don't need an extra copy of the report. In RC schedule I provide the values for these variables &RC_lang and &RC_userID.

I hope this helps you to decide what solution fits you best.

How about this, that I got from Francis awhile ago.

 
-? &
-SET &WHO = IF &FOCFOCEXEC = 'RCASTER' THEN 'RCASTER' ELSE 'MRE';
-TYPE &WHO  

This message has been edited. Last edited by: Rick Man,