Login / Register  search  syndication  about

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

Changing the SalesLogix Sales Dashboard- Default number of rows returned

The SalesLogix Sales Dashboard by default typically returns the top 5 value metrics for the various standard screens.  I have received a couple questions if this can be changed to default more or less rows.  The answer is yes!  I plan to post a series of detailed posts explaining how the dashboard works.  For the purpose of changing the default number of rows that display you just need to know most of the code that defines how the interface is presented exists in one of two included scripts.

The first script "Content Set Support" handles building the GUI for all of the standard dashboard screens except for the Key Performance Indicators tab.  For that tab, the "KPI Support" script is used.  For the KPI screen there is no default number of rows displayed, it simply shows all of the KPIs that are defined.

For all of the other screens the "Content Set Support" script handles the behavior of the screens and their associated drill-down screens.  If you open the script in Architect you can look for the Private sub-routine for the Content Set class called "Class_initialize" that starts around line 294 in the base script.  If you look at the variable declarations at the start of this sub-routine you will see one on line 306 called mMaxRows.  You will see it is looks like this:

mMaxRows = 5

Changing the integer value that this variable is being set to can determine the default number of rows that appear when any of the dashboard screens open.

mMaxRows = 7 'this would show 7 rows instead of the default 5

Now this is just the default value that is used.  Each screen itself may also have there own defined number of rows that are set.  The details of this is not stored within the Form plugin but rather in the XML files used by each screen.  For instance, if you look at the Open Opportunities screen in the Sales Dashboard you will see it shows the top 5 entries for the data selected, regardless of what was placed in the "Content Set Support" script.  That is because within the "Content Set Support" script there is a private sub-routine called InitialXML that will read the screen's associated XML file and use an attribute in the XML file called "SMaxRows" or "LMaxRows". 

If mMode = cMODE_DASHBOARD Then
    mMaxRows = objContentSetsNodes.Item(0).selectSingleNode("//ContentSet/SMaxRows").Text 'DNL
    mUseFilters = False
Else
    mMaxRows = objContentSetsNodes.Item(0).selectSingleNode("//ContentSet/LMaxRows").Text 'DNL
    mUseFilters = True
End If

The "SMaxRows" attribute is used for the primary dashboard screen contents.  The "LMaxRows" is the attribute used in the drill-down screen off the main screen.  You could for instance set the first screen to default to 7 and the drill down to default to return 10 rows. 

If we look at the XML for the Open Opportunities screen (This is a Text plugin type) we can see towards the top of the XML there is a ContentSet attribute called SMaxRows and LMaxRows.

<?xml version="1.0" ?>
<!--
    Configuration file for Content Sets.
    Copyright 2006, Sage Software

-->
<Dashboard version="1">
        <ContentSets>
                <ContentSet Type="SUMMARY">
                        <Name>Open Opportunities</Name>
                        <BaseTable>Opportunity</BaseTable>
                        <SMaxRows>5</SMaxRows>
                        <LMaxRows>5</LMaxRows>
                        <CalculateOtherRow>T</CalculateOtherRow>
                        <Drill>
                        ...

Changing the values of these attributes will change the default number of rows for any screens that utilizes this particular XML file for its data source.

What's This?
Bookmark and Share

About Kris Halsrud

   Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.


Related Content
   Looking at Stonefield Query for Sage SalesLogix (Part 5)
Sorry for the long absence, I went away on some training with the Minnesota National Guard.  This is
Posted on Sep 01, 2010 by George Jensen to George Jensen's Blog
 
   Picklist Column types - Dispaying ticket status in the SalesLogix LAN datagrid
I recently had to build a datagrid displaying ticket information, including the current Status value. Un
Posted on Aug 24, 2010 by Jason Buss to Jason Buss' Blog
 
   SalesLogix Cloud- Administration Options- Using Roles
In this webinar the user will learn to manage roles in the SalesLogix Web Client. These options are onl
Posted on Aug 20, 2010 by Dale Richter to Free SalesLogix Training
 
   SalesLogix 7.5 SP3 Web – The new dashboard interface a brief overview
 One of the really, really, really, really cool new things (did I mention it is cool) that the forth
Posted on Aug 17, 2010 by Kris Halsrud to Kris Halsrud's Blog
 
   SalesLogix 7.5.2 Speed Issues - How To Find the Slowdown
At times I have been asked how can I increase the performance of SalesLogix. For systems using SQL2005
Posted on Aug 13, 2010 by Mark Duthoy to SalesLogix Support
 
Comments

 

Mike Spragg said:

Hi Kris, thanks for this - although, I've never found that the mMaxRows has any effect - and normally just change the select statement instead (within same script) - you then don't need to modify the individual XML sets !

February 16, 2009 5:17 PM
 

Richard Eggleton said:

Thanks Kris, Nice Article, illustrates issue clearly; Mike's comment valid too.

September 2, 2009 10:42 PM
 

Harold said:

Thanks Mike, I found the same thing.  I changed the value in the Select statement and it worked.

Also, for those that are novices like myself, the select statement is around line 1843

strSelect = "SELECT DISTINCT TOP " & mMaxRows & " "

Change mMaxRows to a static number.

April 26, 2010 12:58 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2010 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