Getting this error Input string was not in a correct format

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  June 9, 2011 at 2:48 pm

  #251688

  i have four tables with four dataset : dataset1, dataset2, dataset3, dataset4

  this expression is present in the table with dataset 4 besides the field ID.

  =First(Fields!VIEWERURL.Value, "DataSet3") + "?userName=" +First(Fields!USERVALUE.Value, "DataSet1") + "&orgid=" + First(Fields!ORGID.Value, "DataSet2")+ "&ID=" + Fields!_ID.Value

  it works till here but once i add the ID field it gives the error

  =First(Fields!VIEWERURL.Value, "DataSet3") + "?userName=" +First(Fields!USERVALUE.Value, "DataSet1") + "&orgid=" + First(Fields!ORGID.Value, "DataSet2")+ "&ID="

  Any suggestion

• chuck-803874

  SSC Veteran

  Points: 249

  More actions

  June 14, 2011 at 1:24 pm

  #1338627

  Try: ="ID= " & Fields!Id.Value