InterAction SSRS Reports Q&A

John Leininger, Senior Technical Consultant, LexisNexis:

Starting in October 2017, LexisNexis began supplementing InterAction’s out-of-the-box reports with a new collection of specialized reports created with SQL Server Reporting Services.  This article discusses some of the questions that have been posed by our customers. 

 

  1. The collection of SSRS reports that are available on the InterAction support site are compiled inside the new installation application. Is it possible to get a copy of the SSRS report definition files (*.rdl) for the reports?

Yes, the Technical Support team can provide a zip file containing the RDL files.

 

  1. Are there recommendations for limitations in the number of contacts that we should include in these reports?

Some reports may require limitations due to the amount of data that is returned.  A good practice is to run the report for one contact to see how long it takes before running it for a large collection of contacts.  Another variable is filtering.  Reducing the date range for those reports that include date filters can help speed processing time.

 

  1. Report: Contact Knows Relationships – How is the drop-down list populated for the InterAction users since it appears to be random?

This list includes Our Personnel who have at least one Knows relationship.

 

  1. Report: Firm Contacts Added – Some of the InterAction users that have been chosen are not appearing on the report.

Users will not appear on the report if there have been no firm contacts added in the time frame that has been chosen to include in the report.

 

  1. Report: Folder Access Rights – Is it possible to run this report on a specific folder type?

There are two choices: You can run it for one folder or for all folders.

 

  1. Is it possible to schedule a session for someone to assist me in downloading the latest release of the SSRS reports?

Setting up SSRS is out of the IA Support Team’s scope of support. This is because most of the steps to set these up are done in SQL.  As of this writing, the link to the latest download page for the SSRS Reports is…

https://lexisnexis.custhelp.com/app/answers/answer_view/a_id/1100401

Take note of the requirements for this update in the ‘Requirements’ section. Also, in the ‘Installation Instructions and Notes’ section, you will find a link to the updated Installation guide. More information about SSRS Reports can be found starting on page 104 of the Installation guide.

Once the reports have been installed and configured through the instructions in the Installation guide, the support team can troubleshoot should there be issues with it. There is no need to schedule a session in case there is a need to troubleshoot since you can call us at your most convenient time during our support hours (7:00 AM to 7:00 PM Eastern time).

If you need assistance with installing this, you can reach out to your Account manager or to LexisNexis Consulting Services who can provide fee-based services. Here is the link to that information on the website:

https://lexisnexis.custhelp.com/app/answers/answer_view/a_id/1085476

 

  1. We've recently downloaded the SSRS reports but are having problems with the Folder Access Rights report. We don't seem to have a “Folder Access Rights Report” group so we can't run this report.

It is necessary to create a group in the Administrator program called “Folder Access Rights Report” and add the users to that group that you would like to be able to run this report.  Note: It is also necessary to add the InterAction Administrator to the group if you want that user to be able to run this report. After adding the group, be sure to close the Windows client and reopen it for this change to take effect.

 

  1. Question concerning the SSRS reports that were introduced in Nov 2018 (Release 18R3 SSRS), and the new program called “SSRS Report Publisher” that can be used to add these reports to the SSRS Reports Server… If we have already been using a previous version, should we republish and overwrite the existing reports when we publish the new ones?

Yes, you should always install all the reports and overwrite the existing ones since there have been some updates to legacy reports.

 

  1. Question concerning the SSRS reports that were introduced in Nov 2018 (Release 18R3 SSRS), and the new program called “SSRS Report Publisher” that can be used to add these reports to the SSRS Reports Server… We would like to see the SSRS reports right away and see that the first steps involve setting up some additional processes for the audit information.  If we are not interested in viewing the audit reports at this time, can we postpone these steps?

Yes, you can postpone the steps for initializing the audit information, which incidentally may require other processes such as your synchronization processes to be temporarily delayed. This can be done at any time after the other SSRS reports have been configured.

 

  1. Can you provide more information regarding configuring the SSRS permissions that will be needed for users who need to either configure or just run the reports?

To run the SSRS reports, users must be assigned at least the “Browser” item role and the “System User” system role in the SSRS web portal.  The following steps explain how to set these minimum-access roles in SQL Server 2016.  For more information, see https://docs.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-2017

 

  • If you don’t find the information you seek here, please contact our Technical Support team contact them at +1.888.575.9830 or support@interaction.com.