Tech Tip

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 …

Question: I have created several prompts in my report. How do I display what was selected? Answer: This is a common request. Typically, parameters are used to let someone filter the records that get pulled back. Sometimes they are used in grouping or sorting. In any case, it is always …

Question: How do you create a chart that has both a Bar chart and a Line chart together in one? Example: (from MS Excel) Answer:The easiest way to accomplish this in Crystal Reports is to start with a Bar chart. If you want to incorporate all of the data in …

Question: I don’t see a way, in Web Intelligence, to change the color of individual data point on a chart. Is there a way to do this? Answer: Unfortunately, there is not a way to modify the color of an individual data point in a chart. You can, however, modify …