Sig Figs in Business Objects

sdk development
1

Hello All,

I have a client with a couple of questions about Business Objects. Do any of you have an answer for her about the following 2 questions?

  1. Is it possible to use a Visual Basic or PL SQL program to format a result in Business Objects? If so, how?

We currently have VB code to take a number and format it to a set number of significant figures. The VB code also rounds the value, which gets tricky when sig figs are involved. Since this code already exists, it would be great if we could use it within Business Objects.

For example, if we created a report that printed our concentration field (the amount of chemical in the sample we tested), we would make the report run a VB program whenever it had to format the value in our concentration field. The VB program evaluates the number of digits and the values in each to determine how to display the value in the report.

Example - concentration field contains 1233 We want 3 sig figs
We trigger the VB program, and it returns 1230 to the report

Example 2 - concentration field contains 0.1058 We want 3 sig figs
VB program returns 0.106

  1. Has anyone written a formatting trigger or program that will display a number (value contained in a field) on a report to the number of significant figures specified by the user at run time?

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

2

I assume that your client is using BO 5.x If it’s the case, VB Macro can do the job. - From your data providor VB Macro, you can call (Via COM) your method that do the formating, we suppose that this method returns the value formatted. - then insert the value returned into a cell or column of your report(Use BO object Model to insert this value).

Hamid

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

3

Why don’t you convert your vb code to c or c++, compile and create a BO User library. That way you could use that c function in your formula editor.

  • Vasan

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