Distinct In BAQ or Crystal

Yahoo Archive
1
I kind of figured it out in crystal by suppressing the detail section with Next(). Works as long as my sort is okay. Still not sure why PreviousValue doensn't work but, more interesting would be the distinct in the BAQ if anyone has any ideas..


--- In vantage@yahoogroups.com, "ramsey_burns" <ramsey@...> wrote:
>
> Hi All,
>
> What I'm trying to do is look at my partnums from POs and then see what country these parts were shipped to. So my BAQ is like:
>
> for each PODetail no-lock , each ShipDtl where (PODetail.PartNum = ShipDtl.PartNum) no-lock , each ShipHead where (ShipDtl.PackNum = ShipHead.PackNum) no-lock , each Customer where (ShipHead.CustNum = Customer.CustNum) no-lock .
>
> Which works okay except when I've purchased the part more than once of course I get multiple lines. So I really need to get the 'distinct' partnums from PODETAIL but I haven't figured out how to do that.
>
> A second solution would be to do it in crystal, which in theory would be easy but I haven't figured that one out also I tried PreviousValue function on packnum/packline but no luck.
>
> Thanks in advance for any tips.
>
> Cheers,
>
> -Ramsey
>
2
Hi All,

What I'm trying to do is look at my partnums from POs and then see what country these parts were shipped to. So my BAQ is like:

for each PODetail no-lock , each ShipDtl where (PODetail.PartNum = ShipDtl.PartNum) no-lock , each ShipHead where (ShipDtl.PackNum = ShipHead.PackNum) no-lock , each Customer where (ShipHead.CustNum = Customer.CustNum) no-lock .

Which works okay except when I've purchased the part more than once of course I get multiple lines. So I really need to get the 'distinct' partnums from PODETAIL but I haven't figured out how to do that.

A second solution would be to do it in crystal, which in theory would be easy but I haven't figured that one out also I tried PreviousValue function on packnum/packline but no luck.

Thanks in advance for any tips.

Cheers,

-Ramsey