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 »Three Key Tips for Building Mobile Dashboards
You walk into your office in the morning. You’ve double-checked your inbox and meeting schedule on your phone on your way in. You whip out your tablet and quickly go through the morning reports. Your everyday necessities are quickly becoming all available at the touch of your mobile devices. But ...
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 »Crystal Reports with Dynamic Report Field Selection – Part 1
Crystal Reports are very good for printable reports, but what if you don’t need every single field on the report? What If you had to dynamically change the report fields. This blog will help you in designing a crystal report with dynamic report fields. Consider a crystal report with the ...
Read More »Xcelsius Tech Tip: Overcoming Checkbox Shortcomings
The checkbox is one of the most common UI elements that allow its users to have binary choices and it is available out-of-the-box in Xcelsius/SAP Dashboards. However, the Xcelsius component is limited due to the inability to control the selection or reset to its default state in run-time programmatically. In ...
Read More »Antivirus Software: Good or Bad for BO 4.1?
Having antivirus software is great to maintain the immunity of a system, but in certain cases these AV softwares can start to over work themselves and it can really take a toll on the machine and can also affect the overall performance of Business Objects. I have seen clients face issues ...
Read More »Creating a Performance Optimized Dashboard Leveraging Derived Tables in IDT
In my previous blog, I talked about “5 Easy Steps for Designing a Dynamic Y-Axis Web Intelligence Report Leveraging Derived Tables in IDT”. In this post I am going to show how the same derived tables concept designed in IDT can be utilized to create a performance optimized dashboard. Consider ...
Read More »Why won’t my Xcelsius Dashboard USA Map show alerts?
Using the maps provided in Xcelsius/Dashboards 4.x is not difficult, but I have often seen developers forget how to set them up properly to get them to display the data and alerts because it is not the most obvious/intuitive component and also not frequently used. I finally made this cheat sheet ...
Read More »