Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
based  crystal reports  crystal  customers  net web  part  report  reports web  reports  run reports  run  security  server  sql  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: Sat, 22 Apr 2017 14:23:04 +0000

 



Adding an inflation table (Part 1)

Sat, 22 Apr 2017 14:23:04 +0000

I have a couple of really handy calendar report templates that I have sold to several of my customers. They are mostly simple to deploy but there is one tricky part, and that is that they require an “inflation table”.  This is a table that is added to the report to force each record in […]



Using OLEDB to read MS Excel or MS Access files

Fri, 14 Apr 2017 01:20:05 +0000

Occasionally I have customers that need to query MS Excel or MS Access files for their Reports. Crystal Reports has always provided a DAO connector that allows you to read the classic XLS and MDB files directly. But starting in 2007 Microsoft introduced the XLSX and ACCDB formats and these can’t be read using the […]



Reports on a phone with no server to setup

Sun, 02 Apr 2017 17:45:30 +0000

The team at SaberLogic has just created a new way to deploy Crystal Reports on the web. It is a SaaS tool called Bezlio. Bezlio allows users to run reports on demand from the browser on any device (including your phone). But the difference is that you don’t have to set up a web server […]



Comparison of desktop-based schedulers (2017 update)

Tue, 28 Mar 2017 01:22:22 +0000

How would you like your reports to be automatically run, exported to a PDF and delivered to your Email InBox every Monday morning at 6am? The Crystal Reports designer doesn’t provide a way to do this (unless you upgrade to CR Server or BO Enterprise). But if you look at third party products like those […]



Save money on rePORTAL

Fri, 24 Mar 2017 14:29:18 +0000

Reportal Software has just released rePORTAL 6.1, a new version of their web portal for Crystal Reports.  They are offering a 10% discount on all server license fees through April 15, 2017.  I don’t see the server price on their web site but the price was $3,000 per server in January when I did my […]



“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 Tek-Tips.com. 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 […]