Tag Archives: tech tip

Question: I have created several prompts in my report. How do I display what was selected? Answer: This is a common request. Typically, parameters are used to let someone filter the records that get pulled back. Sometimes they are used in grouping or sorting. In any case, it is always …

Question: How do you create a chart that has both a Bar chart and a Line chart together in one? Example: (from MS Excel) Answer:The easiest way to accomplish this in Crystal Reports is to start with a Bar chart. If you want to incorporate all of the data in …

Question: I don’t see a way, in Web Intelligence, to change the color of individual data point on a chart. Is there a way to do this? Answer: Unfortunately, there is not a way to modify the color of an individual data point in a chart. You can, however, modify …

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 …