Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
crystal reports  crystal  date dateserial  date  field  formula  function libraries  function  functions  month  new  report  reports 
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: Fri, 02 Dec 2016 11:49:03 +0000

 



Crystal Reports formula function libraries (2016)

Sun, 27 Nov 2016 03:52:09 +0000

It is time for my annual comparison of formula function libraries. If you aren’t familiar with User Function Libraries (or UFLs) they are DLL files that add new formula functions to your Crystal Reports formula editor. With these functions your formulas can do some pretty amazing things like: 1) Carry values from today’s report to tomorrow’s […]



Date vs DateSerial

Sun, 20 Nov 2016 22:20:05 +0000

There are many functions in Crystal with overlapping capabilities, like Val() and ToNumber(). I have always thought of Date and DateSerial as identical functions that both allow you to specify a literal date in a formula by specifying the year, month and day as numbers like this: Date (2016,11,24) DateSerial (2016,11,24) The three numbers can […]



Save 10% on Crystal Reports

Thu, 10 Nov 2016 21:58:10 +0000

For a limited time, you can save 10% on any Crystal solutions product purchased individually. Just visit the SAP Store to buy new licenses or upgrade from an older version. Then use the promo code: TENCRYSTAL And if you want to purchase one NUL (named user license) of the following three products: SAP Crystal Reports […]



Using Crystal’s pre-programmed date ranges

Wed, 09 Nov 2016 14:57:27 +0000

One of my customers learned a new trick from me today. They wanted a report to automatically select the data for the prior month. They didn’t realized that Crystal has a dedicated function for that and you can use it in both the select expert or in the selection formula. So I figured I would […]



Automatically translate report text to another language

Sun, 30 Oct 2016 14:39:57 +0000

Supporting multiple languages in Crystal Reports just became much easier.  Ido Millet of Millet Software has added a new translation feature to DataLink Viewer.  This allows reports to automatically translate all static text objects from one language to another.   The feature taps into Google Translate, so it supports any of the 100 or so languages […]



Slope, intercept and correlation of x-y coordinates

Tue, 25 Oct 2016 14:45:28 +0000

I was recently asked to convert an Excel spreadsheet into a Crystal Report. I found that the spreadsheet used some Excel statistical functions that don’t exist in Crystal, so I had to replicate those in Crystal syntax. The functions calculated the slope, intercept and correlation of a series x-y coordinates. Once I had them working […]



Sorting on a memo field.

Sun, 16 Oct 2016 21:28:32 +0000

A customer wanted to sort on one of the fields in his report. But when he went into the Record Sort Expert that field was not shown. So he sent me the report to troubleshoot. I noticed that the data type of that fields was Memo, which is a data type that has an unlimited […]



Custom date format in charts

Fri, 07 Oct 2016 02:16:34 +0000

I periodically hear from Adam Butt of APB reports (Norway), usually when he stumbles on a neat Crystal Reports trick. This month he wrote to share a method for controlling the format of dates in charts. When you do a “group” chart, Crystal creates a bar for each group in the report. The label under […]



Updated comparison of Crystal Reports viewers (2016)

Sat, 24 Sep 2016 13:20:34 +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. […]



Field is in use? The last resort

Mon, 19 Sep 2016 12:53:54 +0000

I wrote two posts last month about finding where a field is used. I got to test these methods recently while helping a customer clean up a report. There were a handful of formulas shown as “in use” that we needed to delete. So I thought this would make a good demo of the new […]