Beautiful! Thank you for sharing with the entire Listserv.
Christina Gibbs
Collections Database Manager
Detroit Institute of Arts
5200 Woodward Avenue│Detroit, MI
313.578.1051 │ [log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christine Droll
Sent: Friday, March 30, 2018 8:50 AM
To: [log in to unmask]
Subject: Re: Report of reports in use (my head hurts)
Thank you, Chad. I can use this, too!
Christine Droll
Registrar, Database & Collections
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO 64111
T: 816-751-1333
F: 816-751-0499
[log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Chad Petrovay
Sent: Thursday, March 29, 2018 3:30 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Report of reports in use (my head hurts)
This report is grouped by Context, shows each report in alphabetical order, and then has subreports to retrieve the security groups and users that have access to the report. It also has subreports to retrieve which report groups a report is in, and whether the report is also available in other contexts.
I hope that this meets your needs. ~Chad
On Thu, Mar 29, 2018 at 3:53 PM, Milby, Jessica <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hi all,
Does anyone have a way of reporting in Crystal or, preferably, querying sql to list available crystal reports by the security groups and/or users that have access to them?
I’m looking at the tables:
Reports
ReportIDs
ReportGroups
ReportGroupXrefs
and so far none of them have anything that seems an obvious key to the securities that we assign in reports maintenance.
I’m trying to make an efficient list of what we have for users to confirm what reports they still need. We’ll use these lists to prioritize updates to reports when we upgrade TMS from 2014 to 2017. My crystal expert left us a few months ago, and there is a long list of cosmetic and functional updates to existing reports as well as new report requests. The biggest concern at the moment though, is facing a system upgrade without a reporting guru.
Defining the reports in need of attention and getting them ready for the upgrade’s changes in data structure is a big hurdle.
Am I missing something obvious?
Any advice is welcome!
Thanks,
Jessica
Jessica Milby
Assistant Director for Collection Information
t 215-684-7283<tel:(215)%20684-7283>
f 215-235-0035<tel:(215)%20235-0035>
Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org<http://www.philamuseum.org>
To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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.