Solved

crystal reports vs crystal dashboard tool (SQL Server)

Posted on 2013-10-29
5
1,678 Views
Last Modified: 2013-11-04
Hi folks,

I am sure you guys get this question a lot but I am trying to understand what is the best way to utilize crystal dashboards( currently have xcelsius but are upgrading soon). We want to be able to create dashboards for management but I am unsure of the best approach. We are currently using MS SQL server.

Here are my questions:

It is in my understand that Xcelsius/dashboards does NOT connect directly to SQL server. Please confirm this
Crystal reports is more of a reporting tool and dashboards is more of a KPI view of the business. The problem is dashboards is very 'excel based from what I know' I would rather assign variables and connect it to a table with some variables.
If you can't connect it what are some other options to get sql data fed through crystal reports and then ultimately to crystal dashboards.


I know these questions are not very organized but I am at the end of my rope on how crystal dashboard works. I am very familiar with crystal reports.

any help would be great!
0
Comment
Question by:gilweber3
  • 2
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 39609501
Xcelsius was, I believe, limited to use with Excel.

The new version has its own spreadsheet tool embedded and can use other datasources.  It is intended to be used with a universe but it can connect directly to other data sources.

Here is  a link to the SAP/Crystal for Dashboards knowledge base.
Apparently you cannot connect directly to MS SQL but have to go through a universe, a web service or XML

http://scn.sap.com/message/14363249#14363249

mlmcc
0
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 250 total points
ID: 39610923
>>Xcelsius was, I believe, limited to use with Excel.
maybe a very long time ago.

I use Xcelcius and the data is supplied by queries from either Oracle of MS SQL  via xml and not requiring a universe. One 'difficulty' is the designer is 'off-line' and uses its internal spreadsheet as source which make it a little cumbersome at that point. We also have deployment issues getting the right files into exactly the right place; another 'difficulty' but both can be overcome.

Our direction is html5 due to its broader mobile appeal and use of Xcelcius for me is decreasing. I haven't yet seen or looked at Crystal Dashboards.

{+edit: clarify the xml path}
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39611399
I believe the new Dashboards is headed to HTML5

mlmcc
0
 

Author Comment

by:gilweber3
ID: 39611401
Paul,

I think you are correct, unfortunately I am not a 'programmer' I know sql and some crystal but I have not messed with XML much. Not sure if this is something I should invest time in to learn.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39612744
I should add my involvement with Xcelsius is mostly solution design, others do the needed  technical work. Unable to say if you should or shouldn't get involved in XML/Web Services.

Pleased to hear they are heading toward html 5.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now