Creating a new Crystal report

....just remember the relation between jobs and orders goes down to the Order Release level. (JobProd links to OrderRel)

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kirstin Brandt
Sent: Thursday, March 17, 2011 1:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Creating a new Crystal report.



BAQ Phrase would look like:

for each JobProd where ( JobProd.OrderNum <> 0) no-lock , each OrderDtl where (JobProd.Company = OrderDtl.Company and JobProd.OrderNum = OrderDtl.OrderNum and JobProd.OrderLine = OrderDtl.OrderLine) no-lock , each OrderHed where (JobProd.Company = OrderHed.Company and JobProd.OrderNum = OrderHed.OrderNum) no-lock , each QuoteDtl where (OrderDtl.Company = QuoteDtl.Company and OrderDtl.QuoteNum = QuoteDtl.QuoteNum and OrderDtl.QuoteLine = QuoteDtl.QuoteLine) no-lock .

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "sanfranc415" <sanfranc415@...> wrote:
>
> I'm in need of a report that includes:
>
> jobnum, ordernum, quotenum, ponum, and leadtime (from quote).
>
> Does anyone have a suggestion on an existing report, 8.03.405B, or which tables to use and links?
>
> Thanks,
>
> --sf
>



[Non-text portions of this message have been removed]
I'm in need of a report that includes:

jobnum, ordernum, quotenum, ponum, and leadtime (from quote).

Does anyone have a suggestion on an existing report, 8.03.405B, or which tables to use and links?

Thanks,

--sf
BAQ Phrase would look like:

for each JobProd where ( JobProd.OrderNum <> 0) no-lock , each OrderDtl where (JobProd.Company = OrderDtl.Company and JobProd.OrderNum = OrderDtl.OrderNum and JobProd.OrderLine = OrderDtl.OrderLine) no-lock , each OrderHed where (JobProd.Company = OrderHed.Company and JobProd.OrderNum = OrderHed.OrderNum) no-lock , each QuoteDtl where (OrderDtl.Company = QuoteDtl.Company and OrderDtl.QuoteNum = QuoteDtl.QuoteNum and OrderDtl.QuoteLine = QuoteDtl.QuoteLine) no-lock .

--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> I'm in need of a report that includes:
>
> jobnum, ordernum, quotenum, ponum, and leadtime (from quote).
>
> Does anyone have a suggestion on an existing report, 8.03.405B, or which tables to use and links?
>
> Thanks,
>
> --sf
>