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: *

  • Users: veles
  • Order by date
  1. veles

    second last date

    Hello, I have a date field holding dates of activities {S_CASE.ASGN_DT} for clients {S_ORG_EXT.DUNS_NUM}. I understand to get the latest date showing is to use {S_CASE.ASGN_DT} = maximum({S_CASE.ASGN_DT},{S_ORG_EXT.DUNS_NUM}) Is there a formula to get the second last date? Thanks
  2. veles

    Compare records to get true or false

    Yes, Table1 and Table2 are left joined. All Table1 values are displayed no matter if there is a value in Table2 or not
  3. veles

    Compare records to get true or false

    The issue is that the parent ID from Table2 is from another record, see below Table1 Table2 Formula Result 1 null match 2 null 3 1 4 null 5 null Table1 record ID 1 is the parent ID in Table2 for record 3...
  4. veles

    Compare records to get true or false

    Thanks for the answer. I need to display all records as in the attachment. Basically I need to use the value of the parent ID somehow to run through the records in {table1} and find the match. Once the match is found to display the "match" string
  5. veles

    Compare records to get true or false

    Hi guys, I need some help on a formula that compares records I have {table1}that has record ID like 1, 2, 3, 4 ..... In another table {table2}there is a field that uses the record ID from{table1} for a parent ID So a record in {table2} will have a parent ID matching one of the record ID in...
  6. veles

    Crystal XI connection to Access DB with crystal parameter

    Hi, I created a crystal report from an access DB that has no password protection. The report runs fine. Once I add a parameter a pop up come up asking for a username and password. Is there a solution for this? Any help is appreciated. Thanks
  7. veles

    Past Due items

    Thanks Pete, Now I am wondering if the formula covers what I was trying to acheive. I was under the impresion that using if ({S_EVT.TODO_DUE_DT}) < currentdate-10 then "Past Due By 10 Days" will cover any records with a due date past up to 10 days. I am thinking that I need a range in the...
  8. veles

    Past Due items

    Hi Pete, Thanks for your reply I did use your example and expanded it if isnull ({S_EVT.TODO_DUE_DT}) then "No Due Date" else if ({S_EVT.TODO_DUE_DT}) > currentdate then "Future" else if ({S_EVT.TODO_DUE_DT}) < currentdate-90 then "Past Due By 90 Days" else if ({S_EVT.TODO_DUE_DT}) <...
  9. veles

    Past Due items

    I need help with a formula calculating past due dates based on a field if ({S_EVT.DUE_DT}) < currentdate-60 then "Past Due By 60 Days" else if ({S_EVT.DUE_DT}) < currentdate-90 then "Past Due By 90 Days" The first part is working good, but the 90 day part isn't. I beleive it has to determine a...
  10. veles

    Mailing vs physical address

    [pc2]Thank you so much. That worked like a charm
  11. veles

    Mailing vs physical address

    Thanks for the reply, I'm not sure what I am doing wrong, but I tried what was suggested and the detail completely gets suppressed. Here is the actual breakdown G1 - Client - {ORG.CLIENT_NUM} In this group I have all the client info I need, I have the address field {ADDR.ADDR_TYPE_CODE}...
  12. veles

    Mailing vs physical address

    Dell, Thanks for this All works up to number 4. I did the 3 steps and for a client that has both address types I got to display the correct address in the client header as you described. I created the variable in step 3, but where do I use it? I created the variable in step 4 and when I...
  13. veles

    Mailing vs physical address

    Hi, I need some help on an address formula. I have clients that have a physical address (all have one) and some have a mailing address.The physical and mailing address are stored in {ADDR.ADDR_TYPE_CD} I created a report grouped by client, then a group by {ADDR.ADDR_TYPE_CD}. I need to...
  14. veles

    Display record based on a condition

    Hi, I am using Crystal XI and I need a bit of help on a formula. I have Clients that might have a physical and/or mailing address. All clients have a physical address. I need a formula that will look through the records and if a client has a mailing address to display it if not to display the...
  15. veles

    Comparing 2 sums based on a group from a same field

    Hi, I need some help on a formula using crystal XI. I am trying to compare sums based on groups from a field. I have a field that hold items like bus, car, truck, road, river, air let's call it (Field1}. I have a formula that creates groups: if (Field1} in [bus, car, truck] then "vehicle" else...
  16. veles

    Displaying a signature in crystal XI from Siebel

    Hi, I am working on a crystal XI report from a Siebel database. I need to display a signature in the report. While in the screen the signature is visible, when the field is brought into the report it is in code like MwQAAA==AAAA4AwAAABAAgAAAAUAANACAA Is there a way to convert this back to the...
  17. veles

    Highlight record based on two conditions

    Thanks Pete, Worked like a charm.
  18. veles

    Highlight record based on two conditions

    Hi, I am using crystal XI and would appreciate some help. I need to highlight a field based on two conditions. The field is a sum of numbers (hours of employee). The employee can be with code CL or UC. I need to highlight the hours of CL under 40hrs. I have it to highlight any hours under 40...
  19. veles

    Adding hours or minutes from formula to a DateTime field

    It looks like the formula worked if I put it at the same level as the variable. I am still looking into it
  20. veles

    Adding hours or minutes from formula to a DateTime field

    Hi. I am using crystal XI and need some help. I have a DateTime field that I am trying to add hours (or minutes) comming from a variable from a sub report. The hours are calculated in a sub report and passed to the main report. In the main report I have the variable {VAR} as a number. I need...

Part and Inventory Search

Back
Top