Login / Register  search  syndication  about

          George Jensen's Blog

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

Improving the SalesLogix Ticket Knowledge Base Crystal Report

The SalesLogix Support Ticket Knowledge Base Crystal Report is a very straight forward and well built document.  On this my second review of the document I almost left it as is but I came up with a couple of things that might make the report a little better.  Here is the initial review.

Start Excerpt .......... 

The Support Ticket Report provides all of the top level Ticket information.  The report is written very well, I could not find anything wrong from the development side of things.  Some things you could do would be to include Ticket History and Ticket Activity Summaries but this report is operating very well as is.

End Excerpt .......

I will add teh ticket Activites but I also thing I think I will add to the Notes Label the word "Internal"  to represent what field is actually being used.  I will also set up this section to display the words "There are no Internal Notes" instead of just displaying the empty Notes field.  Finally I will add some type of text based search criteria so an organization such as Customer FX, where we have built an extensive Knowledge base, can limit data based on key words or phrase.   I talked to Larry Halsrud our Director of Support and he liked this last idea, he said if  we extended the search to include Ticket Activities then we would really have a nice report. 

The first two items I have done many times in these blogs so today I will focus on the search criteria.  The first thing we need is a parameter field.  Name the parameter "Text", the Type will be "String", under the Value section add nothing to the list, under Value Options section I added the Prompt Text of "Enter your Search Criteria text to filter your search, or hit the space bar once to see all records. " then set the Prompt with Description only to "True", and Allow custom values to "True".

With the Parameter established I added the following to the Record Selection Formula:


Lowercase({?Text}) in LowerCase({TICKETPROBLEM.NOTES})
Lowercase({?Text}) in LowerCase({TICKETSOLUTION.NOTES})
Lowercase({?Text}) in LowerCase({TICKETACTIVITY.ACTIVITYDESC})

BEcause Larry said that many times some of the detail on how he corrected an issue was in the detail of the Ticket Activity, I  built a sub report to show the Ticket Activities for any Tickets that qualified for the report.  I then played around with the alignments and formatting, I also removed all tables to the main report except ACCOUNT, TICKET, TICKETACTIVITY, TICKETPROBLEM, and TICKETRESOLUTION. Here is a screen shot.

For Customer FX I was asked to update this report a little more.  Larry wanted to be able to search by Account, and he wanted all tickets included in the search.  So I removed {TICKET.ADDKNOWLEDGE} = "T" and Added {?Account} = {ACCOUNT.ACCOUNT} from the Record Selection formula.  And created the following parameter field.  Name the parameter "Text", the List of Values will be "Dynamic", under the Value section I searched for and found the Account field, under Value Options section I added the Prompt Text of "Enter Account Name: " then set the Prompt with Description only to "True", and Allow custom values to "False". 

Larry won't stop drooling.  This report now does something that searching the knowledge base does not, search TicketActivity Notes.

Download the updated Report here and thanks for reading.

Get all of our Free SalesLogix Reports here...

Have a great day.

What's This?
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.

Related Content
   Saleslogix Xbar update coming soon
Scheduled to be released 8/29/2014 Features in Update •Installation improvements •Enterp
Posted on Aug 21, 2014 by Scott Weber to SalesLogix Product Blog
   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 Ticket Reports (Part 5) - The Reporting Blog said:

Pingback from  SalesLogix Ticket Reports (Part 5) - The Reporting Blog

August 13, 2009 2:57 PM

Leave a Comment

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