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 #332432] 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 #340286 is a reply to message #332432] 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 #340287 is a reply to message #332432] 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 #340361 is a reply to message #332432] 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 #340362 is a reply to message #332432] 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 #345697 is a reply to message #340287] 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 #345772 is a reply to message #340287] 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 #345847 is a reply to message #340362] 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 #349912 is a reply to message #340287] 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 #349987 is a reply to message #340287] 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 #350062 is a reply to message #340362] 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 #358579 is a reply to message #345697] 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 #358654 is a reply to message #345772] 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 #358731 is a reply to message #345772] 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 #358806 is a reply to message #345847] 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 #358882 is a reply to message #345847] 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: Wed Jul 03 03:41:39 GMT 2024

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

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

Back to the top