Login / Register  search  syndication  about

          George Jensen's Blog

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

The SalesLogix Opportunity Reports (Part 1)

There are nine Opportunity Reports that come with a standard SalesLogix implementation.  I thought we would cover only four of them today and the other five within the week.

The first is the Competitor By Opportunity Status report.  This report uses the condition filter fields of AccountManagerID and Estimated Close.  When you run the report you are presented with two parameters. The first asks what Opportunity Status do want to report against, this includes a values of All.  Warning, these parameter values are typed in so if you have custom values for Opportunity Status then you will have to update the report. The second parameter is whether you want the graph to display or not.  Some of the information provided could be confusing, the column on the left is the Competitor Name and Count is how many deals they are involved in. This report was updated, see how and download for free.

Next is the Forecast by Account Manager, this report uses the condition filter fields of AccountManagerID and Estimated Close.  When you run the report you are promoted to answer two report parameters.  

There are a couple of issues with the parameters, the first parameter asks you if you want to see the statistics for each Account, it should actually read for each User.  You will see in the screen shot that the data is User based, not Account.  Next the second parameter asks if you want to display the graph, it displays the graph with either the "Yes" or "No" selection.  This issue exists because the suppress formula is for the report footer B which contains nothing for the report. The graph is actually located in Group Header 1 and that is where the suppress formula should written to.

There are two other items that could be adjusted to make the report a little tighter.  The Est. Close Date field could be formatted to display just the date.  Also, where the Account is displayed in header of group 2, we could set that section of the report to underlay the detail section which would bring the Account name in line with the Opportunity data for that line.  See how this report was updated by following this link.  Here is the screen shot:

The Opportunity By Account uses the condition fields of Modifyuser and ModifyDate.  The data in the report seems in line with what I would expect.  I see the same issue with the Est. Close Date field and I would work the Sales Potential percent sign into the report using a formula field just to make things look a little better.   Read on how this report was updated by foloowing this link.

With the Opportunity Detail  we see the use of the AccountManagerID and ModifyDate as the condition fields.  When running the report you are provided with a number of parameters.  What is nice is that each parameter defaults to the positive answer which makes running the report faster.  

The first thing I notice when the report opened the report is written to the width of portrait but saved in landscape leaving a lot of white space on the right side. This could be adjusted by tightening up the Opportunity header information and formatting the date fields correctly then resetting the page set up.  I like the way the report holds each group together so there is no doubt what section of the report you are on.  I see some of the sub report data gets cut off on the right side.  This report can be really long so I will just show the first couple section for this one Opportunity.  This report was also updated, follow this link to see how.


 That's it for today, the list of fixes is getting longer.  I hope every one was safe over the new year holiday.  See you later this week. 

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


The Reporting Blog said:

I had the pleasure of actually talking to some of the readers of this blog over the last week. It was

May 28, 2009 4:10 PM

The Reporting Blog said:

Well I made it through two very challenging weeks of Annual Training and I am ready to restart our efforts

June 23, 2009 1:03 PM

The Reporting Blog said:

The orginal post was written using a 7.2.2 version of SalesLogix and I am happy to report that the 7.5.1 version of this report was updated fixing the date formatting issue. The percent sign for probability was also addressed by simply adding the percent

June 25, 2009 10:44 AM

The Reporting Blog said:

As we continue adjusting the Crystal report that come with a standard implementation of Sage SalesLogix

June 30, 2009 1:16 PM

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