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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: Rena
  • Content: Threads
  • Order by date
  1. Rena

    Passing a parameter from the Menu to a procedure

    In one of my applications, I have a menu that 'surrounds' all my procedures. On one of the Items, I would like to pass a parameter to the called procedure. On the Actions tab - I have tried putting a global variable in Parameter: field but when I compile it, I get two errors: 1. No matching...
  2. Rena

    CPCS Report

    What would cause the Group Footer band to print at the end of the report with zeros in the fields. I am using fields from the detail section (amount, weight, and cases) and putting (in the properties box) Total Type: sum and a Reset On: Custno. So at the very end of the report, I get the...
  3. Rena

    Importing a VisualFoxPro file

    I need to write an app against a VisualFoxPro database. When I try to import it, I select ODBC as my File Driver. I enter the datasource, leave the user id and password blank and click the Exclude system files option. Click Next and I get the following error: Could not Connect to Database...
  4. Rena

    CapeSoft - Office Inside

    Does anybody use the 3rd party vendor CapeSoft? I am specifically looking for some help with their Office Inside product (importing an Excel spreadsheet). My situation: I have a workbook that has several worksheets. I am having difficulty opening the workbook and pointing to the specific...
  5. Rena

    Getting SubTotal from Sub-report to Main report

    I have a main report that displays by material number: Avg Cost Amt Allocated Total Allocated Cost With a SUM of total allocated cost in the report footer. In the report footer I have a sub-report that displays by material number: Avg Cost Amt On-hand Total On-hand Cost With a SUM of total...
  6. Rena

    Subtotal on a complex formula

    In my report I need to calculate the difference between two other values. One of the values is a formula: @TC_OnHand If {ssinvent.uomcost} = 'M' Then ({ssinvent.onhand} * {ssinvent.avgcost}) / 1000 Else If {ssinvent.uomcost} = 'CWT' Then ({ssinvent.onhand} * {ssinvent.avgcost}) / 100...
  7. Rena

    Reset a variable

    I apologize if this has been asked and answered before but I couldn't find this question in previous threads. I have an inventory report that displays: avg cost, amt allocated, total allocated cost, on hand amt, total on hand cost, difference (between allocated cost and on hand cost) The...
  8. Rena

    Aggregate functions and Group by clause

    Hi all, I am still in the reading stage of SQL programming. There is something that confuses me that I hope somebody on this list can explain. My sources make the following statement: "Any other columns that appear in the select list must be used as arguments of an aggregate...
  9. Rena

    Conditionally Suppress Group Headers

    I have a report that contains two subreports. The subreports retrieve dollar amounts that are stored in shared variables. One is a received dollar amount and the other is an invoiced dollar amount. I take the shared variables and in the main report, subtract one from the other to determine...
  10. Rena

    ASP and Cookies

    Does the ASP server set a cookie on it's own? My web page doesn't set or use cookies. Yet when I have my security set to prompt on the Allow per-session Cookies I get prompted when I enter the page. Can anybody explain what is going on here? TIA, Rena
  11. Rena

    Select worked in V7 but not in V8

    I have discovered two reports that worked in V7 but now that I have "upgraded" to V8 they don't work. These reports access a VFP database via ODBC. The problem seems to be with selecting on date fields. In VFP if the date is blank you have to select date(1899,12,30). I have worked...
  12. Rena

    Setting HREF to point to an outside folder

    I am trying to figure out how to write up the HREF for a file that is outside the current folder. I need to link to a file that is 1 to 2 folders up. For example MainFolder ImagesFolder BG1.gif NewsInfoFolder AboutUsFolder index.htm SignsFolder index.htm I...
  13. Rena

    Same report; 2 different computers; 2 different results

    I have a report that was written in V7. It uses ODBC to access 3 Visual Fox Pro databases. We have recently upgraded to V8.5. When I run this report on my computer, I get the expected records. When a co-worker runs the same report on her computer, she gets no records. I have checked the...
  14. Rena

    Formatting a continuous label

    I need to print a set of labels that are 1-up, 4" x 2.438". When I use the label expert (User-defined labels), it wants to put 4 labels / page which creates blank space after the 4th label. These are continuous labels so they should be considered as 1 / page. How do I get the label...
  15. Rena

    Autosave Reports - Where did it go?

    I have the 'autosave reports after N minutes' turned on when my computer locked up yesterday. I was working on a new report and hadn't saved it yet. Anybody know where my autosaved version went? Thanks, Rena
  16. Rena

    Choosing a table during run-time

    I am creating a report to display information from our firewall. Is there some way I can change, on the fly, which file it is reading? For example, we will have daily files and weekly files; all will have the same format. Right now the report points to a specific file but I need to be able to...
  17. Rena

    Complex If-Then-Else formula

    Hi, I have a formula that I can't get to work. Here it is: StringVar FirstMiddle := ' '; StringVar First := ' '; StringVar Middle := ' '; StringVar Last := ' '; If InStr({ssemploy.empname},',') < 1 Then If InStr({ssemploy.empname},' ') < 1 Then Last := {ssemploy.empname} Else...
  18. Rena

    Select based on a logical field

    I am writing a report against a VFP data base. I need to select records based on a logical field being set to false. I displayed the field on the report and found that Crystal treats it as numeric - 0 or 1. I have tried selecting using the ToText function but I don't get any records. Anybody...
  19. Rena

    Please explain the While x do y command

    I am trying to use this command in CRW8. This is an example of the code I have written: While starthour >= 24 Do startdate := startdate + 1; starthour := starthour - 24; Exit While; When I try to save this I get the following error: 'exit while' without an...
  20. Rena

    How do I calc the diff between start time & end time

    There is a catch to this problem. Either the start time or the end time (or both) can have the hours be greater than 24. For example instead of 1:15/am it would be 25:15. I wrote a complex routine in VFP to calculate this but am having a difficult time figuring out what functions to use in...

Part and Inventory Search

Back
Top