Crystal Reports

I have learned many valuable life lessons coaching kids’ soccer. Like the time my team of 10-year-old boys lost a game 12-0 and I tried to give one of my inspirational after-game pep talks. The players felt down, I felt down and as I tried to tell them the score …

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 …

In one of my recent client engagements, there was a requirement to replace Microstrategy reports to Crystal Reports. The business users were not ready to compromise on the format of Excel. I created a crystal report with Microstrategy SQL and used InfoBurst – Infosol’s flagship bursting product to deliver these excel …

It’s been a while since I published part 1 but hey, better late than never.  So here’s Part 2 of my previous blog “Crystal Reports Export to Excel – Part 1”. I have used the same report from Part 1. The following tips & tricks will help you in providing a perfect/clean …

We have seen various ways to create reports like Top 10 Customers by Sales, Top 10 Cities by population, Top 5 countries by profit Margin etc. It’s usually Top N by a <Measure>. What if there’s a requirement Top N by a <Date> or Most Recent N by a <Date>? …

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: Have you ever created a formula, to build a string of text, and wanted to format parts of it separately? Answer: Use HTML codes to format your string.     Explanation This Tech Tip uses the Customer Table from the Sample Database that comes with Crystal Reports. The easiest way to …