my Major problem was the fields where string and not integer and had many corrupt data in them... so First I followed Ibass recommendation and was able to create an array of numbers however they where in Alphabetical order and not sorted by value.
This lead me to do a sql sub-report following...
I already have a massive sql generating all other data on the report. I was hoping to use the fields and sort them out in CR formula, then take the sorted fields (or parameters) and put them all in one detailed section and suppress which ever is empty.
kind of...
Define parameters... (and I am...
I uploaded the records as an excel sheet for demonstration.
thank youhttp://files.engineering.com/getfile.aspx?folder=8182ebe2-bbf9-4291-b64b-fd26900f6c6a&file=sorting_sample.xlsx
I have in ONE record with several UserDefined fields - UDF (5+5 in total) like so.
UDF1 = 40 (UDF1a = $1.9)
UDF2 = 32 (UDF2a = $2.1)
UDF3 = 90 (UDF3a = $1.6)
UDF4 = 54 (UDF4a = $1.8)
UDF5 = 87 (UDF5a = $1.3)
I would like to sort them in ascending order keeping the fact they come...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.