using @* in Setfilter

subhadynamics

Hi All

The Item Ledger Entry table we have a field "Issued For".The Issued For field we have given the data like this For Eg: Branch Transfer from Bangalore,Branch Transfer from Hyderabad,Mechanical,Grinding Etc ..

I have a report using this same filed "Issued For ".but i need to filter the records like this @*BR.TRFR* in the Reports .How can i use the same filteration in the reports .

I have given the code like this

recItemLedgerEntry.SETFILTER(recItemLedgerEntry."Issued For",'<>%1','@*BR.TRFR*');

But this is not working in the reports!

Please help me out !!!

Thanks

Subha

navuser1

this will help you.

subhadynamics

Thanks For the reply.

But my report to filter the records without the branch transfer details from Issued For
field .I need to filter with the field issied for with <>%1 ,BR.TRFR.

Thanks

Subha

navuser1

subhadynamics wrote:

Thanks For the reply.

But my report to filter the records without the branch transfer details from Issued For
field .I need to filter with the field issied for with <>%1 ,BR.TRFR.

Thanks

Subha

SETFILTER(Issued For",'<>%1','*BR.TRFR*');

vijay_g

navuser1 wrote:

SETFILTER(Issued For",'<>%1','*BR.TRFR*');

the guy telling you, i think he has not used it before posting either it can't be possible if you will try it on object designer will not work but you can try to help of Mark Or Unmark to do for it.

subhadynamics

yea the above filteration is not working in that Reports.

vijay_g

subhadynamics wrote:

yea the above filteration is not working in that Reports.

right. but in report you can skip these records that r lying in SETFILTER without '<>%1'.

subhadynamics

how can skip the records ???

David_Singleton

The way you are doing this is completely wrong. You should have a code field that drills down to a list of options with a key on that field and filter an option. Then you need to carefully think out the options so that they work for you.

The problem here is not code, the problem is that you have not solved the business requirement of the customer correctly.

navuser1

navuser1 wrote:

SETFILTER(Issued For",'<>%1','*BR.TRFR*');

Sorry !
This will not work.

Use CurrReport.SKIP function to skip those records which you want.

bala_first

sehnazjoshep wrote:

Ya this is not working for me I have tried out all the option which is mentioned here. Anyone is here for sloving this problem?

hi,

try this one..

SETFILTER(Issued For",'<>%1','@*BR*TR*FR*');


this will work if 'Issued For' field is a Text or code data type only.....

Sog

TS wrote:

How can i use the same filteration in the reports .

I'll think you want to have this answer.
So I suggest you don't place the filter on some variable in your report, but on the dataitem (aka a record) iterating those ledger entries.

I encourage you to read and reread your requests. We have NO knowledge of your situation, just describe the problem as best as you can, so we can help you the best way we can