Hi Margaret

 

I have written a view and related Crystal report that seems to work for me in getting all expected appraisers/valuers linked to an object. This can be run from the Objects module. You or your system admin people will need to execute this view in SQL (if you can’t do this let me know and I can try to build the report using just existing tables/ views). Are you able to add a Crystal report to TMS?

 

I have run this report against a record selection, for instance an object package, and I have put in parameters where you need to select the appraiser name and valuation purpose from the drop down list.  Let me know if this doesn’t get the data you were expecting.

 

Kind regards, Sally

 

 

Sally Fletcher

Senior Registrar

Australian National Maritime Museum

2 Murray Street

Darling Harbour

www.anmm.gov.au

 

GPO Box 5131

Sydney NSW 2001 Australia

Phone +61 2 9298 3726

Mobile 0418 438 273

 

 

 

 

 

Hi all,

 

I wrote last week having problems getting the Object Value query to work in the Objects Module to identify linked appraisers.

 

I tried the various work-arounds suggested (adding the Constituent ID, Last Name, Institution categories) to the Object Value search in DB Config  and still nothing. I’ve also tried clearing out the whole Object Value search and re-establishing it.  I get the same error message (“The multi-part identifier can’t be bound”) with all search variations  I try under Object Value (and I’ve tried a LOT) so it seems something is wrong with that query structure within our version of TMS. 

 

Back to tech support! And thanks all for your ideas.

 

Margaret Bullock

 

 

 

Margaret Bullock | TACOMA ART MUSEUM

Curator of Collections and Special Exhibitions

 

T: 253.272.4258 x3019

1701 Pacific Avenue, Tacoma, Washington 98402

www.TacomaArtMuseum.org

 

 

THE SECRET IS OUT / AND YOU’RE INVITED

HIDE/SEEK: Difference and Desire in American Portraiture

March 17–June 10, 2012

 

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.