Tech Tip

BusinessObjects users worldwide use the BusinessObjects Bulletin Board (affectionately named “BOB”) to learn from and about each other. BOB was created for and is maintained by individuals like you: people who want to get the most out of their investment in Business Objects products. BOB can be found at https://bobj-board.org/ …

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

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 …

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 …

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 …

The Ranking button, for filtering a dimension based on its corresponding measures, will return the top or bottom ranked results. Consider the 15th ranked result. What if there were 16 values at the bottom that are evenly ranked? In this case, requesting the top 15 results returns 30 values, 16 …

Alerters are available in v6.5, however, if using the earlier version, you might find the following techtip useful. Alerters are used in the full client tool to apply conditional formatting. Although Alerters are not available in WebIntelligence as a toolbar button and interface, like they are in the full client, …

If you save a sectioned report as HTML and choose the “section by section” option, the sections are saved in separate HTML pages numbered from 0 (i.e. 0.htm, 1.htm, etc.). In wanting to link to these sectioned pages from another sectioned page, you need a way to correspond the link …

QUESTION: How do I format a Month Number to a Month Name? ANSWER: Most of our date conversions come directly from a date. If given just the month number, however, you must first convert the number into a valid date format and then you may use the FormatDate() function to …