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] / 410.547.9000 ext. 266
The Walters Art Museum
600 N. Charles Street, Baltimore MD 21201