Wow! So cool! Thanks, Chad! Thanks! *Fatima Mahdi* Collections Information Specialist/TMS [image: VMFA-web-sig] *Virginia Museum of Fine Arts*200 N. Boulevard <https://maps.google.com/?q=200+N.+Boulevard++%0D%0A+Richmond,+VA+23220&entry=gmail&source=g> Richmond, VA 23220 <https://maps.google.com/?q=200+N.+Boulevard++%0D%0A+Richmond,+VA+23220&entry=gmail&source=g> -4007 T 804.340.1443 <(804)%20340-1443> [log in to unmask] On Thu, Mar 29, 2018 at 4:30 PM, Chad Petrovay <[log in to unmask]> wrote: > 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]> > 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 <(215)%20684-7283> >> f 215-235-0035 <(215)%20235-0035> >> >> >> *Philadelphia Museum of Art *PO Box 7646, Philadelphia, PA 19101-7646 >> www.philamuseum.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. >> > > 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. > -- *Fatima Mahdi*Collections Information Specialist/TMS *Virginia Museum of Fine Arts *200 N. Boulevard Richmond, VA 23220-4007 T 804.340.1443 [log in to unmask] 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.