 |
|||||
|
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 [CLOSED] Setting a MRE built report 'Free'
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Setting a MRE built report 'Free' Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Setting a MRE built report 'Free' | Login/Join |
| Platinum Member |
I have a report that was built by one on my MRE users. I used the HTML composer to build a launch page to collect the report params. I am trying to execute the page from ibi_html/publish. This is where all my html reports live. I now need to make this report available to the entire staff. The problem is when the url is clicked on from an email or sharepoint it is prompting the user for MRE credentials that they do not have. Things I have tried with out success: Moved the reports and associated components to approot/basedir. Changed ismre value from '1' to '0'. This allows the dynamic dropdown lists to populate, but running the reports results in a 'fex not found error'. I saw a solution to pass username and password as hidden variables in the form, but my error occurs before the form is submitted, so this is not a solution. IBIMR_drill=RUNNID may be my solution but I do not know how to implement it. I found this post by product manager Jim Thorstad: "We are adding two new settings in WebFOCUS 7.6.4, MR_ANONYMOUS_RUN_ACCESS=YES|NO and MR_AUTOSIGNON=YES|NO." I am at 7.6.8 and can not find these settings. Is there a simple way, or some code I can strip to turn the 'MRE' report to a 'DevStudio" report? The reports that are developed in devstudio then 'published' to ibi_html run for all users with out promoting for credentials.This message has been edited. Last edited by: Kerry, prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | ||
|
| Expert |
Why not set it free by making it an "app" report instead of an "MRE" report? You could put the html launch page and the fex in an application folder on the server, make some minor adjustments to the parameters passed - remove the MRE parameters, change the form action... Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
I have moved the fex and the launch page to approot. I just don't know 'the minor adjustments' and what 'MRE parameters' and 'form actions' need to be made. prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Expert |
The bare minimum form to launch a fex in the app path: <html> <body> <form name="form1" method="get" action="/ibi_apps/WFServlet"> <input type="hidden" name="IBIF_focexec" value="test1" /> <input type="submit" value="Submit" /> </body> </html> Build from this. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
My error occurs before the form is even loaded. I do not see how adding actions to the form can effect a problem that is occurring before the form even loads. prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Expert |
The html is probably referring to javascript files that are located within MRE. The reference to the js files may have to be changed. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
<SCRIPT id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT> <SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT> Both of these references javascripts are correct. I navigated to the locations and hte files are there. prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Expert |
src="/ibi_html/javaassist/nls.js"might not be enough of a reference when the html file is in an app folder, src="../../ibi_html/javaassist/nls.js"may work. Otherwise, you'll have to determine which line of JS is giving you an error. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
I am running this report from ibi_html. I added the full path http://..... to the javascript and the html page would still not load. Is there a way I can pass the login credentials along with the url like: http://severname/ibi_html/publ...E&IBIPAS=password.... Or something like that? prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Virtuoso |
yes. However, I would be careful of how you pass credentials in a URL. the parameters used are &IBIC_user and &IBIC_pass. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Platinum Member |
My url looks like this: http://servername/ibi_html/publish/leave.htm?&IBIC_user=public&IBIC_pass=public Still asking for login. Do have the url formatted correctly? prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Expert |
You cannot pass variables via an HTML url. What login? MRE? Self-service? <input type="hidden" name="IBIC_user" value="public" /> <input type="hidden" name="IBIC_pass" value="public" /> this should be added to the form. Be aware that most likely "public" is an MRE user, not a self-service user, so this will not work. First thing, what error do you get? Second, have you read the manual? "Developing Reporting Applications > Coding a User Interface" would be a good start. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
The html page loads, the image links are broken and the dynamic drop downs do not populate. I get a separate pop up window that say I need to logon to mre. Most of the people that will be accessing this report are not MRE users. How will adding: <input type="hidden" name="IBIC_user" value="public" /> <input type="hidden" name="IBIC_pass" value="public" /> to the form help my issue since my error occurs before the form is submitted? prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Expert |
Just out out of curiosity, how are you calling the html page, what is the complete address you're using? http://severname/ibi_html/publish/leave/html?IBCUSER=USERNAME&IBIPAS=password... Should leave/html be leave.html? Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
The reason why the MRE pop up is occuring is because the launch page has some MRE parameters in it. As I stated before, the minimal html code required to run a fex in an app folder is: <html> <body> <form name="form1" method="get" action="/ibi_apps/WFServlet"> <input type="hidden" name="IBIF_focexec" value="test1" /> <input type="submit" value="Submit" /> </body> </html> You add your other parameters to this code, you exclude the MRE related parameters - parameters beginning with "IBIMR_". It looks like you require more help than I'm willing to offer, so good luck. By the way, have you read the manual? Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
Greg, Based on what you're trying to do it sounds like you started this all wrong. Creating an HTML launch page within Managed Reporting is going to add all sorts of Managed Reporting parameters that will not run outside of the Managed Reporting context. Some of these (Drop downs, etc), run on page load and will cause you to be prompted before the page even loads. The actual format of a HTML page created within HTML Layout painter is very different from the HTML file that is created when you "Publish" a Managed Reporting report. Moving a file to the "publish" folder does not make it immediately run properly. It is the parameters passed as part of a published report that allows it to run an anonymous MR request, not the location the page is located. If you want to use the publish facility, please use this process: 1) Log into Managed Reporting and navigate to the FEX you want to launch. 2) Right-Click on the FEX and choose "Publish" 3) Give the HTM a name and click "Ok" 4) Navigate to the Publish folder and modify the resulting HTML file so it looks the way you want it to look. If you look closely at the parameters that are passed it should be possible to modify your existing HTML file to conform to this format. The important element is the "IBIMR_drill", since this is what helps trigger the MR_ANONYMOUS_ACCESS feature. As another option: 1) Move all your FEXes involved into self-service (apps). 2) Create a new launch page outside of Managed Reporting to launch these FEXes Again, just copying the HTML Layout page from Managed Reporting to self-service is not going to work. Doing so will still have the file reference things within Managed Reporting. Thanks, Doug Logan WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP | |||
|
| Platinum Member |
The launch page was built outside of MRE, I used the html composer to develop it. If I go in to the MRE and publish the fex to a html file, I get a pretty basic html form that ask for the reports 4 parameters and does not prompt for credentials but... How would I add chaining and the javascript calendar functions, that I would normally add in the html composer? prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL | |||
|
| Platinum Member |
Greg, If you want to keep your stuff split (some in MR, some in self-service), you're going to have to manually edit the HTML to make it pass what is needed. As stated in my prior post, it is the parameters passed by the published report that allow it to run unprompted, and specifically the parameter IBIMR_drill. If you look at this and play around with it you should be able to get it to work properly. However, it will require some basic knowledge on HTML and manually editing the HTML pages. Thanks, Doug Logan WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Setting a MRE built report 'Free'
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Setting a MRE built report 'Free'Copyright © 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 |