Community Forums
Results 1 to 3 of 3

Thread: Report Center - sorting results by WF #

  1. #1
    Join Date
    Mar 2013
    Posts
    9

    Report Center - sorting results by WF #

    We created a custom report in WFM. One of the fields returned is the Workflow number, which is formatted like WF 1, WF 2, WF 3, etc. When I sort by that column, WFM doesn't seem to be handling it right. If I sort by Workflow Number smallest to highest, It thinks that WF 101 is is smaller than WF 2! Is there any way to correct this??

  2. #2
    Join Date
    Oct 2007
    Location
    Schaumburg, IL
    Posts
    321
    Hi,

    The issue occurs as the field is treated as a string. And so WF 101 is less than WF 2. If it is a custom sql report, then you can possibly make the change in the sql to get the report you want.

    Thanks!
    Alpesh
    Flexera Software Technical Support

  3. #3
    Join Date
    Mar 2013
    Posts
    9
    Thanks Alpesh! Any thoughts on my other question below?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •