Recent content by rip73

  1. R

    Normalization

    Hello, Going to piggyback on this conversation. Our department is undergoing some much needed overhaul. Our shop has had a lot of chefs in the kitchen, if you will, with all access to creating tables, adding fields, indexes and whatever else. We are seeing some slowing in performance...
  2. R

    Create a table using a variable?

    Hello, I am doing a dump of tables from a section of our system. Given who the customer is that we are dumping tables for, they may or may not have the full set of tables that are used in this section of the system so I am trying to be able to do this dynamically. If I have two data dumps...
  3. R

    Using Microsoft BI for Excel Report Distribution

    Thank you everyone all for your information. This is not really going to be a one stop shop to address all our reporting needs but this process has helped us in taking a much more informed looked at how and what we need to look for in a BI tool.
  4. R

    Using Microsoft BI for Excel Report Distribution

    Performance is an issue we are keeping in mind as well as costs. One of the reasons we have been looking at other methods to do this is that adding more Progess tools seems to be more costly than makes sense for us. The company overall is on the small side and the IT department has not been as...
  5. R

    Using Microsoft BI for Excel Report Distribution

    Hello, We are having to re-tool a lot of things as us older guys are moving out and or moving on. We are trying to make our environment more accessible and quicker to pick up and be functional given what is out there, as far as programmers go, while keeping our Progress DB which we are happy...
  6. R

    Using Microsoft BI for Excel Report Distribution

    Good morning, Yes. Progress is the database that the reports would be generated from. Currently we have a 3 step process to generate reports from our system that are emailed. 1. A Progress program generates the data file (.txt, .csv) 2. Windows Scheduler process that runs an Excel file...
  7. R

    Using Microsoft BI for Excel Report Distribution

    We are looking at using Microsoft BI to give reporting capability that could be used on our company website. We are also looking into having Microsoft BI to generate Excel reports that we distribute daily to replace our antiquated method of generating and sending out reports. Has anyone been...
  8. R

    No More Available App Servers - Need To Find Program(s) That Are Hanging

    Good afternoon, We have, we think, a program that is being called by an AppServer call and is not ending the session properly. So far we have not been able to find what program is doing this. We have 11.07 and we currently are not finding where to see, if we even can, what program the...
  9. R

    Command/Program that shows what procedures are used

    Thank you all very much for your responses. The command PROGRAM-NAME looks to do what I need.
  10. R

    Command/Program that shows what procedures are used

    I remember either a command or a program that would list all of the procedures, in order of exection, that a program used. I do not recall how or where it was run from but I remember reading the listing of procedures. I wish I could explain it more thoroughly but I am just vaguely recalling...
  11. R

    How do you account for running multiple programs and an occurs?

    Hi, I have a problem that needs to be corrected ASAP if possible. We run a series of programs that extract data. The code looks something like this run <program1> no-error. run <program2> no-error. run <program3> no-error. run <program4> no-error. run <program5> no-error. If one of the...
  12. R

    Can you save an Excel spreadsheet opened within Progress as a .csv?

    Thank you Kenny!!!!!!!!!! and thank you as well Greg for your response. It works now.
  13. R

    Can you save an Excel spreadsheet opened within Progress as a .csv?

    In reading a few of the posts I think I'm getting the sense that Progress may not allow this. Is that a correct assumption? If Progress is able to open an Excel file and later save it as a .csv how is that done? I am not able to have it save as a .csv. I get the following error message...
  14. R

    Getting Variables to Display in Webspeed

    Thanks Robert. Worked like a charm.
  15. R

    Getting Variables to Display in Webspeed

    I have a variable is that is calculated within the Webspeed portion of the program and then I'm attempting to display it on the form. What is the syntax for getting that variable to display on a webpage? Thanks, Webspeed Newbie
Top