Search results for query: *

Here it is.... http://www.locksmithstore.com/packing%20slip.rpt Thanks-

Can I upload the report here?

I'll try to clarify... This report is our packing slip from our accounting software. Currerntly the form prints as the items were entered in our application. We want the packing slip to sort by description instead of the way it was entered. I tried adding a simple sort order by description and...

Hello, Need help adding a sort order to a group header. Currently the group header is set to Temp.Order.Header.Number. I need to keep this in place while also adding a sort by description.

DISTINCT worked great! Thanks for the tip!

This is the problem! The UPS export feature is nice but surely lacking. You don't know which is the first. I dont care which I display in the query just that I only display 1. I dont think what I am asking for is possible but figured I'd ask anyway-

No date involved. Just an order number and tracking number thats it. Sometimes if a package is modified the UPS program will re-write to the table a second time. This is where it is becoming a problem.

I have a table for UPS tracking numbers and could possibly contain 2 or more entries with the same tracking number. Is it possible to write a query that would only show the first instance? I use this field on a crystal form and if it contains multiple tracking numbers it screws up the form. Thanks!

LB, That was it! Man, I can't thank you enough.... I tried everything.... Except the stupid join type! Thanks Again!!

It's not that the table is blank. The table does not exist if it is empty. Well it exists, but there is no entry for that order number. So, how do I write a formula to tell it to skip if it does not exist?

Tried all that.... Pulling my hair out on this one. Lets start from the top (If you dont mind :)) Btrieve database, Invoice form. Form prints fine when these fields are removed from the form. When fields are present with no value forms comes up blank. I have tried every suppression formula...

Thank you- if {TEMP_ORDER_HEADER.BVSUBTOTAL} > 100 then IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER} & totext({TEMP_ORDER_HEADER.BVSUBTOTAL},0),0 ) else IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER},0) That did it!

This is what I got, It is a formula for a barcode if {TEMP_ORDER_HEADER.BVSUBTOTAL} > 100 then IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER} & {TEMP_ORDER_HEADER.BVSUBTOTAL},0 ) else IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER},0) I need for...

I tried INT({table.field}) it returned 12300 instead of 123.50 Looking to get 123

Trying to use truncate to return a whole number... TRUNCATE ({field}) What am I doing wrong? Table contains order values. All entries have a 2 place decimal 123.45 I want to return 123?? What am I missing? Thanks-

I have looked at this more and the fields causing the problem are created on the fly. Not all invoices have these fields only some. SO, how would I tell it to skipover these if they are not present? This inoice worked fine with crystal 8 so I dont know what has changed?

I guess what I am asking is how to write the suppression formula? I have tried everything I could figure out with no luck. I am assuming it's not working because the form comes up blank. If I remove the fields from the form then it prints fine. Maybe I have to suppress while reading records??

Just upgraded our accounting software and the new version is using crystal 10. Old edition used crystal 8. Anyway if some of the fields are empty the invoice just prints blank. What am I missing? I tried to suppress without it helping. I eliminate those fields that dont show on every invoice and...

Want to create a database query based on dynamically driven drop-down menus. Query is not the problem, problem is dynamically creating the drop-downs. Access is database source. Using Frontpage I can create the three drop-downs, but cannot have them change without hitting submit. I think I need...

Hello, Working on a website and have to generate about 15,000 extended product descriptions. Most products have similar characteristics. Wondering if anybody has any idea of some kind of a text-input to html output form or something to speed this up. Maybe a GUI so people not "HTML...