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 …
Read More »Crystal Reports – Examining Join Enforcement
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 …
Read More »InfoView – Adding a Data Warning Message
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\ …
Read More »Crystal Reports – Show Group Headers When Drilling
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 …
Read More »Crystal Reports – Changing Grid Size
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 …
Read More »Crystal Reports – Control the Level of Drill Down
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 …
Read More »Web Intelligence – Copying Data to MS Word, Excel, or PowerPoint
Question: In BusinessObjects XI R2, how do I copy Web Intelligence Report Data to other applications such as Microsoft Word, Excel or PowerPoint? Answer: In XI R2, you have the ability to copy data from a Web Intelligence report into other applications such as Microsoft Word, Excel or PowerPoint. With …
Read More »Crystal Reports – Dynamic Prompt Best Practices
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 …
Read More »Web Intelligence – Search for an Object
Question: How do I search for an object in Web Intelligence? Answer: Rather than scrolling up and down looking for an object, try this: Click anywhere in the work area and start typing the object name. It highlights the first object beginning with those letters. Then, simply press the down …
Read More »BusinessObjects – Slow Prompts in XI R2
Question: In XI R2, when I refresh Web Intelligence or Desktop Intelligence documents, that contain prompts with Lists of Values, I experience, long, sometimes unacceptable wait times until the prompts are displayed. What is the cause for this? Answer: The cause for this problem is the fact that the Lists …
Read More »