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 Chriss Miller 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. LeonelSanchezJr

    Populating Drop Downs - Error Retrieving Data

    I am using Developer Studio 7.6.4 and I have an HTML with several Drop Downs (some of which are chained). The Drop downs are populated by FOCUS Master files that are refreshed nightly. Some users get an "Error Retrieving Data" message when the open the Dashboard and the drop downs don't...
  2. LeonelSanchezJr

    Wait Message

    I am using Developer Studio 764 and I have some FEXES that are drilled into via a hyperlink from another report. I need to display a spinning wheel gif that I have while the report runs, then hide the wheel. I have been looking online for 2 days now and have found several options, but none of...
  3. LeonelSanchezJr

    Publish WebFOCUS HTML

    I am using Developer Stuido 764 and I would like to Publish an HTML form to run outisde of MRE via a .NET application. I am currently using a simple HTML / FEX using the CAR file. I have one drop down with the Country. Can someone make this as simple as possible? Thanks, Leo ;-)
  4. LeonelSanchezJr

    Recompute and AVE Column

    I am using DEV Studio 7.6.7 I have the following code: TABLE FILE HOLD1 SUM AVE.AVGS NOPRINT BY BOX SUM AVE.EXT_AMT BY BOX ACROSS SLD2_NAME COMPUTE TEST/D12.2 = AVE.AVGS; AS AVGS ON TABLE RECOMPUTE AVE. EXT_AMT AVE. AVGS AS 'Total-Average' END -* Everything works great except for...
  5. LeonelSanchezJr

    Resize IFrame Using JavaScript in WebFOCUS 7.6.7

    My report output goes to an iframe within a screen. The iframe resizes for the larger reports, however, when I run a report which is smaller in width and height, the iframe does not resize to the smaller size. I've looked at several websites, but have not found one solution which works...
  6. LeonelSanchezJr

    Dev Studio 764 Stops Running

    I'm using Developer Studio 7.6.4 on a Windows 7 desktop and everything works fine. However, every now and then, when I'm trying to run anything from Dev Studio, it does not respond. This happens to all developers on my team as well. We have to completely close down Dev Studio and restart. Any...
  7. LeonelSanchezJr

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

    I am using WebFOCUS 7.1.4 Developer Studio in a Windows 2000 environment. I believe that there is a known issue with placing the "Page # of Page ##" in a coordinated compound report. However, my employer is REALLY needing us to place the page numbers in this type of report. Is they ANY type...
  8. LeonelSanchezJr

    Row Formulas for Excel

    I am developing a Webfocus report using Developer Studio version 7.1.4. My report output is EXL2K and has 1 line of real data output. Then, I have 2 blank rows beneath the real data. The report looks like this: FIELD_A FIELD_B FIELD_C 100.00 200.00 700.00...
  9. LeonelSanchezJr

    Convert Alpha to Integer

    I have the following code which provides me with a report begin date and it works for one file which has a date field in the format of YYMD. However, the second file has the date field defined as I11 and the data looks like this 20070215 for instance. So, I need to take the code below for the...
  10. LeonelSanchezJr

    Creating a Drop Down List With Values 1 Thru 5000

    I am using WebFOCUS 714 Developer Studio. I need to create a drop down list that has values 1 through 5000. How can I do this? Thanks, Leo ;-)
  11. LeonelSanchezJr

    Matrix Report

    I am using Developers Studio 714. The report should look like this: MONTH MONTH MONTH PRODUCT STATUS 10/2007 9/2007 8/2007 ABC APPLICABLE 365 458 617 ABC SOLD 118 179 226 ABC...
  12. LeonelSanchezJr

    Custom Graph Colors

    I am using Developer Studio Version 7.1.4. I am using the LINE Graph, Absoute. I need to "flip" 2 colors in the graph. OR, have complete control over the colors that appear in the lines. I have 8 values in my legend which comprise the line graph. However, the "TARGET" which is one of the...
  13. LeonelSanchezJr

    Using a BOT Table to Determine if a Job is Running

    We are using WebFOCUS 714. We have some jobs that take a long time, so we want to check on a schedule via a BOT schedule and find out if a job is running and how long. This way we can determine whether to launch other jobs or not. By the way, we use CTRL-M to run the report caster jobs...
  14. LeonelSanchezJr

    IF FIELD EQ (HOLD_FILE)

    I need to create a HOLD file with DRIVER_NUMBERS. Then, I need to query a second table based on the DRIVER_NUMBERS that exist in the previous HOLD file. I think the logic is like this. TABLE FILE CAR PRINT CAR WHERE CAR EQ 'BMW'; ON TABLE HOLD AS DRIVER FORMAT FOCUS TABLE FILE MY_CARS PRINT...
  15. LeonelSanchezJr

    Accept Numeric Values Only - TextBox

    I am using Developer Studio 7.1.4. I have a Text Box on an HTML form which should be for NUMERIC entry only. How can I mask it? Or, how can I provide a script to alert the user that it's not numeric? Thanks, Leo ;-)
  16. LeonelSanchezJr

    Return Report Values to Boxes within HTML

    I am using Webfocus Developer Studio 7.1.4 and my goal is to have 1 HTML page with parameters at the top third of the page and an ouput area on the bottom 2/3s of the page. The parameters are no problem, but my challenge starts with the report output. The first part of the report is the...
  17. LeonelSanchezJr

    Email and Error Message

    I am using Developer Studio 714. Is it possible to email the error message to a developer when a user encounters an error? Thanks, Leo ;-)
  18. LeonelSanchezJr

    Error Handling

    I am developing reports in Developer Studio version 7.1.4. My intention is to create 1 INCLUDE file which will be called after my Table File routine in my fexes. This works fine if the calling FEX is in PDF and the called error handling routine is in PDF. However, my dilemna is due to the fact...
  19. LeonelSanchezJr

    Suppressing Values and NOT Supressing

    I am using the compute code below to supress repeated values on a field which is not a BY field. The code works great! However, I now face a new challenge. I need to SHOW the field if it appears on a new page. I suppose this is to duplicate Widows/Orphans from Word? Can this be done? COMPUTE...
  20. LeonelSanchezJr

    Need to Update and/or Insert Recs In Report Caster Library Access List

    We're on WebFOCUS version 7.1 The backend is DB2 (which I'm not familiar with since my previous job had SQL Server backend). We have a Library Access List which needs to be updated daily. The 2 current BURST VALUES are as such: 2007/07/04: My Report (999-99999) 2007/07/04: Your Report...

Part and Inventory Search

Back
Top