We have a requirement. There are 6 different datasources which has data for different months but are not in sync. i.e. data source 1 is till march 2018 where datasource 2 is till July 2018. Therefor 6 different datasource.
In another datasource i.e. 7th one we are getting a single date and we want to limit the rest of the reports based on this single date. i.e. upto this date.
Can anyone how to achieve the same?
You can use the 7th data source date as filter and select all using related data source.