Eclipse Community Forums: BIRT » Wrong results in crosstab

Help

Home

Home » Archived » BIRT » Wrong results in crosstab

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

Wrong results in crosstab [message #337209]

Mon, 28 January 2008 13:43

Hans

Messages: 2662
Registered: July 2009

Senior Member

Hi people,

I have a crosstab that shows some summarized fields, (A, B, C), when I
preview the results (at preview's tab), all goes fine, but viewing the
results in xls or web viewer, it results in strange data. The C field
shows strange numbers, very very big numbers. I have tried with a new
report file, but happens the same problem.

Any ideas?

Thanks,
Hans.

Report message to a moderator

Re: Wrong results in crosstab [message #341637 is a reply to message #337209]

Mon, 28 January 2008 13:51

Hans

Messages: 2662
Registered: July 2009

Senior Member

I forgot to add that I have two crosstabs. The problem happens sometimes
in first crosstab and other times it happens in the second crosstab

Hans escribió:
> Hi people,
>
> I have a crosstab that shows some summarized fields, (A, B, C), when
> I preview the results (at preview's tab), all goes fine, but viewing the
> results in xls or web viewer, it results in strange data. The C field
> shows strange numbers, very very big numbers. I have tried with a new
> report file, but happens the same problem.
>
> Any ideas?
>
> Thanks,
> Hans.

Report message to a moderator

Re: Wrong results in crosstab [message #341638 is a reply to message #337209]

Mon, 28 January 2008 14:00

Eclipse User

Originally posted by: tigeleo.yahoo.com

Hans ?????:
> Hi people,
>
> I have a crosstab that shows some summarized fields, (A, B, C), when
> I preview the results (at preview's tab), all goes fine, but viewing the
> results in xls or web viewer, it results in strange data. The C field
> shows strange numbers, very very big numbers. I have tried with a new
> report file, but happens the same problem.
>
> Any ideas?
>
> Thanks,
> Hans.
May be you display rowid or time in milliseconds

Report message to a moderator

Re: Wrong results in crosstab [message #347499 is a reply to message #341638]

Mon, 28 January 2008 14:19

Hans

Messages: 2662
Registered: July 2009

Senior Member

Nope, and after a many crazy things, I can fix the problem. The solution
was to change all the report parameters to String. I've never had this
problem with crosstabs, indeed, I've worked with a template with the
same report parameters and same crosstabs, it's the first time that I
see this strange behaviour. Could be a bug?

Thanks,
Hans.

tigeleo escribió:
> Hans ?????:
>> Hi people,
>>
>> I have a crosstab that shows some summarized fields, (A, B, C),
>> when I preview the results (at preview's tab), all goes fine, but
>> viewing the results in xls or web viewer, it results in strange data.
>> The C field shows strange numbers, very very big numbers. I have tried
>> with a new report file, but happens the same problem.
>>
>> Any ideas?
>>
>> Thanks,
>> Hans.
> May be you display rowid or time in milliseconds

Report message to a moderator