Hi there;
I had the similar struggle last week. And i posted it; and had helpful
response.
Go to your datasouce and click properties; in the property sheet set the
ordermode to Group by, MorpX will retrieve a single record for each group
BASED on the sorting fields.
Or you can use the following; Depending on how you selecting records
either(ablove or Below) approach would help.
SalesLine s;
;
while select s
group by ItemId
where s.SalesId == mySalesId
{
info(s.ItemId); // display distinct item ids
}
On 5/16/07, V G <[EMAIL PROTECTED]> wrote:
>
> Hi
> In the report parameter I have to show all the unique values of a field of
> some table as selection.
> So if there are three records in that table A where in the field X has
> values 1,2,3,2,1
> I have to show the values 1,2,3 in the parameter of the report as
> selection.
> I know this possible using lookup form. Can someone please tell me how.
> I can get all the five values if I write a relation on the extended
> datatype
> but I need just the unique values.
> Thanks
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
