Fair enough. It's not doable with the BAQ Phrase Builder, unfortunately. Data forensics wasn't the intent behind the development of the BAQ tool. If you could add criteria to a Calc'd field then I believe we could.
--- In vantage@yahoogroups.com, "Przemyslaw" <przemyslawhinz@...> wrote:
>
>
> Thx, but the point is to make BAQ.
> Otherwise I can do it via ODBC in Excel or CR without Epicor.
>
> Przemyslaw
>
> --- In vantage@yahoogroups.com, "vicdrecchio" <vic.drecchio@> wrote:
> >
> > I would suggest making a BAQ with the data and do the grouping in Crystal Reports.
> >
> >
> >
> >
> >
> > Vic
> >
> >
> > --- In vantage@yahoogroups.com, "Przemyslaw" <przemyslawhinz@> wrote:
> > >
> > > Hi,
> > > Is there any way to build BAQ to show result similar to:
> > > SELECT ordernum, shortchar01, shortchar02, shortchar03,
> > > COUNT(ordernum) AS NumOcc
> > > FROM orderhed
> > > where shortchar01 <> ''
> > > GROUP BY ordernum, shortchar01, shortchar02, shortchar03
> > > HAVING ( COUNT(ordernum) > 1 )
> > >
> > > group by I can do by "Show group by" option.
> > > How to put Having statement in BAQ?
> > >
> > > Best regards,
> > > Przemyslaw
> > >
> >
>