We just had a client ask or support team how to display one to many data (or a list) in merge forms. This is very achievable, the process is pretty straight forward and can really expand the use of your merge forms. As is the Customer FX way we want to share with the SLX user community so I […]
I wrote about this topic just prior to The Crystal Report Writing class. During the class the question was asked "What about using the Execute SQL tool in the SalesLogix Administrator for syncing out SQL views to remotes?" As a development team we have looked at this before and always found that it just did not work. But we had not tested it in quite a while so we decided to try it again, and this time it worked.
The scenario is you have created a SQL view for use in a Crystal Report. Your end users are excited about the report but then you started getting phone calls from your remote users that the report will not run. You realize that the view you used to help organize your data did not synchronize […]
One of the most common errors in developing Crystal Report in Sage SalesLogix is the failure to plan. A lot of times we just jump in without any fore thought and then spend a lot of time back tracking and making the report work after the fact. I suggest the creation of a internal scope or Blueprint document...
I reviewed the SalesLogix Work Order Crystal report on the 19th of February 2009. This report turned out to have a number of issues. Here is what I wrote about this report in my original review.Start Excerpt…………..Looking at this report you see that it is out of date with the way SalesLogix currently operates today. For example, with standard […]
In a post labeled SalesLogix Ticket Reports (Part 7) dated Feb 19th, 2009 I wrote a blog post reviewing the SalesLogix Weekly Recap Crystal Report. During the post I did not have much to write about this particular report. When I reviewed the report today I thought of one improvement that we could make. Currently this report is set up to give […]
I wrote about these two reports back on Feb 12 2009 in a Post labeled SalesLogix Ticket Reports (Part 6) , Since the entire post is being refered to I will let you follow the link to see the detail. These two reports are essentially duplicates of each other so I decided to make them one report and […]
Today we will tackle a report that is in need of a little updating, we will provide it a new look and fix some minor issues. The report was originally blogged about back on Februaray 11th 2009. Here is the link to see the entire post. Start Excerpt …………The “Support Ticket Status By Assigned”. The report uses […]
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 […]
Real easy quick post today. The Problem Analysis – By Area report was already fixed during the initial review. Read “Updating Sage SalesLogix Problem Analysis Crystal Report” to read the review. Mostly what I did to update this report is shrink the Cross Tab fields to a size that allowed 31 one days of data to display on […]
All I wanted to do is fix the layout of this simple little report, but as I prepared for this post I noticed that the report was not totaling correctly. This was caused by not accounting for the records where an Area was selected but not a Category or an Issue. This will make updating this report a little more complicated but it will be fun all the same.
Today we will get back to fixing, adjusting or improving the standard Crystal Reports that come with an implementation of Sage SalesLogix. I originally commented about this report on January 29th, 2009 in a post labeled SalesLogix Ticket Reports (Part 2) Start Excerpt……………Now let’s review the SalesLogix Support Follow-up – Sample report. The report allows you […]
I was working with a client yesterday on the standard Sage SalesLogix Opportunity Detail Crystal Report and we came upon a issue that was not addressed in my review or in my attempt to improve the report. The issue – if you have multiple History records, all from one day, you only see the first […]
Were are working with the Ticket Level Reports that I wrote about in a post labeled SalesLogix Ticket Reports (Part 2) on January 29th, 2009. This is what I wrote concerning this report. Start Excerpt……Taking a look at the Support Escalated Tickets report first. When I ran the report there were no additional parameters and it provides the Ticket level […]
I wrote about these two reports back in a post labeled SalesLogix Ticket Reports (Part 2) written on January 29, 2009. Follow this link to read the original post. I looked at the updated version of the reports and still agree that these reports are very well written. The idea came to me that one way of […]
Today we are going to look at the SalesLogix Support Call Turn Around Crystal Report. I wrote about this report on January 27th 2009 in a post labeled SalesLogix Ticket Reports (Part 1). This is what was written about the report. Start Excerpt…………….Now lets look at the Support Call Turn Around report. The purpose of this […]
Today we will take a look at our first Ticket Level report. In the SalesLogix Billable Ticket Crystal Report there is very little to fix but I think the comments about modifying the report are still accurate. The post that I reviewed this report in was written on January 27th 2009 and was labeled SalesLogix Ticket Reports (Part 1). This is […]
In the post dated 13th of January 2009 labeled SalesLogix Opportunity Reports (Part 2) and because of a second review of the Quota Vs Actual Sales Crystal report, I believe that this report is in great shape. I started down the trail of fixing the Sales Process Stage Analysis but after working a few items in the report […]
As I reviewed this report in the blog post labeled SalesLogix Opportunity Reports (Part 2), I noted that there was really nothing to do and I almost skipped working this report. I decided to take another look using the 7.5.1 version of SalesLogix to see if the Sage had done anything to improve the report. I found the […]
So we have about 20 reports left to update as move onto the SalesLogix Opportunity Summary Crystal Report. I reviewed this report in SalesLogix Opportunity Reports (Part 2) dated January 13th of 2009. This is what I wrote about todays report. Start Excerpt………………The Opportunity Summary report is a simple little report that provides basic Opportunity information. But this [&...