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

    Webfocus Installation issue

    Three things to try: 1. reboot, and re-start the install clean 2. check for another instance of the server running 3. in the directory C:\ibi\DEVSTU~1\srv76\wfs look for the edapth traces, as it says: 09/12/2009 20:55:51 cannot create shared memory, see reason in edapth traces at...
  2. focwizard

    report documentation

    How is this different from writing ANY documentation for a given output, using any language or tool?
  3. focwizard

    Page# of Page## - Problem w/ Coordinated Compound Reports

    Is your problem the placement, or getting the total number of pages? If the latter, just create a string object that contains the token: <ibi-total-pages/> For example: COMPOUND LAYOUT section=s1, $ pagelayout=1, $ component=report1, ..., $ object=string, position=(6 1), text='Page...
  4. focwizard

    Webfocus - need to truncate a decimal

    Normally, when displaying less precision than the data has, you'd WANT to round, but that's not the case here. Using 'D' format actually holds 'as much precision' as possible, rounding on display. So, you don't WANT a 'D' format. You only want to hold 2 decimal places. So, I'd recommend using...
  5. focwizard

    Row Formulas for Excel

    Is your user entering the value BEFORE execution, or into the Excel spreadsheet? Is the formula ONLY under FIELD_C?
  6. focwizard

    EXL2K saves as .XLS but format is really webpage/.mht

    Can you save your output FORMAT EXCEL? That creates an XLS format file.
  7. focwizard

    Suppress subtotals on only one column

    Any reason not to use: ON CUSTNAME SUMMARIZE MULTILINES AS 'Total for'
  8. focwizard

    Formula as a Column Total?

    If you use a COMPUTE to get the third column, then use 'ON TABLE SUMMARIZE' , the COMPUTE calculation will be redone using the summed values of columns 1 and 2.
  9. focwizard

    Daylight savings and converting time zones

    For which platform(s) do you need this?
  10. focwizard

    reference html form

    Can you provide more detail on WHAT you're doing, and what you want? Is your HTMLFORM from a FEX (i.e. -HTMLFORM)?
  11. focwizard

    duplicate records

    You're JOINing from BPDNEW to BIFIL and CRFILL08. Since both JOINs are 'unique' (you haven't secified 'All' or 'MULTIPLE' to indicate there may be multiple children), we ASSUME that you should only get AT MOST oner child iunstance from each segment for a given parent, and pass the JOIN to the...
  12. focwizard

    duplicate records

    Can you provide some example of WHAT is being duplicated? Is it an entire record, or just parts of it? Your request does no sorting or aggregation, so you're just getting the detail records from the retrieval. Also, you're JOINing from the parent table to TWO different child tables. What if a...
  13. focwizard

    How to calculate days from date field

    First off, I'm guessing that your date is a date-time format (HYYMD...). Can you confirm the USAGE format of the field SARAPPD_APDC_DATE? Second, do you want 2 weeks or 10 business days, and from WHAT date? If business days, have you properly set the BUSDAYS value (SET BUSDAYS=...), so the...
  14. focwizard

    Percentage

    Well, there are two distinct options here. The first, using RECAP, will work if you RECAP EVERY field, and put the results into a SUBFOOT. This can be more complex, as far as positioning goes, but will get you exactly what you want. The second way is like this (using our CAR file to get...
  15. focwizard

    WEBFOCUS COLUMN-TOTAL

    The REASON, by the way, is that the product has to allow for the MAXIMUM possible width of each column (we don't know how large the totals will be). Since we ALSO need the total literal (*TOTAL or whatever you use), to avoid overlaying data, we move the totals down one line. Another way to...
  16. focwizard

    WEFOCUS FOOTING BOTTOM

    Do you have your HEADING and FOOTING text o the same line as the HEADING and FOOTING? I keep getting an error when I try it that way.
  17. focwizard

    WEBFOCUS Printing Page Setup

    With HTML, we assume 'infinite width' on the output. Unfortunately, there's no way, in the HTML code, to specify the print orientation. It has to be done in the pronit dialogue.
  18. focwizard

    WEFOCUS FOOTING BOTTOM

    I need a little more detail. What platform, and what release? I tried the following on a 7.6.4 server, and it worked as expected: TABLE FILE CAR PRINT CAR BY COUNTRY PAGE-BREAK HEADING "COUNTRY:<COUNTRY" FOOTING BOTTOM "END OF COUNTRY <COUNTRY" END Could you try this code? If it works, themn...
  19. focwizard

    Reports running faster

    In your request, are you SELECTING (using WHERE) on the DEFINEd fields? If so, and the calculation can't be passed to the engine, then all records must be returned, so it can be evaluated by the client. If you look at the trace (assuming it's SQL based), you should see a message that...
  20. focwizard

    Remember Display Format After Drill Down

    You should be able to pass the value of your output type as an additional parameter to the called FEX that does the drill-down. When you pass a parameter, you can pass an AMPER variable to the called procedure by enclosing the amper variable (in your case, the format) in single quotes. It might...

Part and Inventory Search

Back
Top