Back to the Newsletter page

The Repository from The Ablaze Group, Inc.

February 2008

News
Welcome to our newsletter!
The Repository comes out every 6 - 10 weeks. You'll find Business Objects/Crystal Decisions tools tips and tricks, news about Crystal Reports and Crystal Reports Server, Crystal Xcelsius, BusinessObjects Edge/Enterprise. Check our Promotions section for upgrades, implementations and training. This month's highlights:
  • I Didn't Know... - your Crystal knowledge resource. This time we answer a subscriber's timely question. Look for tips and tricks from Crystal Reports Professional Results.
  • SAP Acquisition of Business Objects Final - George Peck comments. Read more in our News section.
  • Crystal Xcelsius - What Is It, Who Uses It, and Why? - See our Promotions section.

Questions and suggestions? email us - we look forward to hearing from you.
Visit our newsletter archive for past issues.

I Didn't Know...

... how to Group Sort conditionally, ascending or descending, based on a parameter, and using Crystal Reports v10. Nick Reyes, Orange County, CA.

The first answer:

  • Upgrade to XI or 2008! These versions have a conditional formula button available for Group Sort direction.

If this isn’t practical, then there’s a more involved workaround:

  1. Create a parameter prompting for Ascending or Descending group sort order.
  2. Create two formulas: one returns the desired database field if the parameter is “Ascending” and some fixed value (like an empty string) otherwise, and one returns the desired database field if the parameter is “Descending” and some fixed value (like an empty string) otherwise.
  3. Create two groups: one based on the first Ascending formula (the group should be in ascending order), and one based on the second Descending formula (the group should be in descending order).
  4. Conditionally suppress the group header and footer of each group so that only the appropriate group appears based on the chosen parameter value.

Go ahead, try and do this with Reporting Services!

Tips and tricks are brought to you by Crystal Reports Professional Results and you, our readers. You can win a copy of Crystal Reports Professional Results or Crystal Reports: The Complete Reference and see YOUR name here. How? Just email your favorite Crystal tip, trick or technique. If it's selected we'll include it and your name in the next release of The Repository and we'll send you a copy of either Crystal Reports Professional Results or Crystal Reports: The Complete Reference.

email your favorite Crystal tip, trick or technique.

News

SAP Acquisition of Business Objects Final
by George Peck
As you may have heard, the latest consolidation in the Business Intelligence software industry is a done deal. SAP’s acquisition of Business Objects was finalized in mid-January. This, combined with IBM’s acquisition of Cognos, signals the last probable major BI consolidation, as there don’t appear to be any significant BI small fry left that haven’t already been swallowed by a big fish. What will concentrating major BI power in the Oracle-Microsoft-IBM-SAP quadrangle mean to customers? Well, time will tell. But, I think one can probably expect the most immediate result to be higher pricing. Despite the free-market crowd’s touting of consolidation/merger as the way to ensure better competition, one can’t help but conclude that fewer players mean more concentrated, if not less, competition overall. Upward pricing is almost always the first result. In terms of product innovation and customer service changes on the horizon, again, time will tell. While Business Objects service and support have generally been seen as eroding over the last several years, SAP's immediate direction of leaving Business Objects as a separate operating entity may not immediately affect this area. However, large consolidations are often predicated on “eliminating excess and duplicative resources” (read: firing lots of people), so one might also expect eventual consolidations of support teams, with resulting “adjustments” of service levels. The most notable immediate impact: former BusinessObjects.com e-mail addresses now appearing as SAP.com. Longer term effects: we’ll see over the coming months.

We welcome your comments - email them to us!

Promotions

Crystal Xcelsius - What It Is, Who Uses It, and Why?

Crystal Xcelsius - What Is It?
Crystal Xcelsius Standard is what you use to create dashboards from your Excel spreadsheet. Simple, straightforward steps allow you to quickly turn rows and columns into dials, charts, and lines. Add a slider - now you can show "What if?" scenarios. "OK", you say, "I want to drill-down on that dashboard for details." Crystal Xcelsius Professional has drill-down capabilities. "Great!" you shout, "I want to use LIVE data sources for my dashboards." No problem, Crystal Xcelsius Workgroup has the ability to access data via Query as a Web Service (QAAWS) data sources. While this is a different access method than traditional ODBC or OLE DB connections, you can base your dashboards on real-time data.
Three very brief examples were given here, chosen from a list of features for each version. Please give us a call for more details.

Crystal Xcelsius - Who Uses It and Why.
Who uses Xcelsius? Decision-makers: analysts, managers, CEOs, COOs, CTOs, CIOs, YOU - if you use Microsoft Office, Excel, or show a spreadsheet in PowerPoint. Anyone who wants their information visualized, in a quick at-a-glance format. Technically savvy BI professionals know that it's key to use the latest tools to deliver information faster, better.
Why Xcelsius? Colorful, Credible, Compelling Content. Images are easier to understand than rows and columns. "What if?" scenarios, shown right before your eyes, leave longer-lasting impressions. Attractive graphs, charts, dials, the ability to show possible trends, with your organization's real-time data - are an unbeatable and convincing combination. Xcelsius presentations will be awarded "Best In Show" for delivering the facts, demonstrating possible trends.

Next time we'll take a look at Webi.

Do you want to learn more about, or buy Crystal Xcelsius? Call 800 773 3472 or email us.

The Ablaze Group, a Business Objects Crystal Partner, Sales & Support

  • Crystal Reports
  • Crystal Reports Server
  • BusinessObjects Edge
  • BusinessObjects Enterprise
  • Crystal Xcelsius
Call 800 773 3472 or email for pricing and details.

Monthly Online Learning
Log On...Learn...LIVE!


2008

Crystal Reports/Xcelsius Track

  • Basic Xcelsius Dashboard Design
  • Crystal Reports 2008 Cross-Tabs
  • Ask Anything Crystal!
  • Xcelsius QAAWS Data Access
  • Report Performance Fine Points
  • Crystal Reports 2008 Flash/Xcelsius Integration
  • Subscribers are invited to suggest topics

BusinessObjects Enterprise/Edge Track
  • Introduction to BusinessObjects Edge
  • Universe Design
  • Web Intelligence Overview
  • Data Integrator
  • Enterprise/Edge Administration
  • Enterprise/Edge Architecture
  • Subscribers are invited to suggest topics
Test-drive a demo session.
Call 800 773 3472 for details and to enroll.

Training - Onsite and Online Look at our course outlines.

Consulting - Buy It By the Block!
Onsite and Remote
consulting packages.

Call 800 773 3472 or email for training and consulting information.

 


About The Ablaze Group, Inc.
Consulting
Training
Books
Web Site
The Ablaze Group offers consulting and training for Crystal Reports and Crystal Reports Server/BusinessObjects Enterprise. Our staff can help you design and develop reports, distribute reports via the Web, and integrate it all into your company's Web site or intranet. And we can also show you how to do it with our customizable on-site training classes. Just let us know how we can help.

Back to the Newsletter page

Copyright