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 derfloh 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. Lucieann

    Selection Criteria Formula

    Works great. Thanks!
  2. Lucieann

    Selection Criteria Formula

    I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and ( if {?Officer} <> "All Officers" then {Exception_Table.Officer} = {?Officer} else if {?Officer} = "All Officers" then True ) and...
  3. Lucieann

    Select Record Problem

    That works like a charm!! I had tried changing the order of my formula, but when I made changes and saved it, it would revert back to the way it was before. It's amazing what those () will do you you! Thanks so much for all your help!!
  4. Lucieann

    Select Record Problem

    I am trying to select specific records from an Access database using an ODBC connection. Here is the formula I am using: {@ComingDue} = 1 and if {?Officer} = "All Officers" then {Exception_Table.Officer} = {Exception_Table.Officer} else {Exception_Table.Officer} = {?Officer} and...
  5. Lucieann

    Help with report on web

    I have a report created in CR 9 Standard. Data pulls from an Access database with an ODBC connection. I have placed the report on our intranet using ActiveX to view. My problem is this. When you open the report, the first page displays correctly. As long as you use the "Next page" button...
  6. Lucieann

    Problems with print

    The data is coming from an Access database. I have double-checked the database and the items that are duplicating are only in the database once. I am running Crystal Reports v.9.
  7. Lucieann

    Problems with print

    For some reason, when I preview my report, on some pages the last 3 or 4 records at the bottom of one page will print at the top of the next page. I do not have duplicate records in my database, so I don't understand why this is happening. Anything I can check??
  8. Lucieann

    Problem with aging crosstab

    I am using the following formula for aging records in a crosstab: If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 0 to 30 then &quot;0-30&quot; else If datediff(&quot;d&quot;,{TITM1301.ExpireDate}, currentdate) in 31 to 60 then &quot;31-60&quot; else if...
  9. Lucieann

    Need formula to count items aged

    I wrote a formula to concatenate the category number with the subnumber. The formula (@CategorySubNumber) looks like this: totext({TITM1301___Test_3_No_Dup.Category},0) + &quot;-&quot; + totext({TITM1301___Test_3_No_Dup.SubNumber},0) I am using the Supress If Duplicated option.
  10. Lucieann

    Need formula to count items aged

    That is correct. For each account number, there is one officer and one customer name with possibly several cat.numbers and cat.descriptions. Here is an example of what the report should look like: Customer: John Doe Officer: ABC 218-1 Control Agreement 8/15/2003 218-2 Control...
  11. Lucieann

    Conditional Sum???

    That is awesome!! Thank you so much for your help!!
  12. Lucieann

    Conditional Sum???

    That works great!! But what could I add to make it include my first record only if it has a numeric loan value?
  13. Lucieann

    Conditional Sum???

    Is there any way to add a conditional summary field? In my table, I have three fields that this will involve: LoanNumber (Can be numeric or alpha-numeric) Balance (Currency field) DirectDebt (Currenct field) If the loan number is a numeric value, I want to add that amount into my subtotal...
  14. Lucieann

    Help with Ascending Order sort

    I figured it out. I had my sort criteria set to sort by the formula instead of the two separate fields.
  15. Lucieann

    Help with Ascending Order sort

    The records are not in the database that way. I have a formula that adds the -1, -2, ... to the main category number. In the database, they are actually two separate fields.
  16. Lucieann

    Help with Ascending Order sort

    I am trying to sort records by their category number (i.e. 225-1, 225-2, 225-3,...). However, 225-10 prints before 225-2. How can I keep this from happening? Thanks!
  17. Lucieann

    Relating Tables in Crystal

    What kind of damage will it do if you relate the same field in multiple tables? For example, cna you relate one field in table A to fields with the same data in tables B and C?
  18. Lucieann

    How to run macro automatically when file is opened

    I need to figure out how to automatically run a macro when a file is opened. I have tried, but it seems all that is happening is that the file is opening, but no macro is running. Any help would be appreciated. Thanks!
  19. Lucieann

    Need formula to count items aged

    You've got it right. I have the records grouped by (1) officer, (2) customer name then (3) account number. I placed the cross-tab in the group footer (1). I concatenated Cat. Number and Cat. Description for cross-tab row, have the @aging for the columns, and a count for my total. The only...
  20. Lucieann

    Need formula to count items aged

    I have 5 different tables: CustInfo (Acct Number, Officer Name, Cust Name, Address, Etc.) CustNotes (Acct Number, Note Line Number, Note) TrackedItems (Acct Number,Cat. Number, Cat. Desc, Reference, Expiration Date) TrackedItemNotes (Acct Number, Cat. Number, Note Line Number, Note) Collateral...

Part and Inventory Search

Back
Top