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.

image

The Manage Crystal Report view appears.

Blog3002image     

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.

Blog3005

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

The Crystal Report Properties view now appears.

Blog3007

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.

Blog3011

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

Blog3012

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
   Preserving Custom Roles, Secured Actions, and Assignments in Infor CRM (formerly Saleslogix) Upgrades
When upgrading between levels of Infor CRM one of the tasks that is commonly needed is to run a batch/exe
Posted on Dec 16, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Easily Showing and Hiding Tabs at Runtime in Infor CRM (Saleslogix)
Showing and hiding tabs in the Infor CRM (Saleslogix) client should be an easy thing. It should be someth
Posted on Dec 16, 2014 by Ryan Farley to Ryan Farley's Blog
 
   Checking Infor CRM (Saleslogix) Picklists for valid data
This week I received a question about a particular picklist. One of the picklist items, when chosen, wou
Posted on Dec 05, 2014 by Dale Richter to Infor CRM Questions & Answers
 
   InforCRM (formerly SalesLogix) Web Issues with McAfee VSE 8.8 Patch 4
We have see an issue with SalesLogix v8.0 and v8.1 web clients where randomly all users are bounced due t
Posted on Dec 05, 2014 by Mark Duthoy to SalesLogix Support
 
   Avoiding the Dirty Data Message When Programatically Redirecting to a Record in Infor CRM (Saleslogix)
In my last post I wrote about using the OnClientClick property of a control (or button) to run JavaScript
Posted on Dec 02, 2014 by Ryan Farley to Ryan Farley's Blog
 
Comments

 

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

(required)  
(optional)
(required)  
Add
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