I have a main report and sub report , where I can run the report from .NET application, so I have filters in my application. where the filter = record selection formula.

my filter is a specific date lets call is DATE_1 that I fill it in from the .NET application.

I want to store this filter and pass it to sub report and show the records in sub report that are 12 months earlier than this DATE_1.

my main question is how I can store this filter value in main report and show the 12 months earlier records in the sub report? I played a lot with linking records from main report to sub report , but still no luck.

any help is appreciated