Hello,
I wonder if someone can point me in the right direction.
I have built a report which details proposal information by proposal.
Each proposal could have a number of different marketing activity amounts associated with it. I have therefore totalled these amounts in a different report and entered this as subreport in my main proposal report.
This works fine and if there is no marketing activity amounts, no data is shown.
My problem is that I would like to total these marketing amounts in the footer.
I believe I understand what the cause of my problems are. Against each proposal line the marketing amounts are entered, but if there are no marketing entries, there simply would not be any marketing records and not even a zero so the footer will not total correctly.
I have tried:
• Creating another box with a Iff statement trying to create a zero where there is a blank
• Trying to refer to the subreport in the Sum statement in the footer
• A null iff statement
Looking through posts I then thought HasData would be the option. =IIf(rptMarkSumAmt.Report.HasData=True,[ rptMarkSumAmt].Report![Sum Of MarkAmount],0)
But I receive along with others ‘#Error’.
Am I on the right lines here or am I missing something completely.
Your guidance would be appreciated.
Thank you.
I wonder if someone can point me in the right direction.
I have built a report which details proposal information by proposal.
Each proposal could have a number of different marketing activity amounts associated with it. I have therefore totalled these amounts in a different report and entered this as subreport in my main proposal report.
This works fine and if there is no marketing activity amounts, no data is shown.
My problem is that I would like to total these marketing amounts in the footer.
I believe I understand what the cause of my problems are. Against each proposal line the marketing amounts are entered, but if there are no marketing entries, there simply would not be any marketing records and not even a zero so the footer will not total correctly.
I have tried:
• Creating another box with a Iff statement trying to create a zero where there is a blank
• Trying to refer to the subreport in the Sum statement in the footer
• A null iff statement
Looking through posts I then thought HasData would be the option. =IIf(rptMarkSumAmt.Report.HasData=True,[ rptMarkSumAmt].Report![Sum Of MarkAmount],0)
But I receive along with others ‘#Error’.
Am I on the right lines here or am I missing something completely.
Your guidance would be appreciated.
Thank you.
