Tech Tip

How to Show a friendly message when “No Data to Fetch” When your data provider(s) return no data, the document looks pretty ugly. It will typically show column headers without any content, zero totals, and some formulas may even display embarrassing error messages. So let’s use conditional blocks (see “Get …

  2015-02-06 UPDATE:  A newer version of this techtip has been created – visit the following link: https://www.infosol.com/crystal-tech-tip-select-all-values-in-a-dynamic-prompt/ Question: I would like a user to have a menu option to select ALL values in a dynamic prompt list, instead of having to set up the prompt to allow multiple values …

Question: I would like to highlight values in my crosstab, with a different background color, by comparing the summarized value in the crosstab to other fields in my report, but the highlight expert and the format field/background options don’t seem to work correctly? Solution in Crystal Reports XIR2: Answer: You …

Question: How can I set up our company logo, to appear in Web Intelligence, in the header? Answer: Since you cannot embed pictures and objects in Web Intelligence XIR2 and prior, they must be set up as images or skins available as a “Backgrounds” or “URL Links”.   To store …

Question: I have a need to show dates, in a column, that fall into a certain date range (1-5 days). In the second column, show dates that fall into a second date range (6-10 days). At the bottom of each column, display a count of the dates that fall into …

Question: I would like to highlight values in my crosstab, with a different background color, by comparing the summarized value in the crosstab to other fields in my report, but the highlight expert and the format field/background options don’t seem to work correctly? Answer: You can create a formula, that …

Question: When would you want to change the Link Enforcement options in the Database Expert? Answer: Limit the results of report based on the values from another table without using a WHERE or Selection criteria. Limit the results of your report without having to put unnecessary fields on your report …

Question: Our data is very sensitive and we’ve been asked to provide a warning to users accessing InfoView. Can I do this without using the SDK? Answer: Yes. This requires a modification of the InfoView configuration file for your web application server. For Tomcat, this configuration file is in: <BusinessObjectsInstallation>\Tomcat\webapps\businessobjects\enterprise115\ …

Question: How do I show all the group headers when drilling down on my report? Answer: When you choose to HIDE details or certain groups on a Crystal Report, once you navigate to the details or hidden groups, a new tab opens and you no longer see your group headers …

Question: How can I change my grid size from measuring in inches to centimeters? Answer: Change your overall Regional and Language Options in the Control Panel. When working on reports that contain many objects in one section, it is very helpful to turn on the grid in Crystal. File>Options>Layout (tab)>Design …