 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Get MR login prompt when executing report from VB application
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Get MR login prompt when executing report from VB application Read-Only TopicGo | Search | Notify | Tools |
| Get MR login prompt when executing report from VB application | Login/Join |
| Member |
I have an ASP page that is the entry point for all users to the WebFocus MRE. This ASP page extracts and uses the windows domain and userid to login to the MRE and then launches the default group view.
<%
Dim pos
Dim logonUser
pos = 1
logonUser = Request.ServerVariables("LOGON_USER")
pos = InStr(1, logonUser, "\")
logonUser = Mid(logonuser,1,pos-1) + Mid(logonUser, pos + 1)
response.redirect"/ibi_apps/servlet/WORP_RM?WORP_REQUEST_TYPE=worp_login&WORP_USER="+ logonUser+"&WORP_PASS=&WF_USER=&WF_PASS=&"
%> When this page is launched from a browser I have no problems. The dashboard displays and I am able to execute the fex directly and also using a html launch page. However, when I lauch it from an application (a VB application), the dashboard displays, I am able to lauch fex files directly. But when tring to launch fex from an HTML launch page I get the following error message: "Cannot execute the request. Please log into Managed Reporting. " The html page looks like this....
<HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<META content="WebFocus Report Layout Painter" name ="Generator">
<script id=IbiOptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls";
var multidrill = "multidrill";
var mntFormValidate = "mntFormValidate";
var dyncalendar = "dyncalendar";
var ibiOptions = new Array(cgipath,ibirls,mntFormValidate,multidrill);
</SCRIPT>
<script id=nls src="/ibi_html/javaassist/nls.js" type=text/javascript>
</SCRIPT>
<script id=ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript>
</SCRIPT>
<script id=ibigblloadCss type=text/javascript>
ibigblloadCss(null);
</SCRIPT>
</HEAD>
<BODY onload=OnLoad[) pagesizeCY="2000" pagesizeCX="2000" gridsizeCY="10" gridsizeCX="10" snaptogrid="1" drawgrid="1" nextelementnum="19">
< !--startibiitems-->
<FORM onsubmit=SaveValues[) method=post name ="form" target="_blank" align = center>
<INPUT type=hidden value=salesrep/salesrep.htm name ="IBIMR_domain">
<INPUT type=hidden value=MR_RUN_FEX name ="IBIMR_action">
<INPUT type=hidden value=MR_STD_REPORT name ="IBIMR_sub_action">
<INPUT type=hidden value=app/tot29zwa.fex name ="IBIMR_fex">
<INPUT type=hidden value=app/tot29zwa.fex name ="IBIF_ex">
<INPUT type=hidden value=#newfoldervk0 name ="IBIMR_folder">
<INPUT type=hidden value="10:45:39 AM" name ="IBIMR_random">
<INPUT type=hidden value=salesassist_prod name ="IBIAPP_app" ismre="1">
<INPUT id=IBIC_server type=hidden value=EDASERVE name ="IBIC_server">
<SPAN id=ITEM1 style="Z-INDEX: 1; LEFT: 180px; OVERFLOW: auto; WIDTH: 170px; POSITION: absolute; TOP: 360px; HEIGHT: 60px" name ="visiblefex1" hasdrilldown="0" elementname="visiblefex1" elementtype="visiblefex" fexelttype="1">!IBI.FIL.ITEM1;
</SPAN>
<SELECT id=ITEM3 style="Z-INDEX: 2; LEFT: 210px; WIDTH: 275px; POSITION: absolute; TOP: 180px; HEIGHT: 22px" name ="RPTPERIOD" elementname="combobox3" elementtype="combobox" labelid caption="combobox" operation="NONE" ibiformat datatype="0" addalloption="0" dynalldisplayvalue="ALL" inchainindex="-1" chainnumber="-1" cacheruntimedata="0" displayfield numofrecords="-1" datafield sourcetype="typeMaster" datasource datafieldtype="CHAR">
<OPTION value=TODAY selected displaytext="Today">Today
</OPTION>
<OPTION value=ROW displaytext="Rest of the Week">Rest of the Week
</OPTION>
<OPTION value=CURW displaytext="Current Week">Current Week
</OPTION>
<OPTION value=ROM displaytext="Rest of the Month">Rest of the Month
</OPTION>
<OPTION value=CURM displaytext="Current Month">Current Month
</OPTION>
<OPTION value=LASTW displaytext="Last Week">Last Week
</OPTION>
<OPTION value=LASTM displaytext="Last Month">Last Month
</OPTION>
<OPTION value=NEXTW displaytext="Next Week">Next Week
</OPTION>
<OPTION value=NEXTM displaytext="Next Month">Next Month
</OPTION>
<OPTION value=PAST displaytext="Past">Past
</OPTION>
<OPTION value=FUTURE displaytext="Future">Future
</OPTION>
</SELECT>
<script LANGUAGE="JAVASCRIPT">
< !--
var d_names = new Array("Sunday", "Monday", "Tuesday","Wednesday", "Thursday", "Friday", "Saturday");
var m_names = new Array("January", "February", "March","April", "May", "June", "July", "August", "September","October", "November", "December");
var d = new Date();
var curr_day = d.getDay();
var curr_date = d.getDate();
var sup = "";
var iCount=1;
var curr_month = d.getMonth();
var curr_year = d.getFullYear();
if (curr_date == 1 || curr_date == 21 || curr_date ==31)
{
sup = "st";
}
else if (curr_date == 2 || curr_date == 22)
{
sup = "nd";
}
else if (curr_date == 3 || curr_date == 23)
{
sup = "rd";
}
else
{
sup = "th";
}
//document.write(d_names[curr_day] + " " + curr_date + "<SUP>"+ sup + "</SUP> " + m_names[curr_month] + " " + curr_year);
//-->
</SCRIPT>
<INPUT id=ITEM6 style="Z-INDEX: 5; LEFT: 520px; WIDTH: 80px; POSITION: absolute; TOP: 290px; HEIGHT: 30px" type=submit value=Submit name ="button6" elementname="button6" elementtype="button" sourcetype="typeUrl" targetname targettype="0" onclickset="0">
<INPUT id=ITEM7 style="Z-INDEX: 6; LEFT: 610px; WIDTH: 80px; POSITION: absolute; TOP: 290px; HEIGHT: 30px" type=reset value=Reset name ="button7" elementname="button7" elementtype="button" sourcetype="typeUrl" targetname targettype="0" onclickset="0">
<SPAN id=ITEM9 style="FONT-FAMILY: Arial; FONT-WEIGHT: 700; FONT-SIZE: 12pt;Z-INDEX: 8; LEFT: 100px; WIDTH: 160px; POSITION: absolute; TOP: 180px; HEIGHT: 20px" name ="text9" elementname="text9" elementtype="text">
<SPAN sourcetype="typeUrl" targettype="0" FragmentColor="0" FragmentStartChar="0" FragmentEndChar="16">Time Period:
</SPAN>
</SPAN>
<SPAN id=ITEM13 style="FONT-FAMILY: Arial;FONT-SIZE: 10pt;Z-INDEX: 12; LEFT: 210px; WIDTH: 200px; POSITION: absolute; TOP: 210px; HEIGHT: 50px" name ="WFFMT" elementname="combobox13" elementtype="radio" labelid caption="radio" operation="NONE" ibiformat datatype="0" addalloption="0" dynalldisplayvalue="ALL" inchainindex="-1" chainnumber="-1" cacheruntimedata="0" displayfield numofrecords="-1" datafield sourcetype="typeMaster" datasource datafieldtype="INTEGER" columns="1" rows="-1">
< !--
<INPUT id=ITEM13_0 style="LEFT: 0px; WIDTH: 16px; CURSOR: default; POSITION: absolute; TOP: 0px; HEIGHT: 16px" type=radio value=HTML name ="WFFMT" displaytext="HTML" checked ="1">
<LABEL style="LEFT: 19px; POSITION: absolute; TOP: 0px" for="ITEM13_0">HTML
</LABEL>
-->
<INPUT id=ITEM13_1 style="LEFT: 0px; WIDTH: 16px; CURSOR: default; POSITION: absolute; TOP: 0px; HEIGHT: 16px" type=radio value=PDF name ="WFFMT" displaytext="PDF" >
<LABEL style="LEFT: 19px; POSITION: absolute; TOP: 0px" for="ITEM13_1">PDF
</LABEL>
<INPUT id=ITEM13_2 style="LEFT: 0px; WIDTH: 16px; CURSOR: default; POSITION: absolute; TOP: 17px; HEIGHT: 16px" type=radio value=EXL2K name ="WFFMT" displaytext="EXCEL">
<LABEL style="LEFT: 19px; POSITION: absolute; TOP: 17px" for="ITEM13_2">EXCEL
</LABEL>
<INPUT id=ITEM13_3 style="LEFT: 0px; WIDTH: 16px; CURSOR: default; POSITION: absolute; TOP: 34px; HEIGHT: 16px" type=radio value=OLAP name ="WFFMT" displaytext="SCREEN" checked="1">
<LABEL style="LEFT: 19px; POSITION: absolute; TOP: 34px" for="ITEM13_3">SCREEN (Analysis Report)
</LABEL>
</SPAN>
<SPAN id=ITEM14 style="FONT-FAMILY: Arial; FONT-WEIGHT: 700; FONT-SIZE: 12pt;BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; Z-INDEX: 13; LEFT: 100px; BORDER-BOTTOM-WIDTH: 0px; WIDTH: 160px; POSITION: absolute; TOP: 210px; HEIGHT: 20px; BORDER-RIGHT-WIDTH: 0px" name ="text15" elementname="text15" elementtype="text">
<SPAN sourcetype="typeUrl" targettype="0" FragmentColor="0" FragmentStartChar="0" FragmentEndChar="15">Format:
</SPAN>
</SPAN>
<FIELDSET id=ITEM16 style="BORDER-RIGHT: 2px double; BORDER-TOP: 2px double; LEFT: 20px; BORDER-LEFT: 2px double; WIDTH: 750px; BORDER-BOTTOM: 2px double; POSITION: absolute; TOP: 70px; HEIGHT: 280px" name ="groupbox16" elementname="groupbox16" elementtype="groupbox">
</FIELDSET>
<SPAN id=ITEM15 style="FONT-FAMILY: Arial; BORDER-TOP-WIDTH: 0px; FONT-WEIGHT: 700; BORDER-LEFT-WIDTH: 0px; FONT-SIZE: 20pt; Z-INDEX: 44; LEFT: 40px; BORDER-BOTTOM-WIDTH: 0px; WIDTH: 710px; COLOR: rgb[0,0,255); FONT-STYLE: normal; FONT-FAMILY: Arial; POSITION: absolute; TOP: 100px; HEIGHT: 30px; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 0px; TEXT-DECORATION: none" name ="text18" elementname="text18" elementtype="text">
<SPAN sourcetype="typeUrl" targettype="0" FragmentColor="128" FragmentStartChar="0" FragmentEndChar="15">Call Cycle Report for Group Heads
</SPAN>
</SPAN>
</FORM>
<script type=text/javascript>
< !--
window.chain0=new Array(1);
window.chain0[0]=new String("ITEM3;ITEM8");
window.chain0[1]=0
//-->
</SCRIPT>
< !--endibiitems-->
<script id=OnloadHandler>
function OnLoad() {
< !--startibilines-->
UpdateData();
< !--endibilines-->
}
</SCRIPT>
</BODY>
</HTML>
WebFOCUS 5.3.3, Win 2000, IIS | ||
|
| Member |
Correction..... The ASP page launches the default public view. Also..... When launched from the HTML page, the report is being launched in a new browser window and I noticed that the MR_COOKIE is not set in the new session. If I change the HTML page to launch the report in the same browser window it works. I guess the solution would be to do a MR login before launching the fex in a new window. Please Help. Thanks in advance!!!This message has been edited. Last edited by: Balram Vedavyas, WebFOCUS 5.3.3, Win 2000, IIS | |||
|
| Virtuoso |
If I understand this correctly, your response.redirect is actually forcing your IIS server to be the client for your webfocus logon, hence the no cookie thingy. Instead of a response.redirect, try returning a html page with a form that submits your url on load. This should ensure that the true client is the browser. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Gold member |
Not sure if this is related, but I had an issue when I was trying to run a report with a Dynamic Drop Down Box without logging into the MRE. The drop down was empty and I kept getting the message that I needed to be logged into the MRE. An IBI rep had me change the following value in the code and it solved my problem: ismre="1"> Change to: ismre="0"> Change this line in your code: <INPUT type=hidden value=salesassist_prod name ="IBIAPP_app" ismre="1"> Supposedly, this value tells WebFOCUS that it is expecting you to run this app inside the MRE. Thanks, Tim | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Get MR login prompt when executing report from VB application
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Get MR login prompt when executing report from VB applicationCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |