Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to decode column value ?
How to decode column value ? [message #662559] Thu, 31 March 2011 06:40 Go to next message
KrasiG is currently offline KrasiG
Messages: 3
Registered: July 2009
Junior Member
Hi Forum,,
I'm new in birt and mауbe this is a trivial question but I can't find the answer.

So, I have Data Set like this:
SELECT col1, col2 , col3
FROM myTable.

where col1, col2 , col3 are integers and with join with another tables this values must be decoded to see the text.

I know two way to approach the task:
1. to create many joins in select
2. to create many birt Joint Data Sets - this is a foolish decision=

So is there some way to do this dynamically? Something like MAP but using Data Set
Re: How to decode column value ? [message #662699 is a reply to message #662559] Thu, 31 March 2011 15:34 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I am not certain I understand what you need, but if its a map why not
use the map on the table or report item that displays the data? You
could also create a computed column on the dataset that checks the value
of another column and returns a value based on it.

Jason

On 3/31/2011 2:40 AM, KrasiG wrote:
> Hi Forum,,
> I'm new in birt and mауbe this is a trivial question but I can't find
> the answer.
>
> So, I have Data Set like this:
> SELECT col1, col2 , col3
> FROM myTable.
>
> where col1, col2 , col3 are integers and with join with another tables
> this values must be decoded to see the text.
>
> I know two way to approach the task:
> 1. to create many joins in select
> 2. to create many birt Joint Data Sets - this is a foolish decision=
>
> So is there some way to do this dynamically? Something like MAP but
> using Data Set
Previous Topic:Report Problem
Next Topic:Transform table
Goto Forum:
  


Current Time: Fri Oct 31 22:24:42 GMT 2014

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

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