[SOLVED] Shut off prompting of global variable in master file
I have a master file that has some global variables defined for use in some compute fields. VARIABLE NAME=&&CNST_PI, USAGE=D12, DEFAULT='200000', $
I've then created a reporting object from this master file for use with InfoAssist. When I create a new report using this reporting object and include one of my compute fields, when I RUN the report is displays or prompts me for the value of this global variable.
I have turned off 'Prompt for Parameters' on the reporting object procedure in my content folder.
Does anyone know how I can suppress this prompt window when I run my InfoAssist report?
Thanks, TrevorThis message has been edited. Last edited by: TeePee,
WF 8.0.08
February 20, 2015, 03:48 AM
Ram Prasad E
Check in Admin Console Client Setting Parameter Prompting - IBIF_wfdescribe. You can change value for this to OFF.
USAGE must be alpha (Ann), since amper vars are simply character strings:
Syntax:
First assign the variables names after the FILE declaration in the Master File:
VARIABLE NAME=[&&]var, USAGE=Aln, [DEFAULT=defvalue,] [QUOTED={OFF|ON},] $
where:
var
Is the name you are assigning to the global variable. ...
ln
Is the maximum length for the variable value.
defvalue
Is the default value for the variable. If no value is set at run time, this value is used.
If you correct the Usage, the Default might kick in.
- Jack Gross WF through 8.1.05
February 21, 2015, 08:19 AM
Ram Prasad E
Tom Flynn,
Thanks for your insight. Yes, my solution will disable all auto prompts.
Teepee, To disable only that of specific master file, Tom's and Jack's solution will help you.
You Can Also Use A -DEFAULTH IN THE Site PROFILE For THE AMPER variable. That's what I do. Just beware that when using reportcaster, it skips the client and goes directly to the reporting server. If reportcaster is a concern, then maybe try setting it with defaulth using the mfd profile.
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
February 23, 2015, 10:37 AM
TeePee
[QUOTE]Originally posted by Tom Flynn:
Add this to the IA program -DEFAULTH &&CNST_PI = ''
------------------------------- Tom,
Where would I add this line? I'm going directly from my synonym to a reporting object in the content folders.
Thanks, TP
WF 8.0.08
February 23, 2015, 11:47 AM
Tom Flynn
Right-click the focexec, edit in TEXT, and, add it above the other DEFAULTH code generated by IA...
I don't get the option to edit in TEXT with my reporting objects. I opened the focexec in the Reporting object tool then edited the Preprocessing Other group and added it there.