RG 23 Part A 1 does not have an active key at index -1

sachin421

hi experts,
while I am running report I am getting an error 'RG 23 Part A 1 does not have an active key at index -1' what would we the solution??
Thanks in advance.

mohana_cse06

design the report
locate dataitem RG 23 Part A 1
Click Properties
Select property DataItemTableView
click lookup
check what is in Key
check whether key exists in RG 23 A Part I table.

sachin421

Thanks for the reply ..
sir Posting Date as a key is define in the dataitem ....what to do sir??

mohana_cse06

mohana_cse06 wrote:

check whether key exists in RG 23 A Part I table.

Check this..

sachin421

yes sir key is existing sir I had defined posting date as a key but it did not work so ??? ](*,)

geordie

Please check also if the key is active (Enabled = true) to avoid the error.

sachin421

yes sir key is active I mean Enabled to true ...
Thanks for the reply sir.

sachin421

Hello Sir,
when I remove key from like(DataItemTableView SORTING(Posting Date) ORDER(Ascending))
then report run correctly but I want posting date in sorting but how ?? please help me sir

geordie

Running the table RG 23 A Part I and using that key is working fine?

sachin421

Thank for your feedback sir,
Problem has been resolved ???