Report Designer Question - How to TRIM a field

Permanently deleted user

March 27, 2013 23:20

Short of trying Voodoo I am running out of options on how to try and trim a DataField.  There is no concatenation just a field that has leading white-space.  

Any and all help is GREATLY APPRECIATED!!!!

Jeff

0

• 

  Permanently deleted user

  March 28, 2013 02:43

  Hi Jeff

  A few questions:

  • where are you trying to use this field?,
  • where is it coming from?
  • is it in a datalink?

  Regards

  Ralph

  0
• 

  Permanently deleted user

  April 05, 2013 23:30

  Ralph, sorry in the delayed response... I contacted support with Cortex and resolved the issue.  Support had me trim the attribute within WF Designer.

  I have been building a WF that selects about 20 layers and creates a multilayer report by building datasets for  7 different subreports then creating a master report to include each subreport.  One subreport has field (GEOCODE) with leading blank spaces.  After selecting all of the data using query task I build the datasets within multiple lateral tables within the one dataset.  As I am building the table I use the assign function to complete the trim.

  To (outArgument) = parcelDataTable.Rows(0)("GEOCODE")

   

  Value (InArgument) = parcelDataTable.Rows(0)("GEOCODE").ToString().Trim()

  Support advised that the trim would be eaisier to complete inside of the WF than the report.

  Cheers,  Jeff

  0
• 

  Permanently deleted user

  April 08, 2013 03:05

  Thanks for the update Jeff\

  Good to hear that it has been resolved.

  Regards

  Ralph

  0

Please sign in to leave a comment.