Rounding when Exporting to Excel

When you use the rounding feature in Crystal Reports you generally do so, as follows:
(Right Click on the Field > Format Field > Number > Customize)

You can select the number of decimal places to which you wish to Display in the Report.

However, When you export this to excel you will still get the full Value.

For example. If the Value was 56.76999999
And you have select to round to 2 Decimal places.
The Report will display 56.77

However when you export, the field will be 56.76999999

If you would rather have the export to excel match the report.

Simply add a formula which performs the rounding.

Round({Table1.Fieldname1},2)

This will mean when you export. The Excel Field will match the Value Displayed in the Report.

 

BI4 OpenDocument Null Parameter

With the release of BI4 there have been a few changes to the structure of OpenDoc URLs in business Objects 4.0. 

Crucially a lot of people would need to pass Null Value into a report for a required parameter. This used to be just a case of entering no value or the text Null, but that no longer seems to work in BI4. 

To get around this, you can now pass the ASCII Value %00 instead of Null.

For Example 

&lsSProductName=%00

Perhaps this will change in the future, but for now this has worked.