Skip to main content
Question

Display data against State ISNULL OR NOT NULL and type of customer into REPORT.

  • November 18, 2024
  • 0 replies
  • 40 views

Forum|alt.badge.img

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.