Search results for query: *

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

Hi, This is a pretty common sales report, with sales dollars grouped first by salesman then by product group. This part was pertty straight forward. I would like to now total all sales by each product group. This is not so straight forward. I tried to use a Select statement by my syntax must not...

Ivan, There is a dataset relationship dashboard under system managment. This will probabaly give you the join information you are looking for.

So it looks like I am not going to be able to do what I thought I could do. What I want to do is monitor a particular field in a particular record. The field is called 'qty_on _hand'. This would be constrained by the field 'item_no' and field 'loc'. A change to this field only is what I want to...

Hi All, I have looked at several examples of triggers that fire on update of a column, but I would like to fire a trigger on the the update of a column of a particular record. Ideally my trigger would look something like this: CREATE TRIGGER test_trigger ON [dbo].[IMINVLOC_SQL] FOR UPDATE...

ifrydr, You can do that. The only thing is that the standing cost is going to be a little higher than the cost as built. What you would end up doing is having both items on the standing bill, then remove one in the captured bill at shop order or pop order release time. This is going to be a...