Crystal Tech Tip

The story of Romeo and Juliet, as portrayed by William Shakespeare, is the beautiful and tragic love story between two “star crossed lovers” from feuding families who fall madly in love. When Juliet feigns death in a desperate effort to be with Romeo, he thinks she is really dead and …

Is Crystal Enterprise the new version of Crystal Reports? How different is Crystal Enterprise compared to Crystal Reports 2016/2013/2011/2008. What are the architectural changes in Crystal Enterprise? What are the different data connectivity options for Crystal Enterprise? Which version of Crystal Reports is best suited for SAP data sources – …

Question: I would like a user to have a menu option to select ALL values in a dynamic prompt list, instead of having to set up the prompt to allow multiple values and the user having to select the double-arrows, if they want to use all the prompt values to …

In my previous blog I had explained a technique for dynamic Report field selection on a crystal report. If the order of the fields selected is changed we end up having empty spaces as shown below:   Here are the steps to be followed to avoid these inevitable spaces, when certain fields …

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