RB help!

Thank you.


----- Original Message -----
From: "Winter, Patrick" <pjw@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 31, 2003 12:12 PM
Subject: RE: [Vantage] RB help!


> I think so. Join partbin and oprice with company and part number.
> Group & Sort by part, bin then Oprice.StartDate or Oprice.EndDate
> Supress record lines and pull down the price with a calculated field.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Mike Tonoyan [mailto:miket@...]
> Sent: Friday, January 31, 2003 1:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RB help!
>
>
> In one of my Report Builder Reports I need to join "PartBin" and "Oprice"
> tables, and need to select only the latest dates from "Oprice" records for
> each "PartBin" Part Number. Is it possible to do this in Report Builder?
>
> Mike Tonoyan / MIS Manager
> All American Products Co.
> 1135 Aviation Place
> San Fernando, CA 91340
> USA
> Tel.: 818-361-0059 Ext.: 246
> Fax 818-898-2236
> E-mail: miket@...
> Web: www.allamericanproducts.com
>
>
In one of my Report Builder Reports I need to join "PartBin" and "Oprice" tables, and need to select only the latest dates from
"Oprice" records for each "PartBin" Part Number. Is it possible to do this in Report Builder?

Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340
USA
Tel.: 818-361-0059 Ext.: 246
Fax 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com
I think so. Join partbin and oprice with company and part number.
Group & Sort by part, bin then Oprice.StartDate or Oprice.EndDate
Supress record lines and pull down the price with a calculated field.

Patrick Winter


-----Original Message-----
From: Mike Tonoyan [mailto:miket@...]
Sent: Friday, January 31, 2003 1:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB help!


In one of my Report Builder Reports I need to join "PartBin" and "Oprice"
tables, and need to select only the latest dates from "Oprice" records for
each "PartBin" Part Number. Is it possible to do this in Report Builder?

Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340
USA
Tel.: 818-361-0059 Ext.: 246
Fax 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/