Replace Old ones?

[#1]

Hi All,

I am having Some Product code and Supplier names...

If I am Selecting in the Product Code, I am getting the Relevant Supplier name...

But for Some of my Product codes Some New Suppliers are added, Where ever Product code we have added new Supplier name it was not Showing in the Report...

Because if I am Selecting Product code , Then 2 Supplier Names are Showing(Old Name & New Name), because of ambiguity it was not showing in the Report, I Need to get the New Supplier Name in the Report...

How to to acheive this...

Help required...

Regards,

Heather

[anbu1984]

If you have any date field, then you can use Firstsortedvalue() to retrieve latest supplier name

Firstsortedvalue(SupplierName,-Date)

[Anonymous]

Hi,

Please can you post the expression you are using,if any.

so can help.

If possible post the sample data.

Regards

Neetha

[#4]

HI anbu,

I have One Flag, If i am using that flag condition "Y" i am getting Correct Supplier Names, but the thing was for Some Product code there is no Supplier name Default, but I need to Show them with NUll Value only as Previously...

Regards,

Heather

[#5]

HI Neetha,

I am Simply Pulling the Field into Expression,

Because of Some Product code Names Supplier name has changed to a New One..

So in Report. I am not getting Supplier names because I am having One more New Supplier Name..

I need to get the Latest Supplier name, if i am not having any Supplier Names for any Specific Code it Should Show Blank..

Regards,

Heather

[anbu1984]

Do you mean text should be 'Null' in case of Null values in SupplierName?

If(Flag='Y',SupplierName,'Null')

[Anonymous]

May be try in script:

If((Len(Trim(SupplierName))='0','Null',SupplierName) as SupplierName