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

Part and Inventory Search

Back
Top