Recent content by gmman

I need to add that if it is a sub report you may have to set up the suppress blank section there.

You probably want to go to format section and suppress blank section. That should eliminate the spacing.

Rosemary, I will check with the DBA tomorrow, I tried the statement with substr and I get a Crystal Reports: Database Error ORA-00936: missing expression

Rosemary, Our database is Oracle8i so I expect that that will not work for me.

I am using Crystal 8.5 and I am tring to make a box repeat in the detail that may grow several lines. Below is an example of the text. This comes from a data type LONG. I am setting it up in 3 columns so one of the lines will wrap. Placarding at proper location on tool. Energy isolating device...

That did the trick, no errors!!!! Thanks Brian

Just ignore them so that formula does not apply

Well I would like to say that it was bad data but there are a few locations that don't use a rack number. Example: "1-A1" rack "1" row "A" bin "1" , some locations just use row and bin "A1". I was just wondering if there is a way to ignore the...

Brian I tried your formula after I got rid of the spaces and it worked fine when I filter out the data that does not have the "-" in it. If that data is included I get the error: String length is less than 0 or not an integer.

There is also some other data in that field that does not have the "-" in it. Is there a way to ignore that so that I don't get the error: String length is less than 0 or not an integer.

After looking through the field I found a lot of them with spaces, once I removed them it worked without an error.

lbass when run it before I put it in the sort the data looks ok, but when I add it to the sort I get this error: String length is less than 0 or not an integer. Thanks for all the help so far, I am shutting down for the night so I will check in tomorrow. It looks like it is getting close

lbass I had to change your formula to: left({INVENTORY.BINNUM}, instr({INVENTORY.BINNUM},"-")+1)+ totext(val(mid({INVENTORY.BINNUM},5)),"00") I was just getting "00" as the last 2 digits. Also it does not sort by the first 2 digits. It starts with 10, 11, 12 ect...

Well I thought that fixed it until I found the number before the "-" goes up to 20 in some locations so that messes the formula up.

lbass your formula worked just right, thanks a bunch!! Brian I'll try yours to see if it works, thank you for quick response!!