Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

REPORT: Undefined function in expression

I have a report that I am trying to total the number of Open claims and Closed claims.  In the detail section of my report I have a combobox called cboClaimStatus.  The combobox has two columns 1. ID and 2. claim status (Open or Closed).  In a footer I have a textbox with the following in the data source:

=Sum(IIf(cboClaimStatus.Column(1)="Open",1,0))

When the report runs I get the following error:

Undefined function 'cboClaimStatus.Column' in expression

Any suggestions??

WenyonK
FL
0
wenyonk
Asked:
wenyonk
  • 2
  • 2
1 Solution
 
shanesuebsahakarnCommented:
Try:
=Sum(IIf(Report!cboClaimStatus.Column(1)="Open",1,0))
0
 
wenyonkAuthor Commented:
I have replace the Data Source with:

=Sum(IIf(Report!cboClaimStatus.Column(1)="Open",1,0))

Still I get the following error:

Undefined function 'Report!cboClaimStatus.Column' in expression

WenyonK
FL
0
 
shanesuebsahakarnCommented:
Sorry, I forget - I don't think you can sum calculated expressions like this. Can you create a new field in your underlying query such as:
Iif([MyComboBoxField]=1,1,0)

Where MyComboBox field is the field to which your combo box is bound and 1 is the value that corresponds to "Open" ? You can then put this field as a hidden text box and sum that instead.
0
 
rknowledgeCommented:
You have a combo box contained in a report?  Why?  Can you even do that?

Not to mention that how could you even select and data to reference for the report?

Are we talking about a report?

rknowledge
0
 
wenyonkAuthor Commented:
Thank You.

WenyonK
FL
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now