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
   How do you add a parameter for File Attachment Size and Timeout in Saleslogix 8.1?
Question: Is it possible to set a parameter for file attachment size and timeout in Salelogix? If
Posted on Aug 07, 2014 by Dale Richter to SalesLogix Questions & Answers
 
   Fixing Duplicate Saleslogix FieldIndex Values in the SECTABLEDEFS
I had to fix a client's SECTABLEDEFS table that contained duplicate FieldIndex values.  FieldInd
Posted on Aug 07, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix XBar Installation
When installing the new XBar application I found the instructions a little vague so I thought I would pas
Posted on Jul 18, 2014 by Mark Duthoy to SalesLogix Support
 
   Using an Array - SQL vs Crystal.
In data, an Array is used to store multiple values in a single variable.  I often use Arrays to qual
Posted on Jul 17, 2014 by George Jensen to George Jensen's Blog
 
   "Saleslogix’s affordable pricing and usability allow the product to rise above competitors in the space" - Info-Tech Research Group, Inc.
"SalesLogix’s affordable pricing and usability allow the product to rise above competitors in the sp
Posted on Jul 14, 2014 by Scott Weber to SalesLogix Product Blog
 
Comments

 

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

(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