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!

Search results for query: *

  1. jjenright

    sort running total

    I am using crystal xi. How can I sort on a running total field ? Is it possible ? I want to show the top 10 spending amounts for a group of vendors. Thank You for your assistance.
  2. jjenright

    Parameter based on other parameter

    I am using Crystal 10. Is there a way to have one parameter that is dependant on another ? The user can select any of 6 local systems in one paramter. Based on the local system selected I would like to make available to the user another paramter (locations) that contains only the records...
  3. jjenright

    Top 10 sort on running total percent

    I am using Crystal 10. I need to show the top 10 buyer percentages based on the following formula: if {#Total ALL Item Dollars by Buyer}=0 then 0 else ({#Total Special Item Dollars by Buyer}/{#Total ALL Item Dollars by Buyer})*100 How can I show the top 10 buyers based on the percent of...
  4. jjenright

    Replace extraneous characters

    Thank You Borislav Borissov I worked with the code you provided and tested the following whish works : UPDATE LAWSON.VIEW_SPECIALS_MAIN SET VEN_ITEM = REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE( '-','') ,'.','') ,' ','') ,'/','') ,'\','') ,'(','') ,')','') I want to create and...
  5. jjenright

    Replace extraneous characters

    Hello! I need to find extraneous characters in a field and remove all of them. I want to create a new field that will contain the field with all extraneous characters removed. I was given the following code but it does not work: SELECT VIEW_SPECIAL_MAIN.ITEM REPLACE...
  6. jjenright

    Suppress Header

    lbass, Thank You for your assistance. This worked very well.
  7. jjenright

    Suppress Header

    The running total is the count of the field {Item} evaluated by a formula {LINE_TYPE}="X" (this represents a special order for an item that is not on an existing contract - not a contract purchase). It is reset when the accounting unit or department changes. When the count for any accounting...
  8. jjenright

    Suppress Header

    moliver827, Thank You. It doesn't seem to be working though. The running total is not calculated until after it is printed in the footer. How can it be calculated in the header and then suppressed if it is zero as I am doing in the footer ? I think whilereading records Thanks for your help !
  9. jjenright

    Suppress Header

    I need to suppress the Group Header for each group that does not have any records in the Group Footer. The footer contains a running total. The footer is suppressed when the running total = zero. I want to suppress the header when the footer is also 'conditionally' suppressed. I am using...
  10. jjenright

    replace command in oracle sql

    How do I convert the following Crystal 10 code to an SQL statement to be used in a view ? replace(replace(replace(replace({VIEW_SPECIAL_MAIN.VEN_ITEM},"X","",1),"-",""),".","")," ","") Thank You, John Enright
  11. jjenright

    My post thread767-1261778 and solution thread767-458596

    I believe the post I made today can be answered by what I believe to be the solution post. My question is how do you do the lookup in the subreport ?
  12. jjenright

    Show items NOT Found in table

    I need to display on a report all items that DO NOT exist in a table. The item is entered with characters that I remove. I then want to see if this item with the characters removed exists in a table. If it DOES NOT I want to display it on my report. Fo example : The item is entered as...
  13. jjenright

    Remove Special Characters

    I would like to remove all special characters from a text field. Special characters include an X, ., -. For example, X123456 987.654 99-8888 Usually, the X will be in the first position. I would like to remove all . (dots) and - (dashes) and have the remaining text displayed, 123456...
  14. jjenright

    Charting

    I have one group showing using a formula for comany groups. For example (if company # in 1 to 10 then group = 1, if company # in 11 -20 then group = 2, etc.) I use a running total for each group to get total dollars for that group. I then total the running total for each group into a grand...

Part and Inventory Search

Back
Top