Subscribe: The Crystal Reports Underground
http://kenhamady.com/cru/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
clear reports  clear  crystal reports  crystal  formula  formulas  objects  pages  recently  report  reports  sap  similar  site  things 
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, 17 Feb 2018 02:52:18 +0000

 



Blocking drill-down based on a condition

Sat, 17 Feb 2018 02:52:18 +0000

Here is a new twist to an old trick. I wrote several years ago about preventing users from drilling down on a section by putting a text object over the other objects in the section. I was recently asked if there was a way to have this happen only on certain groups. My initial reaction […]



Titles for Cross-tabs that spill onto horizontal pages

Sun, 11 Feb 2018 21:02:22 +0000

When a cross-tab gets too wide, it generates a ‘horizontal’ page to the right of the original. If you were to print the report to paper, these horizontal pages would print as separate pieces of pages. However, page header objects do not automatically repeat on these pages. So, any titles that you have in your […]



Finding tables and fields in SAP B1, JD Edwards and Great Plains

Mon, 29 Jan 2018 19:16:31 +0000

I was looking for a list of the tables and fields in SAP B1 and found a great site: http://www.saptables.net/ The person that maintains this site also maintains a similar site for the JD Edwards application http://www.jdetables.com/ So while I was at it I thought I would see if anyone had done something similar for […]



Finding changes in report output

Thu, 25 Jan 2018 20:23:15 +0000

I often work with large and complex reports. Sometimes making a minor change can have unexpected consequences. I like to be able to see that the only things that changed are the things I intended to change. If the report is long or dense it can be a challenge to identify changes. But I recently […]



Web based deployment options compared (2018)

Thu, 18 Jan 2018 02:59:37 +0000

There are many ways to deploy Crystal Reports to users. I normally lean toward the simpler and less expensive options, like locally installed viewers, or scheduled delivery of PDF output. But there are environments where a web based option is necessary. The “official” options from SAP are Crystal (Reports) Server and BO Enterprise. But there […]



The power of a double click.

Tue, 09 Jan 2018 03:23:39 +0000

I do lots of work using GoToMeeting and often the screen I see is reduced in size, making things hard to read. It can be frustrating when trying to highlight a word without including characters on either side. So I have developed the habit of using double-clicks to select words. I find that not everyone […]



Handy copy tricks in Crystal Reports

Fri, 29 Dec 2017 02:34:03 +0000

I have written before about copying objects, both within a single report or from one report to another. Below are some new tips for copying values instead of objects. Copying literal values from preview mode: Often when validating or troubleshooting a report I want to take a specific item from the preview screen (an invoice […]



Renaming formulas in the Formula Editor vs the Field Explorer

Sun, 24 Dec 2017 04:48:38 +0000

I write many formulas, and the more formulas there are in a report the more import it is to name them well. About 10 years ago I wrote an article with tips for naming formulas. I will often come back and rename formulas when I find that the original names aren’t clear enough. One of […]



How to fix the error “A loop was evaluated more than the maximum number of times allowed”

Sun, 17 Dec 2017 15:17:07 +0000

A customer recently asked for help with a formula. She was creating an index at the end of a report to show page numbers for each item within the report. Her formula used nested FOR loops to put the elements of the array in alphabetical order. It was similar to this handy formula that I […]



i-Net Crystal Clear Reports

Sat, 09 Dec 2017 14:52:28 +0000

I received a call this week from a potential customer who said he wanted me to help him modify some reports. But then he started talking about iNet Clear Reports. I told him that I did Crystal Reports and had never heard of Clear. He said that Clear was “just like” Crystal and he was […]