formatting corrupted in reports

general discussion
1

I have a user that was given a new laptop recently (He went from Win 95 to Win NT). His Business Objects reports were transferred over to the new machine. When he opened his reports he noticed that every one was affected by a formatting change: either all or some of his cells had changed from currency to percentage.

I am completely stumped here.

HELP!!!

Simon

Listserv Archives (BOB member since 2002-06-25)

2

Simon wrote:

"I have a user that was given a new laptop recently (He went from Win 95 to Win

NT). His Business Objects reports were transferred over to the new machine.
When he opened his reports he noticed that every one was affected by a formatting change: either all or some of his cells had changed from currency to
percentage.

I am completely stumped here.

HELP!!!"

You can check the columns who are now presenting a wrong format with the ‘Format Cell’ option. Click on the tab ‘Number’ and see if it is set on ‘Standard’. If so, then it is subject to regional settings on the client.

Check in the regional settings on the NT machine on the currency and number tab what could be wrong. Restart BO after a change.

Hope this helps…

Regards,

Jan Klaver

Listserv Archives (BOB member since 2002-06-25)

3

Thank you for the suggestion. (By the way the version is 4.1.5) The formatting option is not “standard” but “percentage”. Previously it was “currency”.
Simon

Listserv Archives (BOB member since 2002-06-25)

4

Check out the Regional Setting of the machine and see how the currency format is set up.

Chris

Listserv Archives (BOB member since 2002-06-25)

5

In a message dated Tue, 11 Apr 2000 10:58:08 AM Eastern Daylight Time, Simon Miller Simon.Miller@DIVERSEYLEVER.COM writes:

I have a user that was given a new laptop recently (He went from Win 95 to Win NT). His Business Objects reports were transferred over to the new machine. When he opened his reports he noticed that every one was affected by a formatting change: either all or some of his cells had changed from currency to percentage.

Was this user by any chance using “custom” formats? If you create and use custom formats, they are stored in the windows registry. And - interestingly enough - they are stored in the order that you create them. And to make matters worse, they are stored and referenced by POSITION in the registry, rather than CONTENT.

Imagine the following scenario:

Old Workstation

  1. Build a report
  2. Build a custom currency format (format #1) 3. Save the report

New Workstation

  1. Build a report
  2. Build a custom Percentage format (#1) 3. Build a custom currency format (#2)
  3. Save a report

Now, copy the report from the old workstation to the new workstation and open it. BusObj sees that - aha! - a custom format has been applied. From workstation #1, it was format #1 (currency). So, on workstation #2 it will apply - you guessed it - custom format #1, which happens to be a percentage format.

Solution: go back to the original workstation and save each report as a template. Copy the templates to the new workstation and apply them.

This was a known problem (known to me, anyway) in v4. I have not checked to see if it is still present in v5.

On the other hand, if your user has not used any custom formats, then this is not your problem.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)