Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
crystal reports  crystal  find  formula  holidays  maximum  microsoft  new  reportal  reports  run  server  time  user  viewer  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: Mon, 13 Nov 2017 19:26:28 +0000

 



Save money on reportal

Mon, 13 Nov 2017 19:26:28 +0000

reportal Software has just released reportal 6.2, a new version of their web portal for Crystal Reports.  They are offering a 10% discount on all server license fees through November 30, 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 […]



Formula that calculates all US federal holidays

Tue, 07 Nov 2017 20:33:31 +0000

I have several formulas that relate to “business days” or “business hours“. Most allow you to exclude holidays as long as you maintain a list (array) of holidays in a formula in the report. Years ago, one of my readers took the time to write a formula that would automatically load the holidays into an […]



New Crystal Reports viewer

Wed, 25 Oct 2017 03:38:10 +0000

APB Reports has released a new viewer called CR Dispatch. CR Dispatch takes a different approach to viewing your reports, since it has a minimal user interface that only appears the first time you run a report. After that it provides a secure way to run a specific RPT with one click. The first time […]



Microsoft updates break spreadsheet driver (and a possible workaround)

Wed, 18 Oct 2017 02:26:37 +0000

Two customers contacted me in the past few days about the following Microsoft updates. KB4041676 for Windows 10 KB4041681 for Windows 7/8 These updates broke reports that use the ‘classic’ Microsoft JET drivers to read ‘classic’ xls spreadsheets. ‘Classic’ here is a euphemism for ‘ancient but still working’, like my workhorse Office XP from 2002. […]



Find it EZ partners with rePORTAL

Mon, 16 Oct 2017 02:52:54 +0000

Find it EZ (search and documentation) has recently partnered with rePORTAL (scheduling and distribution), which means some new Find it EZ features and some discounts for rePORTAL customers. Find it EZ now directly integrates with the rePORTAL scheduling database. This allows rePORTAL users to extract scheduling information (run times, recipients, destinations, etc.) into user-friendly spreadsheets […]



SQL Function “cheat sheet” for writing commands

Sun, 08 Oct 2017 21:44:11 +0000

In recent years, I have been doing lots of SQL command-based reports, which means writing lots of queries in every imaginable flavor of SQL. It was initially frustrating trying to keep the syntax changes straight and I got tired of doing web searches for the same functions over and over. My solution was to create […]



Updated comparison of Crystal Reports viewers (2017)

Tue, 26 Sep 2017 21:08:48 +0000

You use Crystal Reports to create, change and run reports. But what if you have users who just need to refresh/view/print/export? Do they need copies of Crystal Reports? Do you need to configure an expensive web server? The most cost effective method for letting a user run reports is to install a third-party client-based viewer. […]



25% off Find it EZ products

Thu, 21 Sep 2017 16:26:58 +0000

SAP recently selected Find it EZ products for their first cloud platform partner spotlight. To celebrate, Find it EZ is taking 25% off the price of any new license purchase for Code Search Pro or Dev Surge 365 Enterprise. The offer is currently till October 30. Here are links to the two product links, but […]



Doing a Maximum “horizontally” as opposed to “vertically”

Thu, 14 Sep 2017 22:17:37 +0000

Most of the time when you see the Maximum () function in a formula, it is to calculate the highest value in a column. It could look like this: Maximum ( {Svc.LabDate} ) which would calculate the latest lab date in the entire column. Or it could look like this: Maximum ( {Svc.LabDate} , {Patient.ID) […]



Free software for the Houston area

Wed, 06 Sep 2017 03:14:52 +0000

From the R-Tag web site: R-Tag is providing free licenses to companies in the Houston area. The offer is valid until the end of September 2017. The eligible products are: R-Tag Documentation and Search and R-Tag Crystal Reports Data Source updater. We already have a free Crystal reports viewer and scheduler (R-Tag Community edition), which […]