Awesome report, Chad, thanks for sharing!
David Thompson
TMS Administrator
The Museum of Fine Arts, Houston
PO Box 6826 | Houston, Texas 77265-6826
5100 Montrose Boulevard | Houston, Texas 77006
713.639.7580 o
281.330.3803 m
[log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Thursday, March 29, 2018 3:30 PM
To: [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] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
