I recently attempted to use the new Commentary Service available in Business Objects 4.2 to enter a comment in a Web Intelligence report. I received an error stating the “Commentary Service is unavailable”, and directing me to see my platform Administrator. I saved the document, and tried the different ways ...
Read More »Crystal Reports Export to Excel – Part 2
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 ...
Read More »Excel in “Crystal Reports Export to Excel” – Part 1
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 ...
Read More »Crystal Reports with Top N Based on a Date Dimension
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>? ...
Read More »Crystal Reports with Dynamic Report Field Selection – Part 2
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 ...
Read More »Regional BO Crystal User Groups Alive and Thriving
In the last two months, I have attended three regional independent BusinessObjects and Crystal User Group Meetings that have simply been amazing both in terms of their content and user participation. One was in Pennsylvania, one in Michigan and one in Arizona. Each one had between 50 to 70 attendees, ...
Read More »Text Formatting Your Way in Crystal Reports
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 ...
Read More »