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 IamaSherpa 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. Juliep

    Value from a formula to pull description from a static table

    I am using CR8.5 and am having problems in a report. I have a formula that pulls a string value from an activity table {@LastCode} (this formula locates a value of 999 then pulls next {Activity.PRODUCT_CODE} so is not always the same line number. This formula works just fine, what I need is to...
  2. Juliep

    pulling 2 values from same field

    CR8.5 I am trying to create a report and I need to pull 2 values from same field (Product_code). I have a table called ACTIVITY and need to pull the most recent and next most recent dates from the ACTIVITY.Transaction_date field, the ACTIVITY.Activity_Type needs to be = to "BBE" and...
  3. Juliep

    Page header needs to be like the phone book

    Would anyone know what I need to do to create a phone directory which would pull the first and last {Name.Last_Name} field from each page to be placed in the header of each page. This would be similar to what you see in the header of the phone book. Page one would say AARON - ACE and Page two...
  4. Juliep

    Need to pull odd or even years from a datetime field

    I need to create a report that pulls either all odd years and one for all even years from a datetime field (ie 3/1/1999 12:30pm). I also need it to exclude the current year. Does anyone have any suggestions. Thanks Julie

Part and Inventory Search

Back
Top