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
   Mobile 3.0.3 for Saleslogix v7.5.4, v8.0.0 & v8.1.0 is now available!
Saleslogix Mobile v3.0.3 is now available in the customer portals. This update addresses all issues int
Posted on Apr 14, 2014 by Scott Weber to SalesLogix Product Blog
 
   Editing Filters in Saleslogix Web Client 8.0
Is it possible to add or remove Saleslogix filters from the List view in Accounts?
Posted on Apr 08, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
   Creating a Unique Saleslogix table ID in a SQL Function
A couple of months ago Ryan Farley wrote an article about how to use a SQL stored procedure to create a S
Posted on Mar 25, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix Integration with Google - WOW!
Saleslogix will be releasing their Google Integration this month and from what I have seen, it is fantast
Posted on Mar 18, 2014 by Scott Weber to SalesLogix Product Blog
 
   Global Joins in the Saleslogix Web Client
Question: How can I make a Global Join stick in the Saleslogix Web Client? Currently, when I create a
Posted on Mar 07, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
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