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!