I have Oracle database and i want to build xcelsius dashboards using crystal reports. Suppose i have 10,000 rows and 100 dealers in the oracle database using crystal reports i will load them into xcelsius but i need to display first 3 rows of each dealer in my dashboard.How can we do that ???
nrkc99 (BOB member since 2010-12-20)
If you load 10,000 rows into xcelsius it will probably fall over and die! Do as much processing as you can oustide of xcelsius - create aggregate tables for your dealers and write your queries to pull data from here.
Debbie
Debbie 
(BOB member since 2005-03-01)
Can you explain step by step how can i create aggregate tables for the dealers and pull the whole data from crystal reports to Xcelsius.
nrkc99 (BOB member since 2010-12-20)
Aggregate tables are created at database level by your DBA. I don’t use Crystal so can’t help there, I’m afraid.
Suggest you read this forum and/or buy a book. Come back with any specific questions and I’m sure people on here can help.
Debbie
Debbie (BOB member since 2005-03-01)