Login / Register  search  syndication  about

          George Jensen's Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Adding Reports in Sage SalesLogix

As stated in my first post to this blog, I am writing to the new Sage SalesLogix (SLX) user who wants to learn more about reporting against their database.  This post will focus on adding your new report into SLX for centralized use.

You have created your report in Crystal, shown it to your boss who flipped over its content and now he has asked you to make this report available to all users.  SLX provides a home for those important reports and provides you the ability to filter down by Group, User and Dates.

What do you need:

  1. Access to the SLX Architect
  2. The main table for your report.
  3. The UserId and Date fields from the main table that you want to use with the standard SLX filters.

First, enter into the Architect, find the Manage menu item and select "Reports.." from the list.


The Manage Crystal Report view appears.


The navigation tree list all of the families of reports available in SLX.  Find and highlight the family for your report, my example the report I am installing is an Account Detail report so I am chosing the Accont family. 

Next, select the New Report Icon Blog3003 located on the upper left hand corner. 

The Select Crystal Report view appears.


Navigate to where your report is currently stored, highlight your report and select the "Open" button. 

The Crystal Report Properties view now appears.


Ensure the the Report Family field is filled in correctly. 

In the Report Name field, name your report the way you want it to display in a list.  This setting will appear in the navigation tree in the SLX Architect and the reports list in the client.

In the Main Table field, select the main table for the report from the drop down list. This table should contain the UserID or the Date you wish to filter by in the SLX environment. 

To use the group selection criteria in your filtering ensure the "Show Group Filter" check box is checked.

Select your UserId field from the "Master User Field" drop down list. The list is populated by the selection in the "Main Table" field.  Know that populating this field is not a requirement, the report will work with or without this populated.  But if you want to use a UserID field as a filtering criteria within the SLX environment you must ensure a UserID field is chosen and the "Show User Filter" is checked.  The same rules apply for the Master Date field.

On the selection of OK, the Crystal Report Properties view closes and the report displays in the Manage Crystal Reports list under the family of Account.


To release the report, select the "Manage Release" tool bar icon. 


Here you have the ability to release to an individual User, to specifc Departments and/or Teams, and of course "Everyone".  Make your release selection and select OK.  On the return to the Manage Crystal Reports view, select OK and exit Architect.  Open the SLX client and navigate to the Reports area to find your report ready to use.

I am off for the next two weeks serving in the National Guard.  Future post will focus on how to set up your report data using the Add Command.  Some other tricky topics we have run into are formatting SLX phone numbers and then displaying addresses. After that I thought we could start digging into Sage SalesLogix Visual Analyzer.   I recently became Developer certified through Sage on this outstanding tool and have started playing around with different common scenarios. 
What's This?
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.

Related Content
   Can I Bind an Attachment to a Specific Activity in Infor CRM version 7.54?
Recently I had a user ask if they could bind an attachment to a specific Activity within Infor CRM??
Posted on Jul 07, 2015 by Dale Richter to Infor CRM Questions & Answers
   Infor CRM (formerly SalesLogix) Administrator Locked Out
I thought I had seen all the issues affecting the datalink but this was a new one. We could not login t
Posted on Jun 18, 2015 by Mark Duthoy to SalesLogix Support
   How do I remove users from my Infor CRM system (formerly SalesLogix)?
I had an Administrator ask me for the steps they needed to take in order to remove a user from the Infor
Posted on May 08, 2015 by Dale Richter to Infor CRM Questions & Answers
   Infor CRM (Formerly Saleslogix) v8.1 update 03 and 05- Uncaught Error Scheduling Contact Processes
 In the Infor CRM (formerly Saleslogix) web client, under the Contact area you have the ability to s
Posted on May 07, 2015 by Kris Halsrud to Kris Halsrud's Blog
   Problem Showing All Area, Category, and Issue Values in Infor CRM (Saleslogix) Mobile And How to Fix
There is an issue with the Infor CRM (Saleslogix) Mobile client where, if you have a large list of Area,
Posted on Apr 24, 2015 by Ryan Farley to Ryan Farley's Blog


David Tinjum said:

Great article.  Looking forward to learning about Visual Analyzer.

June 5, 2008 7:56 AM

The Reporting Blog said:

Today we are looking at the seven standard reports of the Account level in Sage SalesLogix (SLX). For

March 19, 2009 3:04 PM

derek said:

thank you very much for this useful information

June 9, 2010 4:20 AM

Leave a Comment

All contents Copyright © 2015 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register