hexagon logo
Register Sign in
  • Replies 14 replies
  • Subscribers 30 subscribers
  • Views 228 views
  • Users 0 members are here
Options
Related

Reports Sorting Reference ID

Jill Tryba
Hi I have research on line and in the forum, but I cannot find any references on how to sort by Ref_ID in order. When running a report for easier viewing without exporting to excel first. PCDMIS Reports puts everything in machine order. Can the sortup command be used in the label code below.

= ID +If(Len(REF_ID:1)>0,("-" + STR(REF_ID:1))," ")+ If(Len(REF_ID:2)>0 AND REF_ID:1<>REF_ID:2,
(" " + LOADSTR(-247)+" " +STR(REF_ID:2)),"")+ If(Len(REF_ID:3)>0 AND REF_ID:2<>REF_ID:3 AND REF_ID:3<>LOADSTR(-492),("( " +STR(REF_ID:3)+")"),"")+SUMMARY_TBLHDR

I would greatly appreciate any help

JT
Parents
  • On the other hand, just have all of your dimensions in ascending order at the end of the program. Another, method is to export to excel and sort the results in ascending order. I find it easier for excel to sort the dimensions ID balloons numbers using this type of format. Example: Balloon numbers 1 thru 10 use 01_01 thru 10_01. Example: Balloon numbers 1 thru 100 use 001_01 thru 100_01
Reply
  • On the other hand, just have all of your dimensions in ascending order at the end of the program. Another, method is to export to excel and sort the results in ascending order. I find it easier for excel to sort the dimensions ID balloons numbers using this type of format. Example: Balloon numbers 1 thru 10 use 01_01 thru 10_01. Example: Balloon numbers 1 thru 100 use 001_01 thru 100_01
Children
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement