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
f 215-235-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.