Try this.
PRINT
COL_01 AS ''
COL_02 AS ''
COL_03 AS ''
COL_04 AS '' OVER
COL_05 AS ''
COL_06 AS ''
COL_07 AS ''
COL_08 AS '' OVER
COL_09 AS ''
COL_10 AS ''
COL_11 AS ''
COL_12 AS ''
The MRE login page is a simple HTML form. You can always rewrite that or call the form from another programs as long as you pass the specfic parameters from somewhere. If you bypass the login page, how are you doing authentication?
LET CLEAR * should do it but I don't think it's necessary. Since WebFOCUS is nonpersistant, the next report the runs is an entire new session to WebFOCUS. Even if you are using the dasboard are the user is still signed on to the same brower session, it's an entirely new connection to WebFOCUS...
EX and EXEC are the same. They must be stand alone procedures. If they require parameters, you must explicitly pass them. EX MYPROC PARM1=VAL1,PARM2=VAL2....
Since -INCLUDE brings the code into the calling procedure, it can be any peice of code and will also inherit the parameters from the...
Not sure what you're trying to do exactly. You shouldn't need to use &. This should work.
http://servername/folder/ibi_cgi/ibiweb.exe?IBIF_ex=WORK&BDATE=20041122
Deploy is for self service applications, not MRE. To use the deploy feature you would develop in local projects and then deploy. This will put the applications under your /ibi/apps folder. When using self service, you must build the front end, the menus, and the security yourself. There is...
You can put
MREUSER=&IBIMR_user
<SET>MREUSER(PASS)
in your site.wfs. That will give use access to &MREUSER in you fexes. You can easily create your own log using -WRITE
What type of database is it? For FOCUS files, you need to do a REBUILD INDEX. For relational datbases, there is nothing to add. The database handles the indexes and WebFOCUS doesn't need to know about them.
I mean just insert the &variables into your heading instead of using fields. If you want a defined field, you could create a define against the SQLOUT.
Why not put everything into one defined field?
HEADER/A100 = 'Date range selected ' | EDIT(START_DATE) | 'thru ' EDIT(END_DATE);
You would have to do more than EDIT to get the dates formatted correctly but if they are input parameters, just use the &variables.
HEADER/A100 = 'Dates selected...
If the report is in MRE, you can always add a radio button or hard code the parameter to run deferred. That would however, only mask the real problem. My suggestion would be (b) to optimize the report. You must be doing something in at least one of your passes that is doing a table scan.
That's a parameter that gets sent to the WebFOCUS servlet. You also must be calling MRE for it to work. The parameter name must be IBIMR_defer and the value is only defer to run deferred. I usually make it a check box on an HTML page.
If you're using a SUBFOOT and then displaying the total in a <ST.fld then use a RECAP instead. ON fld RECAP newfld/fmt = ....; Then display the RECAP field in the SUBFOOT.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.