Eclipse Community Forums: BIRT » Excel Output differs from ReportViewer

Home » Archived » BIRT » Excel Output differs from ReportViewer(Wrong calculation of column value using Excel export)

Show: Today's Messages :: Show Polls :: Message Navigator

Excel Output differs from ReportViewer [message #516205]

Tue, 23 February 2010 08:29

Christian Fink

Messages: 6
Registered: November 2009

Junior Member

I'm using BIRT for creation of Excel reports.

The error occurs by defining a data field using other column bindings as source. The other column bindings are also calculated based on column bindings.

Viewing the result in the webviewer shows the expected (correct) result. But creating an Excel report leads to a wrong result. The values seem to be multiplied by a large factor.

Example:

row1 = dataSetRow['1'] = 5
row 2 = dataSetRow['2'] = 15

sum1 = row['row1'] + row['row'] = 20

row10 = dataSetRow['10'] = 2
row11 = dataSetRow['11'] = 8

sum2 = row['row10'] + row['row11'] = 10

ratio = row['sum2'] / row['sum1'] = 0.5

In Excel the value is something like 5,000,000.

The same effect occurs if calculating the ratio using aggregates as source.

Remark: The ratio field is formatted as percent.

Appreciating any help and thanks in advance.

Christian

Report message to a moderator

Re: Excel Output differs from ReportViewer [message #516278 is a reply to message #516205]

Tue, 23 February 2010 13:34

Christian Fink

Messages: 6
Registered: November 2009

Junior Member

Some additional notes:

If I change the ratio calculation in the given example to the following, it works.

Example:

ratio = (row['row10'] + row['row11']) / (row['row1'] + row['row2']) = 0.5

But this won't help me with the aggregates.

Remark: using BIRT 2.3.2.r232 (Ganymede)

[Updated on: Tue, 23 February 2010 13:35]

Report message to a moderator

Re: Excel Output differs from ReportViewer [message #516339 is a reply to message #516278]

Tue, 23 February 2010 15:59

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Christian,

Can you log a bug for this?

Jason

Christian Fink wrote:
> Some additional notes:
>
> If I change the ratio calculation in the given example to the following,
> it works.
>
> Example:
>
> ratio = (row['row10'] + row['row11']) / (row['row1'] + row['row2']) = 0.5
>
> But this won't help me with the aggregates.

Report message to a moderator