Filtering a report by userid

sabzam

Dear All,

I need to set a filter on a report which is the userid. That is instead of having the user entering his user id it is automatically filtered. Should I use setrange or setfilter because they don't seem to work out?

fl

They will work both. Hard to say why it doesn't work like that. Can you post your code here ?

sabzam

BankLedgerEntry.Setfilter("User ID", USERID);

Where BankLedgerEntry is of type record "Bank Account Ledger Entry". This code has been set up in the pre-data item.

kine

is "BankLedgerEntry" name of the DataItem or just some global variable?

aliennav

No more replies??

Mbad

Kines question needs to be answered first.

aliennav

Mbad wrote:

Kines question needs to be answered first.

thats what i was talking about

Mbad

Damn missed that one aliennav, sorry

vyanku

create a key of userid in bank ledger entry table.
In report
Change the dataItemTableView property to userid .
it will work.

kine

vyanku wrote:

create a key of userid in bank ledger entry table.
In report
Change the dataItemTableView property to userid .
it will work.

1) Field or Key? do not mix that... why creating key with User ID if it is not necessary.
2) dataItemTableView has two parts - sorting (active key) and filters. Why to set sorting to USERID if you need filtering?

It seems that you are answering question which was not asked... 8-[