I have been given a task of creating a report for a table.
Preview of layout 1
field 1 = yes or No (Checkbox)
field 2 = start date( drop down calender) eg: 5/22/2017
field 3 = end date( drop down calender) eg : 5/22/2022
field 4 = all the years between start date and end date ( calculation) eg: 2017,2018,2019,2020,2021,2022
and some other fields
so the report I need should be
field 1 = dropdown of +50 and -50 years. eg: 1975-2075
so if the year selected in field 1 (in the record) matches in any year in field 4 in the previous layout then i want some other fields in the respective records.
How can I achieve this.