DaveO,
I was solved this same problem recently. I created a BPM that copied the PO Number into Character01 when the PO was saved. Then in the Report Data Definition of PO Form I linked Character01 from the PO header and Key1 from TranGLC. I then created a sub report to display the GL account on the POForm, I filtered on PO Line with Key 2 and PO Release with Key 3.
I can provide more details if you are interested.
Bryan Sapot
www.datixinc.com
I was solved this same problem recently. I created a BPM that copied the PO Number into Character01 when the PO was saved. Then in the Report Data Definition of PO Form I linked Character01 from the PO header and Key1 from TranGLC. I then created a sub report to display the GL account on the POForm, I filtered on PO Line with Key 2 and PO Release with Key 3.
I can provide more details if you are interested.
Bryan Sapot
www.datixinc.com
--- In vantage@yahoogroups.com, "DaveO" <daveolender@...> wrote:
>
> Thanks, for the re-enforcement. Now that I know I can do a BAQ I'll have to consider re-doing this one as a hybrid BAQ/ODBC Report Rather than a just a pure ODBC.
>
> Thanks again,
>
> DaveO
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > > dissimilar data types.
> > As you've found the join works in a BAQ, not in ODBC.
> >
> > > > I toyed with the idea of using a formula and a subreport to >>lookup the chart number, however that seems very clunky and ugly.
> > That would be my guess if you must use ODBC.
> > In my case, I was able to use a BAQ.
> >
> > --- In vantage@yahoogroups.com, "DaveO" <daveolender@> wrote:
> > >
> > > I see there are solutions here describing a BAQ join. However, I would like to use ODBC for my DB connection.
> > >
> > > DaveO
> > >
> > > --- In vantage@yahoogroups.com, "DaveO" <daveolender@> wrote:
> > > >
> > > > We are running 9.05.606. Progress 64bit on Windows 2K8.
> > > >
> > > > I would like to create a report using crystal to print open po's.
> > > >
> > > > I would like to include the GLChart number for each PORel.
> > > >
> > > > It appears that the TranGLC has the PONum, Line, and Rel fields associated with Key1, Key2 and Key3 fields. However the fields in TranGLC are strings (text) and the fields in PORel are Numbers.
> > > >
> > > > Crystal does not allow me to join two tables using dissimilar data types.
> > > >
> > > > I toyed with the idea of using a formula and a subreport to lookup the chart number, however that seems very clunky and ugly.
> > > >
> > > > Any suggestions out there?
> > > >
> > > > Thanks in advance,
> > > >
> > > > DaveO
> > > >
> > >
> >
>