Claudine, I'm glad it worked!
We had a situation several years ago when one customers piece of equipment showed up on anothers equipment list as well as their own. We had always assumed then there would never be the same piece of equipment with the same serial number between 2 customers but it happened. We had used a breaking report but had to add an additional where for the proper customer for the report to work properly. Jan ----- Original Message ----- From: "claudine robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 21, 2004 1:09 PM Subject: [RBG7-L] - Re: Lookup dilemna > Open mouth, insert foot. > > Yes, yes, yes. I added an additional expression variable and a condition on > the detail line where carrier invoice number = .vinvoice and carrier code = > .vcarcode and it works! > > Thanks for helping me see this in the right context! Have a nice day. > > Claudine :) > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of claudine > robbins > Sent: Wednesday, July 21, 2004 2:42 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Lookup dilemna > > Aye, aye, aye, I can't do that, there might be several differenct carriers > with the same iex invoice number.... Remember, the first break is iex > invoice number. The line containing iex invoice number X03-1000 should not > even be looked at... > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Johansen > Sent: Wednesday, July 21, 2004 2:08 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Lookup dilemna > > Claudine, > > We sometimes have the same problem. If 2 carriers are going to have the same > invoice id, then I think you are going to be more specific in your where > clause i.e. PRINT INV_DETAIL WHERE INVNBR = 'X04-1431' AND CARRIER = > .vCARRIER OPTION > PRINTER. > > I'm pretty sure that RBase always takes the first instance. > > Jan > > ----- Original Message ----- > From: "Claudine Robbins" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, July 21, 2004 12:00 PM > Subject: [RBG7-L] - Lookup dilemna > > > > I have a report (invoice_detail) based on table carrier_invoices. > > Carrier_invoices table has two records as follows: > > Date carrier carrier invoice iex invnbr amount > > 01/01/03 ABC 20488 X03-1000 $500 > 07/20/04 DEF 20488 X04-1431 $1000 > > I am printing invoice X04-1431 > The print command is PRINT INV_DETAIL WHERE INVNBR = 'X04-1431' OPTION > PRINTER. > > The first break is on the iex invnbr, the second on the carrier invoice > number. > > Date is correct - 7/20/04 > Carrier name is correct - DEF > Carrier invoice number is correct - 20488 > IEX invoice number is correct - X04-1431 > Amount is incorrect - It prints $500 instead of $1000 > > I simply renamed the first carrier invoice number in order to print the > correct amount but am wondering what's wrong with this scenario... It > simply is unavoidable that different carriers might have identical > invoice numbers... > > Claudine :) > >
