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 #330048] 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 #339686 is a reply to message #330048] 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 #339687 is a reply to message #330048] 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 #339761 is a reply to message #330048] 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 #339762 is a reply to message #330048] 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 #344944 is a reply to message #339687] 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 #345019 is a reply to message #339762] 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 #348931 is a reply to message #339687] 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 #349007 is a reply to message #339762] 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 #349083 is a reply to message #339762] 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 #357373 is a reply to message #344944] 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 #357449 is a reply to message #345019] 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 #357524 is a reply to message #345019] 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: Thu Nov 07 05:14:43 GMT 2024

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

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

Back to the top