Search results for query: *

numeric

Thanks for your response. I tried this but I couldn't get it to work. I got an error "the string is non-numeric". I did get another thing to work. if {order} = 0 then "" else ToText {order} The problem is the number is a format with a comma and .00 (example 1,234.00) I need it as just the...

I am trying to do a count using a Running Total Field in Crystal. I would like it to count Order Numbers but it put zeros instead of blanks when there is no order number, so when I do the count it counts the zeros also. I am evaluating on change of group and resetting on another change of...

Thank you for all your help that worked! LL

Thank you for your response! I am sorry but I am a novice at Crystal. How do I set up a shared variable for the subreport. Is it just done as a formula? LL

I need to add a running total from a main report to a running total form a subreport. What is the best way to do this.

I am not quite sure what you are asking, but our software uses BAQ (business activity queries) and then it's downloaded to Crystal. I'm sorry am new to all of this.

I will give it a try.

The dates will be changing whenever this is run. Thanks for all your help I will see if anyone else resonds.

Yes there is a field in the database for the number and description for cutting, welding, etc. (we have more areas than these).

Okay, As far as more data I don't know if this is what you had in mind but I will try Group Cutting Job Load Dates Start date 7525 3.5~5~5~3.5 3916~3917~3918~3919 9/21/09 7437 4~5~5~4.5 3916~3917~3918~3919 9/21/09 7521 5~5~5...

This is a report for the shop load for production. There could be load before today and further into the future. There is no maximum number of days for a job the most I have seen is 9 days, but it could be more. Thanks for all your help LL

I need to convert the dates to normal date formats, but I also need to separate the hours and dates from each other so I can total the hours for each date for each job. for example Job number hours days start date 7437 1~6~6~3.5 3916~3917~3918~3919 9/21/09...

I need help to separate the data my database returned to me that is separated by ~'s. For example the hours per day of load for production would be 1~6~6~3.5 for a start date of September 21 thru September 24th. The next part of this is to convert the days. The days per each day of load are...