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  formula  function libraries  new  portal  recrystalize  reports  web portal  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: Fri, 13 Jan 2017 14:01:30 +0000

 



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



Reduced prices for the “Expert” series

Mon, 09 Jan 2017 03:29:54 +0000

Starting this month, the prices for the “Expert” series of educational PDFs have all been cut in half. So if you were hesitant, maybe the new prices will make it easier to try them out. Check out the full list of titles here along with the new prices.



Putting a watermark under lines or boxes

Wed, 28 Dec 2016 04:04:31 +0000

Crystal will allow you to layer or superimpose images and text. Sometimes this is done intentionally using a faint image which creates a watermark effect behind the text. But if you are using lines or boxes with your text, the watermark won’t behave the same way. For some reason, text objects can be set to […]



Adding comments to formulas

Fri, 23 Dec 2016 04:58:24 +0000

Most programming languages allow you to add comments in your code. This is useful to explain a calculation or to document changes. Creating these comments usually involves some special punctuation at the beginning and/or end of the comment which tells the program to skip over those lines.  There are several different syntax patterns that indicate […]



New web portal from ChristianSteven Software

Fri, 16 Dec 2016 02:48:34 +0000

ChristianSteven Software has released a new web portal product in 2016 called IntelliFront BI. It can run Crystal Reports, SSRS Reports and MS Power BI dashboards.  It also allows you to create and run proprietary KPI reports and scorecards. As a web portal, it allows users to run reports on demand.  But it can also […]



ReCrystalize releases ReCrystalize Server web portal

Thu, 08 Dec 2016 04:26:05 +0000

ReCrystalize has just released a simple web portal called ReCrystalize Server. It allows you to make your Crystal Reports available on an IIS server. Users can browse the reports which are stored in folders. They can then open and refresh the reports through their browser. ReCrystalize Server will prompt the users for any necessary parameters, […]



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