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 #330454] 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.
Re: Wrong results in crosstab [message #339836 is a reply to message #330454] 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.
Re: Wrong results in crosstab [message #339837 is a reply to message #330454] 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
Re: Wrong results in crosstab [message #345095 is a reply to message #339837] Mon, 28 January 2008 14:19 Go to previous messageGo to next 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
Re: Wrong results in crosstab [message #345170 is a reply to message #339837] Mon, 28 January 2008 14:19 Go to previous messageGo to next 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
Re: Wrong results in crosstab [message #349158 is a reply to message #339837] Mon, 28 January 2008 14:19 Go to previous messageGo to next 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
Re: Wrong results in crosstab [message #349234 is a reply to message #339837] Mon, 28 January 2008 14:19 Go to previous messageGo to next 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
Re: Wrong results in crosstab [message #357599 is a reply to message #345095] Tue, 29 January 2008 01:42 Go to previous message
Tianli Zhang is currently offline Tianli ZhangFriend
Messages: 2862
Registered: July 2009
Senior Member
Hi Hans

Where did you use the parameters? Is the result strange only in XSL and
Web Viewer and it is ok in layout preview?
Re: Wrong results in crosstab [message #357674 is a reply to message #345095] Tue, 29 January 2008 01:42 Go to previous message
Tianli Zhang is currently offline Tianli ZhangFriend
Messages: 2862
Registered: July 2009
Senior Member
Hi Hans

Where did you use the parameters? Is the result strange only in XSL and
Web Viewer and it is ok in layout preview?
Re: Wrong results in crosstab [message #357749 is a reply to message #345170] Tue, 29 January 2008 01:42 Go to previous message
Tianli Zhang is currently offline Tianli ZhangFriend
Messages: 2862
Registered: July 2009
Senior Member
Hi Hans

Where did you use the parameters? Is the result strange only in XSL and
Web Viewer and it is ok in layout preview?
Re: Wrong results in crosstab [message #357824 is a reply to message #345170] Tue, 29 January 2008 01:42 Go to previous message
Tianli Zhang is currently offline Tianli ZhangFriend
Messages: 2862
Registered: July 2009
Senior Member
Hi Hans

Where did you use the parameters? Is the result strange only in XSL and
Web Viewer and it is ok in layout preview?
Previous Topic:Wrong results in crosstab
Next Topic:Wrong results in crosstab
Goto Forum:
  


Current Time: Sat Nov 02 16:51:30 GMT 2024

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

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

Back to the top