Archive for September, 2008

Extra Rows and Columns in Excel Export

Monday 29 September 2008 @ 10:53 pm

A few years ago I wrote a newsletter article related to Excel exports. I described what you should do to prevent extra rows, extra columns and merge cells when exporting to Excel from Crystal Reports. Just last week I found another piece of the puzzle that explains why my methods would occasionally not eliminate all of the extra rows. It appears that if your row of objects in the report is not at the very top of the section (position 0) then Crystal will create double rows in the spreadsheet. Even if all the objects are the same height, and all are aligned in one clean row across, a tiny space above the row of objects will export to a spreadsheet with data on every other row. Read the article above for more information on cleaning up your Crystal Reports exports.

Crystal Reports Viewer 2008

Sunday 7 September 2008 @ 5:52 pm

Speaking of viewers, Business Objects has just released Crystal Reports Viewer 2008. This is very similar to CR Viewer XI with 2 significant additions:

1) You can now use the interactive parameters and sort controls of CR 2008.
2) You can refresh reports – but only if the reports are already hosted in BO Enterprise or CR Server.

I haven’t tried it.  Nor have I explored the mechanics of how Continue Reading »
Crystal Reports Viewer 2008

New free viewer looking for user feedback

Sunday 7 September 2008 @ 2:30 pm

There is a new viewer available from Origin Software and the developer is looking for people to try it and provide feedback. The product is called the Crystal iViewer. All new users get a 45 day free trial of the full version of the software. If you decide not to purchase it after 45 days it, downgrades automatically to the ‘free’ version. This means you lose refresh capability and a few other features. Along with the ability to run reports without Crystal Reports installed you can also: Continue Reading »
New free viewer looking for user feedback

Recrystallize Pro