Problem with SETCURRENTKEY

-matrix- · 2011-08-24

Hi Guys,

I have a report with a dataitem 'Table1' in OnPredataItem Before do a Table1.SETFILTER i use the Table1.SETCURRENTKEY(key).
But If i use SETCURRENTKEY the filter is not correct and exctract only 2 records else without the instruction the filter work.

I Don't understand why the filter doesn't work .

Thanks

mohana_cse06 · 2011-08-24

Can you the code?

check whether you have any filter on DataItemTableView property..

-matrix- · 2011-08-24

On DataItemTableView property There is only the sorting on the same key that I'm going to filter .

mohana_cse06 · 2011-08-24

mohana_cse06 wrote:

Can you the code?

Can you show us the code?

-matrix- · 2011-08-24

testTable.SETCURRENTKEY(testTable.Date,testTable.Line)
testTable.SETFILTER(testTable.Date,'%1..%2',Data1,Date2);

mohana_cse06 · 2011-08-24

-matrix- wrote:

testTable.SETCURRENTKEY(testTable.Date,testTable.Line)
testTable.SETFILTER(testTable.Date,'%1..%2',Data1,Date2);

Is testTable a variable or Dataitem only?

If it is dataitem ,the code seems ok to me..

Are you sure the data filtered is wrong?

-matrix- · 2011-08-24

Yes It's the dataitem, the filter is correct because without SETCURRENTKEY works :-k

MBerger · 2011-08-24

Do you have any grouping in your report ? Because that is the only thing i can imagine that could interfere with another sorting on a report.

-matrix- · 2011-08-26

Yes, the dataitem is Indented under DataItem Integer with sorting on Number but the 2 dataitem aren't linked.
I think that the problem is the filter on DateTime 000000T..235900T.

vaprog · 2011-08-26

Is there any modification done to the testTable dataitem (assignments to key fields, with or without INSERT MODIFY,RENAME,DELETE) or the table it referes to from within the report?

Problem with SETCURRENTKEY

Comments

Categories