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
   How do I fix a corrupt Picklist in Infor CRM version 8.1?
I had a user ask how to fix a corrupt picklist. The picklist did not show any values when trying to e
Posted on Feb 06, 2015 by Dale Richter to Infor CRM Questions & Answers
   Creating a Searchable & Filterable ComboBox in Infor CRM (Saleslogix) Web Client
I've had a few posts lately covering the ComboBox control in the Infor CRM (Saleslogix) Web Client. T
Posted on Feb 05, 2015 by Ryan Farley to Ryan Farley's Blog
   Limiting the Height of the Infor CRM (Saleslogix) ComboBox Popup
In my last post, I discussed how the Infor CRM (Saleslogix) ComboBox is a Dijit Select form widget. This
Posted on Jan 29, 2015 by Ryan Farley to Ryan Farley's Blog
   How to Disable the ComboBox Control in the Infor CRM (Saleslogix) Web Client
There's a problem with the ComboBox control in the Infor CRM (Saleslogix) Web Client. It won't di
Posted on Jan 22, 2015 by Ryan Farley to Ryan Farley's Blog
   Problems running Crystal Reports in the Infor CRM (formerly Saleslogix) LAN client
We recently had a client that was using the Crystal RDC object in VBScript within the LAN client to run a
Posted on Jan 20, 2015 by Kris Halsrud to Kris Halsrud'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