Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WFGuru

    Need URL for Version 53 Dashboard

    http://hostname/ibi_apps/bid
  2. WFGuru

    most flexible report layout control?

    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 ''
  3. WFGuru

    Logging into MRE

    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?
  4. WFGuru

    How to clear global variables in code ?

    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...
  5. WFGuru

    "-INCLUDE" "EX" "EXEC" differences??

    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...
  6. WFGuru

    Passing Parameter to the url string

    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
  7. WFGuru

    What is Deploying an Application

    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...
  8. WFGuru

    MRE Users' Table

    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
  9. WFGuru

    Year Format

    Sounds like there's something before your DEFINE that doesn't belong there.
  10. WFGuru

    How can I add INDEXES to SYNONYMS

    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.
  11. WFGuru

    Creating HEADINGS for EXL2K output

    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.
  12. WFGuru

    Creating HEADINGS for EXL2K output

    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...
  13. WFGuru

    HOLD Files take 15 minutes to run

    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.
  14. WFGuru

    Running a report in DEFERRED mode

    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.
  15. WFGuru

    Percentages as SUBTOTALS

    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.
  16. WFGuru

    Percentages as SUBTOTALS

    Use RECOMPUTE or SUMMARIZE instead of SUBTOTAL.
  17. WFGuru

    Reset a COMPUTE field to ZERO

    I don't understand. What exactly are you doing?

Part and Inventory Search

Back
Top