Hi Kate,

If you're not using crates/containers or the free-text fields on the
locations data entry screen with your locations entries, I recommend adding
the Locations table to the report and adding the locationstring field to
your report's sort formula - the LocationString provides a concatenation of
the location hierarchy fields, but doesn't include the level/sublevel free
text fields or container data.

Jeri


On Mon, Nov 25, 2013 at 5:30 PM, Kate Sbarra <[log in to unmask]
> wrote:

> Hello TMS wizards,
>
>
>
> I’m currently trying to add a sort parameter option to our Inventory
> Report.  The existing report already has some sort parameters, but I want
> to be able to sort the report by Current Location.  Does anyone know how to
> add that field as a parameter value? Do I need to change the way “Location”
> is listed in Crystal Reports first?  I’d greatly appreciate your advice!
>
>
>
> Thank you,
>
> Kate
>
>
>
>
>
> *Kate Sbarra*
>
> Collections Information Specialist
>
> [image: Crystal Bridges Museum of American Art]<https://urldefense.proofpoint.com/v1/url?u=http://crystalbridges.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=87708dcf0147be4987131451f12dc8d233e3db8bfbafdac6fc4f8f091e23aaf8>
>
> 600 Museum Way
> Bentonville, AR 72712
>
> 479.418.5710 (direct)
> 479.418.5700 (main)
> CrystalBridges.org<https://urldefense.proofpoint.com/v1/url?u=http://crystalbridges.org&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=d641fda13d2f99657fce6edf635e5eb22ccca4458c02e7fb36a3445c99e2cc14>
>
> [image: Follow us on Facebook]<https://urldefense.proofpoint.com/v1/url?u=https://www.facebook.com/crystalbridgesmuseum&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=85c40b64d4fc0d05425a3f0ffd94f39162632ac0c4de45723a66709c6b15e01e>
>  [image: Follow us on Twitter]<https://urldefense.proofpoint.com/v1/url?u=https://twitter.com/crystalbridges&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=a92d28a0944393c3fd74ae56b89c717cfe91df9c7e7e65513fcf70f050320f9b>
>  [image: Follow us on Instagram]<https://urldefense.proofpoint.com/v1/url?u=http://instagram.com/crystalbridgesmuseum/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=1ea3df34bc68d179231508ae1b86e34cbfca98c45eed6d2fc4ff4979800916ea>
>  [image: Follow us on Pinterest]<https://urldefense.proofpoint.com/v1/url?u=http://pinterest.com/crystalbridges/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=0H%2F1U0AU3U6bj1Gi8XCZRNLIYqydlQaIGuSrtpP5kLA%3D%0A&s=91152985c04e5a34bca6df86276d7cfc0c5c5d34416bbd3e240d4defccc10422>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
>  You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.