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!

Recent content by sandeejh

  1. sandeejh

    Is it possible to text to column in CR IV

    Hello everyone I have created a report that includes customer’s shipping information. The shipping information comes across with carriage returns. I created a formula to replace the carriage returns//Replace(Replace({RESCARD.SHIPTOADDRESS},chr(13),"^"),chr(10),"^")// Currently I run the report...
  2. sandeejh

    surpress duplicates

    This might be easy however I have been researching all day long and cannot find the answer I need. I'm almost done with my report, I need one more formula to finish... I thought I finished my report. All the formulas were in place all the calculation looked beautiful then my supervisor came in...
  3. sandeejh

    can i use the result of a formula to select certian records

    Thank You LB for all your Time and Help. Got to work this morning and gave the formula one more try and noticed that I was spelling the formula wrong. OMG I am a silly monkey. My original formula was spelled dispaly formula BIG TYPO and i kept typing @display formula.... One more question, if...
  4. sandeejh

    can i use the result of a formula to select certian records

    okay this is what i did: ItemA ItemB ItemC 1) Group Header I placed @reset formula: WhilePrintingRecords; StringVar chain := ''; NumberVar ChCnt := 1 2) Details I placed @Accum formula, putting your field into the second line: WhilePrintingRecords...
  5. sandeejh

    can i use the result of a formula to select certian records

    thank you for responding,when i try to use the formula you suggested the error message comes up highlighting {@display formula} and says "the field name is not known". is there another step to it? I copied and paste the formula you suggested. I applied the correct formula name and value name...
  6. sandeejh

    can i use the result of a formula to select certian records

    Hello I have a formula in the group footer that displays all the detail results on one line:The formula is part of a 3 step formula.The final formula which displays the details all on one line is called @display formula. Example D1 A D2 B D3 C // I now have them displaying on the group footer...
  7. sandeejh

    Sum the revenue that is associated with a client

    Hello I've been searching for a formula that will help me, nothing is making sense. I have a report that is generated from our data base. My customers have a distinct reservation number. In the reservation number there are different prices for AIR,HOTEL,CRUISE,TRAVEL INSURANCE and MISC Charges...
  8. sandeejh

    Need a formula that will display a unique identifier number

    Hi there I’m looking for a formula that will display a unique identifier number for each record on my report. When I run the report again, I would like the number to start off sequentially from the last report. If there is away to place the letter B infront of the generated number. I’m stumped...
See more

Part and Inventory Search

Back
Top