Posted: 22 Mar 2018 2:17 EDT Last activity: 27 Apr 2019 16:56 EDT
Declare index join condition in Report definition disappears upon saving RD
I was trying to join on a declare index in Report, I put the join and when i try to save, the join logic disappears immediately.
Report will not save Index joins if they are not used anywhere in Select or where clause in RD. So after putting join condition in data access tab use Declare index fields in select clause or where clause of RD then click on save. It will retain ur index join condition and logic.
***Updated by moderator: Lochan to add Categories***
Sometime if you refer its properties also and add the index in data access tab it gets disappear while saving better whenever you create a declare index directly refer its properties using the index name in the report in which you want to use, then automatically it will appears in your data access tab then you can save it and it won't disappear.