Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Wrong results in crosstab
Wrong results in crosstab [message #339535] Mon, 28 January 2008 13:43 Go to next message
Hans is currently offline HansFriend
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 #344715 is a reply to message #339535] Mon, 28 January 2008 13:51 Go to previous messageGo to next message
Hans is currently offline HansFriend
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 #344716 is a reply to message #339535] Mon, 28 January 2008 14:00 Go to previous messageGo to next message
Eclipse UserFriend
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 #348703 is a reply to message #339535] Mon, 28 January 2008 13:51 Go to previous messageGo to next message
Hans is currently offline HansFriend
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 #348704 is a reply to message #339535] Mon, 28 January 2008 14:00 Go to previous messageGo to next message
Eclipse UserFriend
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 #348778 is a reply to message #339535] Mon, 28 January 2008 13:51 Go to previous messageGo to next message
Hans is currently offline HansFriend
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 #348779 is a reply to message #339535] Mon, 28 January 2008 14:00 Go to previous messageGo to next message
Eclipse UserFriend
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 #356990 is a reply to message #344716] Mon, 28 January 2008 14:19 Go to previous message
Hans is currently offline HansFriend
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

Re: Wrong results in crosstab [message #357065 is a reply to message #344716] Mon, 28 January 2008 14:19 Go to previous message
Hans is currently offline HansFriend
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

Previous Topic:Wrong results in crosstab
Next Topic:Wrong results in crosstab
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 11:06:02 GMT 2024

Powered by FUDForum. Page generated in 0.04796 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly