Input string was not in a correct format

• davef 22400

  SSC-Addicted

  Points: 469

  More actions

  January 6, 2011 at 11:07 am

  #243238

  An error occured during local report processing

  The Hidden expression for the tablix 'table4 contains an error: Input string was not in correct format

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  January 6, 2011 at 12:08 pm

  #1270269

  What is the hidden expression for table4 and what is the data being fed to that expression?

• davef 22400

  SSC-Addicted

  Points: 469

  More actions

  January 6, 2011 at 12:16 pm

  #1270277

  <TablixMembers>

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!agencystreet2.Value > " " or Fields!agencystreet3.Value > " ",False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember />

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!agencystreet2.Value > " ",True,False)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!offender_type_lkp_id.Value = 3 or Fields!offender_type_lkp_id.Value = 4 or Fields!offender_type_lkp_id.Value = 7 or Fields!offender_type_lkp_id.Value = 8,False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!offender_type_lkp_id.Value = 1,False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember>

  <Visibility>

  <Hidden>=IIF((Fields!offender_type_lkp_id.Value = 1 or Fields!offender_type_lkp_id.Value = 3 or Fields!offender_type_lkp_id.Value = 7) and (Fields!TYPE.Value = 4 or Fields!TYPE.Value = 5),False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!offender_type_lkp_id.Value = 1 or Fields!offender_type_lkp_id.Value = 3 or Fields!offender_type_lkp_id.Value = 7,True,False)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember>

  <Visibility>

  <Hidden>=IIF((Fields!offender_type_lkp_id.Value = 1 or Fields!offender_type_lkp_id.Value = 3 or Fields!offender_type_lkp_id.Value = 7) and (Fields!TYPE.Value = 1 or Fields!TYPE.Value = 2),False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember>

  <Visibility>

  <Hidden>=IIF(Fields!addresslabel.Value <> "Address:"

  AND Fields!street2.Value > " ",False,True)</Hidden>

  </Visibility>

  </TablixMember>

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  <TablixMember />

  </TablixMembers>

  <DataElementName>Detail_Collection</DataElementName>

  <DataElementOutput>Output</DataElementOutput>

  <KeepTogether>true</KeepTogether>

  </TablixMember>

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  January 6, 2011 at 2:35 pm

  #1270341

  The first thing I notice is your IIF statements. It may be a style issue, but I have always nested them. (I think I tried it with AND or OR and I couldn't get it to work)

  IIF(Fields!agencystreet2.Value > " " or Fields!agencystreet3.Value > " ",False,True)

  would be

  IIF(Fields!agencystreet2.Value > " ",False,IIF(Fields!agencystreet3.Value > " ",False,True))

  Past that you have to look at your data, data types and see if you can figure out which expression is failing. Perhaps disable the expressions one at a time to help narrow it down.