George Jensen's Blog - All Comments

Crystal Reports for SalesLogix - Using Parameters

The SalesLogix Product Blog — Wed, 10 Mar 2010 22:30:36 GMT

A simple break down. A common question that we hear from SalesLogix users with Crystal Reports is how

A little more with the Side By Side Bar Graph

George Jensen's Blog — Tue, 02 Mar 2010 19:28:27 GMT

SAP Business Objects Crystal Reports (Crystal Reports) is the report writer for Sage SalesLogix (SalesLogix

Crystal Reports and Bar Graphs

Good Practices for CRM — Wed, 24 Feb 2010 22:57:37 GMT

Building a simple bar graph. Are you familiar with, or have you ever tried, building a graph with Crystal

Crystal Reports - Shading the Background Color

Good Practices for CRM — Wed, 10 Feb 2010 22:48:01 GMT

Quick and easy. Most SalesLogix users also use Crystal Reports, and if you know what you are doing there

Twitter Trackbacks for Using Crystal Reports "Next" and "Previous" Functions - George Jensen's Blog [customerfx.com] on Topsy.com

Fri, 22 Jan 2010 22:54:05 GMT

Pingback from Twitter Trackbacks for Using Crystal Reports "Next" and "Previous" Functions - George Jensen's Blog [customerfx.com] on Topsy.com

Twitter Trackbacks for Displaying when a Crystal Report Was Last Modified - George Jensen's Blog [customerfx.com] on Topsy.com

Sat, 16 Jan 2010 03:35:36 GMT

Pingback from Twitter Trackbacks for Displaying when a Crystal Report Was Last Modified - George Jensen's Blog [customerfx.com] on Topsy.com

Twitter Trackbacks for Using Functions to Look into the Future - George Jensen's Blog [customerfx.com] on Topsy.com

Thu, 14 Jan 2010 08:16:11 GMT

Pingback from Twitter Trackbacks for Using Functions to Look into the Future - George Jensen's Blog [customerfx.com] on Topsy.com

re: Fixing the SalesLogix Account Detail Crystal Report

Ted Sturr — Tue, 12 Jan 2010 15:22:41 GMT

I just downloaded and started playing with this. As David said, "Awesome post". One small thing I just found I thought I would mention to others is the formula @PhoneNumber references the formula @Telephone_Country. That formula should include Canada because they format the phone numbers the same way the US does.

Twitter Trackbacks for The DateRange Functions - George Jensen's Blog [customerfx.com] on Topsy.com

Tue, 29 Dec 2009 21:07:10 GMT

Pingback from Twitter Trackbacks for The DateRange Functions - George Jensen's Blog [customerfx.com] on Topsy.com

Twitter Trackbacks for Using Multiple Value Parameters to Select Records for your Crystal Reports - George Jensen's Blog [customerfx.com] on Topsy.com

Tue, 08 Dec 2009 17:55:21 GMT

Pingback from Twitter Trackbacks for Using Multiple Value Parameters to Select Records for your Crystal Reports - George Jensen's Blog [customerfx.com] on Topsy.com

re: Working with the Like Function

Anonymous — Mon, 07 Dec 2009 15:55:28 GMT

Thanks for this information. I'm converting a VB6 database with reports designed in CR 8.5 into VB.NET and CR.NET and the wildcard character has apparently changed from "%" to "*".

Twitter Trackbacks for Working with the DatePart Function in Crystal - George Jensen [customerfx.com] on Topsy.com

Thu, 19 Nov 2009 16:23:26 GMT

Pingback from Twitter Trackbacks for Working with the DatePart Function in Crystal - George Jensen [customerfx.com] on Topsy.com

Twitter Trackbacks for Conversion Functions in Crystal - The Reporting Blog [customerfx.com] on Topsy.com

Wed, 04 Nov 2009 22:15:18 GMT

Pingback from Twitter Trackbacks for Conversion Functions in Crystal - The Reporting Blog [customerfx.com] on Topsy.com

Twitter Trackbacks for Crystals Length Function - The Reporting Blog [customerfx.com] on Topsy.com

Fri, 30 Oct 2009 14:07:39 GMT

Pingback from Twitter Trackbacks for Crystals Length Function - The Reporting Blog [customerfx.com] on Topsy.com

Working with Null or Zero Character in Crystal

The Reporting Blog — Tue, 13 Oct 2009 16:23:28 GMT

This is the start of a series of post working with the many functions used in the Formula Workshop of

Twitter Trackbacks for Business Object Crystal Formulas - The Formula Workshop - The Reporting Blog [customerfx.com] on Topsy.com

Tue, 06 Oct 2009 21:54:10 GMT

Pingback from Twitter Trackbacks for Business Object Crystal Formulas - The Formula Workshop - The Reporting Blog [customerfx.com] on Topsy.com

The BEST Way to Sync SQL Views Out to Remotes

Good Practices for CRM — Wed, 30 Sep 2009 21:58:42 GMT

For all my system admins out there... One of my co-workers, George, recently wrote a blog on synching views out to remotes. He has blogged on this topic before, but he is now convinced that he has the absolute best way to sync views out to remotes. His

re: The absolute Best Way to sync views out to Remotes

Ryan Farley — Tue, 29 Sep 2009 22:19:00 GMT

Good post George,

The BIG caveat with this method, and the reason why this hasn't worked in the past, is that the SQL statement that makes up the view can fail to be parsed by the SLX provider when the SQL starts to get complicated (which often in the case for a view).

When you execute this via the Execute SQL in the SLX Administrator, the query is parsed and executed via the SLX OLEDB Provider. The provider parses apart and reconstructs all statements that go through it. It does this for many reasons, but primarily to log operations and mainly to be able to determine security for the user it is being executed for, meaning, does the user have access to the data being retrieved in the query. If the SQL is complex enough then the SLX Provider will fail when it attempts to parse the statement. This is what has always been the problem in the past with this method.

Over time, the SLX provider's capabilities to parse complex SQL has improved significantly. It likely also, in newer versions at least, might even now parse statements differently that begin with CREATE VIEW (at least I hope it does). This is why this works now in recent versions better than this method did in the past. I would suspect that if the statement for the view became complex enough that you might still run into issues with this method, and it would certainly not work in most cases in older versions of SLX (again, due to the SLX provider capabilities of those prior versions).

In your previous post, the capabilities, or lack of, in the SLX provider did not have any impact on the creation of the view, even with the view's SQL statement was complex. This is because the previous method you outlined didn't execute the view via the SLX provider and instead used a native SQL connection to the database and bypassed the SLX provider altogether.

Anyway, just wanted to chime in with some of the reasons for this.

-Ryan

Twitter Trackbacks for Sync Views out To Remotes - The Reporting Blog [customerfx.com] on Topsy.com

Fri, 18 Sep 2009 20:57:12 GMT

Pingback from Twitter Trackbacks for Sync Views out To Remotes - The Reporting Blog [customerfx.com] on Topsy.com

re: The Unknown SalesLogix Calendar Report

George Jensen — Wed, 09 Sep 2009 21:52:45 GMT

No it is not at this time.

George

re: Crystal Reports (Passing figures from a Sub Report to the Main Report)

Jannoth — Mon, 07 Sep 2009 14:41:40 GMT

Hi George,

I'm using CRXI and rain into the problem of suppressing subreports suddenly leading to zeroed shared variables.

What a pain - so I stumbled upon the same formatting tweaks as you (ie remove borders, make the report tiny and suppressing within the subreport was allowed).

I'm exporting to Excel so get an unwanted row for each record - your suggested hyperlink method wouldn't work.

Am very suprised that nobody else has replied to your original post - which I found after deciding to look for a proper workaround. Is there really nothing out there???

Good luck :o)

re: The Unknown SalesLogix Calendar Report

SMBguru — Fri, 04 Sep 2009 20:30:39 GMT

Is this ava. in the web client?

SalesLogix Ticket Reports (Part 7)

The Reporting Blog — Tue, 01 Sep 2009 20:28:16 GMT

This is the final post reviewing the standard Crystal reports that come with an implementation of Sage

SalesLogix Ticket Reports (Part 7) - The Reporting Blog

SalesLogix Ticket Reports (Part 7) - The Reporting Blog — Tue, 01 Sep 2009 20:28:13 GMT

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

» Slight Improvements to the Weekly Recap Report - The Reporting Blog » Forex Demo Trading

Sat, 29 Aug 2009 22:59:06 GMT

Pingback from » Slight Improvements to the Weekly Recap Report - The Reporting Blog » Forex Demo Trading