Subscribe: The Crystal Reports Underground
Added By: Feedage Forager Feedage Grade A rated
Language: English
based  crystal reports  crystal  format  group specific  multiple  report explorer  report  reports  sap  security  sql  visual cut  web 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: The Crystal Reports Underground

The Crystal Reports® Underground

Independent news, tips and thoughts from a Crystal Reports expert

Last Build Date: Tue, 21 Mar 2017 18:49:07 +0000


“Poor man’s” row level security

Tue, 21 Mar 2017 18:49:07 +0000

One of my customers has a report that he can run for one Sales Rep or all. He now wants the Sales Reps to run the report themselves, but doesn’t want them to be able to run each other’s reports. He wanted the report to be restricted based on the user’s windows login. The term […]

Finding the last day of the month

Thu, 16 Mar 2017 22:56:05 +0000

Years before I started my blog I was creating online content in forums like I am still an occasional contributor there but years ago I was spending an hour or more every day answering questions and generating thousands of posts. It isn’t unusual for me to do a web search and find my own […]

Today’s date in SQL Server

Fri, 10 Mar 2017 01:31:13 +0000

I haven’t written many posts on SQL topics. But recently it seems that much of my work involves writing reports based on complex SQL queries. Part of this involves converting Crystal formula logic into SQL syntax. The fun part is that the syntax varies from one flavor of SQL to another, especially for date calculations. […]

Using the NthSmallest() Function

Tue, 28 Feb 2017 21:54:24 +0000

In the ideal world, customers write perfect specs up front, and requirements never change. In my work reports tend to evolve through several iterations. Some customers don’t realize what would work best until they start to see drafts. Last week a customer presented me with what is usually a fairly simple request: print only the […]

Security vulnerabilities in Crystal Reports web apps

Sat, 18 Feb 2017 22:27:56 +0000

A Crystal Reports web development team has posted in the SAP forums about some security weaknesses in the .NET web deployment model. They are trying to get the attention of SAP, without success so far. It appears that this team deployed a .NET web application using the Crytal Reports runtime engine. During a security audit […]

A simpler way to maintain formatting conditions

Wed, 15 Feb 2017 04:32:06 +0000

I have written before about the advantage of using CurrentFieldValue when applying a formatting condition. This is especially true when applying a similar format to multiple fields, because it allows you to ‘paint’ the format properties from one field to another using the format painter.  Related to this method is a way to make it easy to update all of […]

Visual Cut adds RPT management capabilities

Wed, 08 Feb 2017 03:35:54 +0000

Visual Cut has always been a solid desktop scheduler. I have used it for years to send out my invoices. But Ido Millet of Millet software has recently added some new features that allow you to scan multiple reports. The scan reads in the database fields, text objects, SQL expressions and all formulas (including selection […]

Web based deployment options compared (2017)

Fri, 27 Jan 2017 05:00:27 +0000

There are many ways to deploy Crystal Reports to users. I normally lean toward the simpler and less expensive options, like locally installed viewers, or scheduled delivery of PDF output. But there are environments where a web based option is necessary. The “official” options from SAP are Crystal (Reports) Server and BO Enterprise. But there […]

Renaming image objects

Sun, 22 Jan 2017 16:50:51 +0000

This was the first time I found a practical use for renaming a report object, a feature that has been available since 2002. Every object placed on a report is given a unique “object name”. These names appear in the Report Explorer (View > Report Explorer) which lists all of the objects and where they […]

Group-specific subreport that only hits the database once

Fri, 13 Jan 2017 02:44:52 +0000

Group-specific subreports are always a last resort for me, because they hit the database multiple times and usually that slows things down. Sometimes, though, they are necessary. I recently had to create a report with about 100 groups, and each group needed a subreport that ran a separate query returning a very large dataset. I […]