Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
adding inflation  crystal reports  crystal  inflation  master dates  master  order  part  report  reports  run reports  run  server  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, 16 May 2017 18:00:48 +0000

 



How to “break” specified order grouping

Tue, 16 May 2017 18:00:48 +0000

The “specified order” feature in Crystal is useful when you need to group on a field, but you don’t want the values in normal ascending or descending order. With specified order you can place some or all the values for a field into the exact order that you want them to appear. Specified order is […]



Creating a master “dates” table on the fly.

Tue, 09 May 2017 14:32:06 +0000

In some environments, developers have to maintain a master “dates” table with a complete list of dates. If used correctly, it can allow a report to fill in date gaps where there are no transactions. You would have the report start with the master dates table and then link to the date field in your […]



Adding an inflation table (Part 2)

Fri, 28 Apr 2017 21:16:38 +0000

My last post was about inflation tables and included a quick and dirty method for deploying one using a spreadsheet.  I started with that method because anyone can use it and it should work in any report.  But there are better methods you can use most of the time.  The ideal method is to create […]



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 […]