When adding a new option to the dynamic sorting or grouping parameter you
need to do the following three things:
1. Make sure the field is available in the report, adding the appropriate
tables and joins as required
2. Edit the parameter, to include the new option for dynamic sorting or
grouping. In canned reports, there may be 4 or 5 parameters for grouping or
sorting, each of which need to be edited.
3. Edit the sorting or grouping formulas, to equate the parameter value
with the proper field output in each of the formulas. As with the
parameters, canned reports may require editing 4 or 5 formulas.
This should give you a pretty good roadmap to follow, and if you have
mastered the "IF ... THEN... ELSE" formula in Crystal, shouldn't be that
hard to implement.
That said, you are trying to organize your report by locations. Since
objects don't have locations, but rather components have locations, just
beware that you will have repetition of object records which have multiple
components. You may want to include some optional component information
(such as name), so avoid confusion.
Coincidentally, dynamic sorting and grouping are topics that are covered in
the Crystal Reports class. This was new feature introduced as of TMS 2010.
I know that many people learned Crystal Reports prior to it's release. You
may want to consider registering for the Crystal Reports class, or
expressing your interest for a refresher/advanced training class with your
account manager.
Happy Thanksgiving! ~Chad
On Mon, Nov 25, 2013 at 5:48 PM, Jeri Moxley <[log in to unmask]> wrote:
> 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.
>
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.