by admin | 
Problem: “I get the following message “Data has been Truncated” when I click to ‘Preview’ dashboard in Crystal Xcelsius. How can I make this go away?
Solution: Increase the Maximum Number of Rows in Crystal Xcelsius.
Note: Business Objects recommends not to exceed 512 rows, however we have increased this number up to 5000 and our models worked fine!
Using Xcelsius 2008:
1. Go to File -> Preferences
2. In Preferences -> ‘Excel Options’ (Change ‘Maximum Number of Rows’)
Using Crystal Xcelsius 4.5:
1. Go to Data -> Maximum Number of Rows (Change ‘Maximum Number of Rows’)
Like what you see here? Leave a comment or share this article with others who may be interested (click below)!
Current Highest Rated Post
- Video: Show Chart Values without Hovering
(5.00 out of 5) - Pictures from the Xcelsius Community Event at GBN 2009 (5.00 out of 5)
Interested in hiring one of our Gurus? Need help training your staff? Not sure where to start building your dashboard? We can help. Contact us to find out more!
Categories
Tags
About Us
Subscribe
English
Hi Xcelsius,
I even put my max on 2000, because my im using report with 200 records in it.
But when opening dashboard i see,its still using only 512 rows.
I check this to add a count in excel to check the number of rows when report is loaded in dashboard
Hopefully you can help me.
Sounds a bit buggy.
Sorry to say but have you tried an install?
Mico
Hi Xcelsius,
I tried to increase the number of rows allowed to 2000, but when I try to preview the report, I get the message (sorry about the translation): “error in creating WSF”. Do you know how I fix this?