Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
column maximum  crystal reports  crystal  data  free  maximum  notepad  numbers  refresh  report  reports  sql commands  {svc labdate} 
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, 16 Sep 2017 19:28:32 +0000

 



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



Crystal Reports Language for Notepad++

Mon, 28 Aug 2017 01:59:00 +0000

Last week I wrote about using Notepad++ for working with SQL Commands and formulas. I loved the numbered lines and the way it finds matching parens. But I missed the green comments and blue functions. Notepad++ has about 80 languages that it can format correctly but Crystal formula syntax wasn’t one of them. So I […]



Using NotePad++ for formulas or SQL Commands

Thu, 24 Aug 2017 21:50:06 +0000

If you have to write SQL commands or complicated Crystal formulas, it helps to have a good text editor. My favorite is NotePad++. Not only is it free, but it can do many helpful things beyond what Notepad can do: Number each line. Highlight the corresponding paren/bracket whenever you select a paren/bracket Highlight all the […]



Set Location in a Progress database

Sat, 19 Aug 2017 02:08:57 +0000

I have written before about database connections that require the table alias to be different than the table name. Often this is accomplished by adding a 1 to the original table name. This came up again recently with a customer using a Progress database. We were doing a “Set Location” for a connection that covered […]



Additional parameter values are needed ….

Mon, 14 Aug 2017 03:42:39 +0000

If you refresh certain reports and then try to save the report with data you may get the following error: “Additional parameter values are needed before this report can be saved or viewed with data….” The error seems to occur only in certain versions of Crystal.  If you see this message and want to save […]



RPT management utilities for 2017

Sun, 30 Jul 2017 18:19:36 +0000

I have just updated my comparison of RPT management utilities for 2017. These are tools that allow you to scan, document, compare and in some cases batch update RPT files.  The list now includes 9 tools: Report Runner Documentor by Jeff-Net R-Tag Documentation and Search by R-Tag CR Data Source by R-Tag Visual CUT and […]



A switch to turn “stealth” subreports on and off

Wed, 26 Jul 2017 03:28:05 +0000

I wrote a long time ago about the “Stealth” subreport. This is an invisible subreport that runs in the background and provides a value to the main report as a shared variable. But if you have a few of these subreports in the same container report it can be difficult to do troubleshooting. To see […]



Refresh prompt when you change pages?

Sun, 16 Jul 2017 18:03:05 +0000

This strange behavior has nagged at me for a while. I refresh a report that has subreports and preview the first page. When I move to the next page I get a prompt that says: “Change in record selection formula” and the choices are “Use Saved Data” or “Refresh Data”. Now it is obvious that […]



Sorting numbers that come after letters

Mon, 10 Jul 2017 23:01:26 +0000

I recently had a customer ask if I could help him sort part numbers. The problem was that the part numbers start with one or more letters followed by 2 to 7 digit number and sometimes a dash in between. Since the field is a string, and since the numbers vary in length, the sort […]