New Crystal Report ODBC

Yahoo Archive
1
Finally got the "shotgun" report to print the QuoteDtl.Leadtime here is my current report:

JobHead.ReqDueDate, JobProd.JobNum, JobProd.PartNum, JobProd.Qty, Customer.CustId, QuoteDtl.Leadtime, OrderHed.PONum.

The problem was with the links between JobProd and OrderDtl. Once this link was made to "Left Outer Join" things sped up and no more connection errors.

Also, JobHead and JobProd are "Left Outer Join."


Hope this helps anybody have similar problems.

Thanks,

--sf
--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> Working on a "shotgun" report that includes the following:
>
> CustID, OrderNum, JobNum, QuoteNum, and QuoteHed.Leadtime.
>
> I've got all working, but having problems after linking the CustID from the quote or order tables. After dragging into the preview, I get an error about ODBC connection.
>
> Any help would be great.
>
> Thanks,
>
> --sf
>
2
Working on a "shotgun" report that includes the following:

CustID, OrderNum, JobNum, QuoteNum, and QuoteHed.Leadtime.

I've got all working, but having problems after linking the CustID from the quote or order tables. After dragging into the preview, I get an error about ODBC connection.

Any help would be great.

Thanks,

--sf