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
   What is the name of the Complete an Activity Form in SalesLogix?
I am trying to customize the "Complete an Activity". However, I am unable to find it. Can someo
Posted on May 16, 2012 by SalesLogix Support to SalesLogix Questions & Answers
 
   Is it possible to do a SalesLogix Mail Merge on Lookup Results without saving them as a Group?
Is there a way to do a mail merge based on lookup results. For example, let's say I do a look up by C
Posted on May 16, 2012 by SalesLogix Support to SalesLogix Questions & Answers
 
   How does the Record Changes property work on a datagrid?
Can anyone explain why the 'record changes' property check box on a datagrid (in my case Opportun
Posted on May 14, 2012 by SalesLogix Support to SalesLogix Questions & Answers
 
   How can I create seperate icons that can be used depending on which remote office they are at? Are there specific parameters that I can use in the Shortcut?
I have users that travel between offices that are running SalesLogix remote office and would like to crea
Posted on May 14, 2012 by SalesLogix Support to SalesLogix Questions & Answers
 
   What is wrong with my sql Statement?
When I try to execute the following sql in script i get the error failed to parse sql. However, if i r
Posted on May 11, 2012 by SalesLogix Support to SalesLogix Questions & Answers
 
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 © 2012 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