I have created a custom screen, where against Type and State the information need to display in a report either in last page or each page footer.

When state is null, then data is empty and when I have state then I'm getting duplication my report, when it is at page footer section. If I move to groupFooter then there is no duplication.
I added this logic in SIO643000.rpx base report.
NOT NULL STATE:
SubReport:

Subreport:

FOR NULL STATE:
Sub Report:


MAIN REPORT:

Major issues:
1. When state is null- No data on my report.
2. When I have state , data is duplication(Only my sub report date) if it is located in PageFooterSection
I have tried with multiple sub reports , one report with multiple sections. Please advise.