Tag Archives: tech tip

In addition to the Xcelsius Best Practices Tech Tips found on this site, you can also find helpful information on the InfoSolBlog site.  View all posts tagged Xcelsius Best Practices or select from those listed below:   To Cache or not to Cache – Boosting performance in Xcelsius Tech Tip …

Question: I often need to display Boolean data on my reports, but am looking at other ways to represent this other than just “True” or “False.” Is it possible to do this – for example, could it be set up to display check boxes instead?   Answer: Yes, it is …

Question: How can I dynamically change the colors on my charts or backgrounds based on user selection?   Answer: Kudos to the Xcelsius development team SAP Business Objects for giving us so much in SP3! One of the great new features is the option to bind the color to a …

Question: Wouldn’t you like a way to visually show/compare your data right at the detail-level? Answer: With a little preparation and some simple formulas, it can be yours. Explanation This Tech Tip uses the Customer Table from the Sample Database that comes with Crystal Reports. Also, I am working with …

Question: I need to combine a list of details, or group information, and print it in the footer. How can I accomplish this? Answer: This Tech Tip will show how you can do this using Dynamic Arrays within Crystal Reports formulas. There are two types of arrays in Crystal Reports …

Question: In Xcelsius, can I use the “Filtered Rows” functionality to move and filter data from one place to another? Answer: Yes, however, if you use that functionality directly from an interactive selector, then only one set of data will be able to be moved. In this example, we have …

Question:  Have you noticed that sometimes when using a progress bar you are unable to change the settings on the “Progress Movement?”  That it will appear grayed out? Answer: This is due to selecting a cell for the Data in the “General” tab where no values are currently populated. To …

Question: Multiple-tabbed Dashboards, with many formulas and components, take a long time to load into a web browser. To lessen the initial load time, we elected to create separate html/swfs for each tab and link them by URL. Some users want an easy way to open all the html/swfs at …

Question: What can I use the Xcelsius History component for? Or, how can I get my report to launch with the correct prompt? Answer: I finally found a use for the History component, recently, when I found my linked report launching with old data, rather than the latest selection. This …

Question: I have a Business View that I want to copy and modify. Can I make a copy of a Business View in Business View Manager? Answer: While Business View Manager does not have a Copy feature, it does allow for this. In reality, what you need to do is …