>I can see an inference that you might want OrderRelYes, this is what I want.
>line OR shipdtl lines with dates
> you would ONLY get recordsI've noticed this when I've tried multiple options on a report form.
I assume there is no way to put an AND or OR in with options.
--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> Without using embedded customization you would be prompted twice for the date range as each range, one for REQDATE and one for SHIPDATE, would be created separately in the report designer. Using embedded customization you would be able to hide one set of the ranges and populate it using the first range entered. The other thing to consider is as you have written it I can see an inference that you might want OrderRel line OR shipdtl lines with dates in that range. If you meant AND than you would ONLY get records with REQDATE AND SHIPDATE within the range. So if the orderrel REQDATE is outside of that range you would NOT get the record even if the SHIPDATE was within the date range.
>
> Jim Kinneman
> Senior Consultant
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Hi,
> >
> > I wonder if anybody knows if this might be possible with a BAQ report.
> >
> > I want to return all records from two tables based on a single date range.
> >
> > On the report form - I'd like to be able to enter a Start Date and End Date and have the BAQ return:
> > - Any OrderRel with a ReqDate within the date range and
> > - Any ShipHead with a ShipDate falling within the same range
> >
> > Thanks
> >
> > The BAQ has joins between OrderRel -> ShipDtl -> OrderHead.
> > There is some multiplication of rows. Not an issue in this case.
> >
>