Search results for query: *

Thanks, That has pointed me in the right direction and I have managed to get it working. Your assistance has been much appreciated. Regards Richard Chambers

Thanks very much for your quick reply. The problem is I only have 1 detail line and do not know ahead of time how many labels I will need. There can be up to 50 or more boxes in a shipment so hard coding a section for a box and then supressing it if the number of boxes is less than required is...

Can you help me please. We are using Crystal 8.5 with Oracle 9i. We have a requirement to print out labels to a Zebra printer using ZPL language. This is normally not a problem to embed within crystal the ZPL code and pass the variable information as required. Within ZPL there is a function...

Thanks very much. Filter works fine in 8.5. Your code is great. It took me a little while to work out just what you were doing. You had 3 functions in there I had never heard of! :-D Your assistance is much appreciated.

Hi Guys, I am using Crystal 8.5 and have a set of strings in data fields which contain data like "212,212,212,212,212,120" "216,216,216,216,216,216" What I wish to do is count how many of each value is in the string ie 5 212's and 1 120 or 6 216's etc. There can be up to 20 different values...

Hi LBass, I can see where you are coming from but Crystal 8.5 will not allow count() in the SQL Expression Builder. :{ (select count(AKA.REASON_DESCRIPTION) from WM_QUOTE_WON_LOST\\ AKA where AKA.REASON_DESCRIPTION = WM_QUOTE_WON_LOST\\.REASON_DESCRIPTION) I get an ora-00911:invalid...

Thanks LB. Excellent suggestions and the code is superb. I had not even thought of a Cross Tab. A pity the percentage is not a bit easier <grin>. I have looked at the thread you suggested but still cannot see how I could apply it to this situation. Sorry for being a bit thick!! One thing I...