[CLOSED] Setting text box to display UserID

February 17, 2011, 01:08 PM

Hi,
We are creating a Report request submission form. One of the text box needs to display the user ID. The fex is from an sql insert stored proc. The user ID field is actually an amper variable. I cant get the user ID to prefill on the HTML form. I tried some examples from other postings like this:

-SET &USERID=GETUSER('A8');
-SET &EmpID = &USERID;

Did not work: here is my fex:

 -* File RequestSubmission.fex
-SET &USERID=GETUSER('A8');
-SET &EmpID = &USERID;
ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX dbo.RequestSubmission '&EmpName','&EmpID','&EmpEmail','&RequestType','&ImpactType','&ImpactDesc','&Urgency',
       '&DeliveryDate','&Project','&ProjectTitle','&LOB','&Div','&Grp','&DeliveryMethod','&FileType',
       '&Frequency','&FrequencyType','&Comments'
;

Any help would be appreciated.

Thanks!

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

February 17, 2011, 02:45 PM

ABT

Have you tried &IBIMR_user?

-ABT

------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro

February 17, 2011, 03:02 PM

JOE

Thanks..but I do not have the perfomance management enviroment. I need to use &IBIC_user or something like that which I tried. That did not work either.

February 17, 2011, 03:19 PM

MathematicalRob

Joe,

I use a FEX to dynamically populate an input box.

Here's my code for the FEX:

-SET &sys_usr = CNCTUSR('A8');
ENGINE SQLORA SET DEFAULT_CONNECTION GOLD
SQL SQLORA PREPARE SQLOUT FOR
SELECT UPPER('&sys_usr') AS "SYSTEM_USER" FROM DUAL
;
END
TABLE FILE SQLOUT
PRINT
     SYSTEM_USER
BY
   SYSTEM_USER
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END

And here's my input box. I think it was because of some control chaining that I'm doing
that I made this a hidden input box, and then use Javascript to populate the box(es) that the
user sees - that's the SetCreator() function you see at the end:

<!-- ***** UserSource ***** -->
<INPUT id=txtUserSource type="hidden"  tabIndex=-1 ame=user_source
cacheruntimedata="0" addalloption="0" requiredfield="1464898" datatype="1" datafieldtype="INTIGER" addalloption="0"
datasource="app/userlist.fex" requiredfield="1464898" datatype="1" datafieldtype="INTIGER" sourcetype="typeFex"
accept="0" IBIMR_dir="#mydir" IBIMR_folder="#myfolder" IBIMR_domain="mydomain/mydomain.htm"
onChange=SetCreator() />

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

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!