I have a multiple tables first table is for organization.second is for mandalthird is for khandfourth is for EntryData
here i am describing my problem
Mandal can enter data in table EntryData
suppose an organization have 1 mandal and a mandal have 4 khand.
so mandal enters data for 2016-2017 financial year.
and i want to bind grid like below shown in image.
grid will be bind only for last updated or last entered data only.not for all entries of khand in a month or year.it will show only for last updated or entered data and for each khand.if there
is no data for any khand then it will show 0 and date will be N/A
Now coming to my problem.my problem is i able only in binding data for just current month.
i am unable to bind Past financial year Data.like shown in grid.
so please anyone help to achieve this.
i have already wasted more than 8 hours on this .but not succeed.thanks in advance.