Recent content by Rob7

Thanks lbass. Exacly what I was looking for.

Hi, This is Crystal XI and I have a subreport that shows all of the serial numbers for items I have in stock. This could be several hundred items and each serial number is a 'next line' record. Is there a way to wrap the text in this condition to reduce the length of the report? Thanks, Rob

From the Crystal Help Test: To insert a picture onto the report On the Insert menu, click Picture. Tip: Another way to do this is to click the Insert Picture button on the Insert Tools toolbar. Select an image file, and then place it in the Page Header section, to the right of the fields...

Just a short note to end this. I spoke with Crystal support and they did not know anything about this problem and suggested I uninstall and reinstall Crystal. This did work and the dash is gone from the browsed data and I can use the select expert to select for Zero. Thanks for looking...

The other reporting tool is a query tool thats built into the application the database works with. And I did try that formula but because this is a numeric field, Crystal tells me that the "-" is not acceptable. It has to be a number. I think I have something wrong with my crystal installation...

LB, I was but I removed all but the one table. I also looked at the data in another reporting tool and there are in fact zeros in the field. And another interesting thing is that when I browse the data in the select expert, there is no zero prior to the 1.00 in the list of browsed values. It is...

I did that and I am still getting the error. I also created a formula field with: If IsNull ({JobProd.QtyShipped}) Then 0 Else {JobProd.QtyShipped} Neither of these worked.

Hi All, This is Crystal XI sp2 running on a Progress Database. I am trying to select on a numer field and get records that are a zero. So, in the select expert, I choose the field (QtyShipped) then the condition (is equal to) and enter zero in the field. When I click OK, I get an error...

I figured it out. I was trying to find a complicated answer to an easy problem. All I had to do was change the formatting of the field from Custom to (-1234). and the zero shows up. Thanks for looking k Rob

k I tried that and it highlighted the "-" and indicated that number was required there. I also the tried ToNumber("-") but Crystal didn't like that either. Rob

Hi All, I am working with a database that will show a dash (-) in a numeric field when the value is zero. I would like to show the zero on my report. I have tried to create a formula field with: If {TableName.FieldName} = "-" Then 0 Else {TableName.FieldName} When I do this I get an error...

Sent the prior before I was really ready to. So with this set up, I want to group by the RepCode and show the invoice numbers the rep worked on and commission amounts.

Crystal version is XI, the data base is Progress. The data record line has the invoice number, data and amount. Pretty standard stuff. Then there are these two list fields. The rep code filed would have for example CW~STT~LT~~ if there were three sales guys included on the commission of the...

Hi All, I have run into a situation where I need to group by pieces of a list field. This is a sales commission report and in the invoice record, there are two list fields, one for the sales rep code and one for the actual commission dollar amount. I found a formula to split the codes out into...

That was a killer solution. Thanks much. By the way, is there a good book on Crystal you would recommend? I think I will be needing it. Rob