Hi TMS Users, I have a puzzling parameter scenario that maybe one of you has figured out.

I have an Exhibitions Venue report. I want the user to select the Venue for which to view information about at runtime. However, I don't want the user to have to choose a Venue name from the thousands of Constituent names in our database. I want ONLY the venues associated with said exhibition to appear. What's even pickier is that I don't want the user to have to choose the Exhibition Title from a list of thousands of Exhibitions in our database).

I know TMS passes the ExhibitionID to the report at runtime (i.e. the option to run against "current record" or "current selection"). Has anyone been able to pass that same ExhibitionID to a Crystal parameter to help filter data even further?

Let me know if you have any experience with this! Thanks, Kate


Kate Blanch
Administrator, Museum Databases
[log in to unmask]<mailto:[log in to unmask]> / 410.547.9000 ext. 266

The Walters Art Museum
600 N. Charles Street, Baltimore MD 21201
www.thewalters.org<http://www.thewalters.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.