Crystal Tech Tip

  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: 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: 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 …

Question: When publishing a summary report to Enterprise using the Suppress Section feature the users think they can drill down on a report and expect to see details but do not. Is there anyway to turn off drill down when suppressing a section? Answer: No, but you can use the …

Question: How can I better manage my Crystal Reports Dynamic Prompts? Answer: There are 2 ways you can create Dynamic Prompts in Crystal Reports XIR2: In the Crystal Reports application. OR In the Business View Manager application (if you have purchased Business Objects Enterprise).   The first method, creating the …