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

600 Museum Way
Bentonville, AR 72712
479.418.5710 (direct)
479.418.5700 (main)
CrystalBridges.org

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.