Search results for query: *

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.

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

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

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

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

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

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

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 !

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

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

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 ?

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

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

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