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

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

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