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
   Video: Demystifying Infor CRM (Saleslogix) Updates
Watch it now! If you missed yesterdays demo, "Demystifying Infor CRM (Saleslogix) Updates" ,
Posted on Sep 26, 2014 by Brianna Ojard to The Inbox
   Thoughts on the Future and Involvement in the Saleslogix/Infor CRM Community
Over the last year and a half I've been working on another product named Contatta. It's a great p
Posted on Sep 25, 2014 by Ryan Farley to Ryan Farley's Blog
   Fixing the Orphaning of Salesfusion Data when Converting Leads to Contacts in Infor CRM (Saleslogix)
We have had a couple of client recently come to other with the same problem-When you convert a Lead to a
Posted on Sep 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
   Official Infor CRM Acquisition FAQ
What to expect now that Saleslogix is Infor CRM. Like many of you, it will take some time (probably a
Posted on Sep 18, 2014 by Brianna Ojard to The Inbox
   ComboFix Kills Saleslogix Sync
ComboFix, a third party malware utility, will alter the Operating system so .qts and .que files will no l
Posted on Sep 12, 2014 by Brianna Ojard to SalesLogix Support


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 © 2014 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