Tech Tips

* = What's New This Week!

Click here for Xcelsius & Crystal Tech Tips

Business Objects - Enterprise 6

  • Alerters in WebIntelligence Version 6.1
  • Error BAW0011: Internal Error
  • Ranking on More than One Dimension
  • Designer "Save as PDF"
  • Export Results as XML
  • Base a Data Provider on Another (a.k.a. "Copy Query")
  • Create a Query on Query Results
  • Pop Up Calendars for Date Prompts
  • E6 Shortcut to Create a New Data Provider Starting with a Previous Data Provider
  • The Power of Advanced Filters in WebIntelligence Version 6
  • Query Result as Operand

    Business Objects - End User

  • Resetting the Running Sum for Each Column in Web Intelligence
  • Using Detail Objects in Web Intelligence to Display Data in a Block
  • Dynamically Displaying Charts and Colors
  • Ranking by Two Dimensions
  • Reducing the Size of Unusually Large Documents
  • Modifying Color Palettes in Web Intelligence XI R2
  • Using Boolean Variables
  • Adding Logos for Use on Reports
  • Calculations Interacting with Alerter Output
  • Force Sorting on all List of Values
  • Adding a Data Warning Message to InfoView
  • Multitab Printing
  • Adding a Logo to a Web Intelligence Document
  • Using Alerters to Apply Hidden Sort
  • Using Advanced Context
  • Pictures As a Background for Cells in Web Intelligence
  • Increasing Java Heap Size for Web Intelligence
  • Copying Web Intelligence Report Data to Microsoft Word, Excel or PowerPoint
  • Search for an Object in Web Intelligence
  • Slow Prompts in XI R2
  • Ranking for Only 15 Values when Rank Filter gives 30
  • Line Number Within Sections
  • Limiting a Top 3 Ranking to Only 3 Rows
  • Adding Second Block to Drillable Report for Slicing
  • Return Last Day of Month in WebIntelligence v6.1.b
  • Month Numbers to Month Names
  • Dealing with No Rows for Some Values
  • Be More Selective? You Bet!
  • Avoiding User Confusion because of Partially Refreshed Documents
  • Using Images in Your Reports
  • Merging Separate Objects or Texts and Adding a Second Line in a Cell
  • Need Blanks or Nulls without Outer Joins? Consider a Second Query
  • Need a Row Above or Below Certain Values? Try a Value-Based Break!
  • Using Matches Pattern as a Search For and Highlight Prompt
  • Creating the Sectioned Look with Breaks
  • Windows Shortcuts for Heavy BO Users
  • Use Your Own Personal List of Values
  • Select All Values in a Prompt
  • Aggregation Error on AS400
  • Union vs Union All
  • Apply Repeating Variable with a Template
  • Applying Filters on Measure Objects
  • All About Templates
  • Business Objects to MS Excel
  • All About Standard Styles
  • Rows of Varying Height Automatically
  • Ghost Sorts
  • Dealing with Multiple Address Lines
  • Hide and Sort
  • How to count the number of rows of data that make up each aggregated value in a report
  • How to exceed the limitation of nine union queries
  • An application for the “Hide block” functionality
  • Show friendly message when “No Data to Fetch”
  • Troubleshoot Document Formatting
  • Create Crosstab with Templates

    Business Objects - Designer

  • Avoid Creating Different Universes for Different Drill Paths for the Same Object Set
  • Using Decode with Multiple Tables
  • Helpful Designer Tools and Settings
  • Create a Select Prompt for a Constant Not Present in Your Database
  • Using Dummy Objects to Satisfy Combined Query Requirements
  • Performance Enhancer: Shortcut Joins
  • Select All Values in a Prompt
  • Effective Dating for Current Customer Information using a Correlated Subquery
  • Turning a multi-row structure table into a multi-column table using a CASE statement
  • User-Based Restrictions
  • Link to the Web from Business Objects
  • Limitations of Shortcut Joins
  • Creating user-friendly List of Values with “Cascading LOVs”

    Business Objects - Administrator

  • Early Daylight Savings Time Policy

    Xcelsius - End User

  • * Charting Enhancements with Xcelsius SP3
  • Passing Flash Variables
  • How to Implement "BOUSER" Row-Level Security in Xcelsius QAAWS and Live Office Connections
  • Vertical Bullet Charts in Xcelsius SP3
  • Dynamic Color Selection with Xcelsius 2008 SP3
  • Using a Combo Box to Move Multiple Sets of Data in Xcelsius
  • Filtered Rows in Xcelsius
  • How to Enable Component Properties when Showing as Disabled in Xcelsius
  • Hidden Filtered Rows
  • One Way to Work with Multi-tabbed Large Dashboards
  • Xcelsius History Component
  • Xcelsius Absolute Week
  • Refresh on Load
  • Local Scenario
  • Trend Analyzer Component
  • Packaging your Dashboard as a Desktop Application
  • How to Export to PowerPoint using Xcelsius 2008
  • Dynamically Resizing a .SWF with the Browser Window
  • Switching Column Order
  • Reset Sliders in Xcelsius

    Crystal - End User

  • * Displaying Boolean Values as Check Boxes
  • Shared Variables - Part 2
  • Shared Variables
  • Formatting a Currency to Appear in Words
  • Text Formatting Your Way in Crystal Reports
  • In Row (Detail) Charting
  • Formatting Dates in Charts using Crystal Reports
  • Distributing a Crystal Report to an E-mail Address
  • Gradual Drill Down for Crystal Reports
  • Custom Functions in Crystal Reports: What They Are and How to Use Them
  • Displaying Parameters
  • Parameter Panel in Crystal Reports 2008
  • Using Selective Sheets from Excel Source in Crystal Reports
  • Crystal Reports and Arrays
  • Rank within a Group
  • Best Practices
  • Copying Business Views
  • Displaying Parameter Values
  • Creating Optional Parameters in Crystal Reports XI
  • Creating a Combo (Control) Chart
  • Easy DateTime Range Record Selected
  • Selecting All Values in a Dynamic Prompt List
  • Highlight Values in Crosstabs in Crystal Reports 2008
  • Highlight Values in Crosstabs
  • Using Crystal Reports to put Data Back Into a Database
  • Examining Join Enforcement
  • Time Display Formatting Function
  • Creating a Dynamic Prompt
  • Show Group Headers When Drilling
  • Changing Grid Size
  • Showing the Top 5 Details
  • Updating Crystal with Table or Stored Procedure Changes
  • DrillDownGroup Level Function
  • Better Manage your Crystal Reports Dynamic Prompts
  • Special Characters in a Crystal Report Formula Field

    Also check out the very helpful "Tips and Tricks" web site from Business Objects: http://www.businessobjects.com/services/infocenter/.

    We plan to keep this area alive and dynamic, so keep checking for new tips & tricks! Better yet, subscribe to our BO Tech Tips mailing list by filling out the form below!


    • © 2010 InfoSol® Inc. All Rights Reserved

    Legal