Get Column values in Text Report Item

Hi,

I have a table with 4 columns.
First column, I have used a text as I need HTML.

I would like to get the value of the 2nd column (in the same row). How do I get that? I have tried row[1] and row['city'] but they don't work.

Thanks in advanced.

Find more posts tagged with

Comments

mcremer

<blockquote class='ipsBlockquote' data-author="'pooh'" data-cid="80844" data-time="1312191463" data-date="01 August 2011 - 02:37 AM">
Hi, 
 
I have a table with 4 columns. 
First column, I have used a text as I need HTML. 
 
I would like to get the value of the 2nd column (in the same row). How do I get that? I have tried row[1] and row['city'] but they don't work. 
 
 
Thanks in advanced. </blockquote>
 
Hi Pooh, 
 
Sorry your question isn't really clear. 
 
But if you wanna combine data columns. You can create a new DataBinding with your own preferense by draging a data object to the table.

pooh

Hi,

Thanks for the reply.
Let me try to explain it better.

I have a table with 3 columns.
First column, I have inserted a TEXT as I need HTML capabilities.
Second and third column are data retrieved from the Datasets.

So example :
No | City | Name
X | Georgetown | Celious

In the first column (where I have displayed X), I would like to get "City" Value through my Text Report Item.
I tried row[0] or row["City"], but both failed to get me the value

mwilliams

To get a report binding in a text box, you need to use the value-of tag, like:

<value-of>row["myField"]</value-of>

pooh

helo,

i tried doing that(<value-of>row["industry_name"]</value-of>), however I got this error :

Errors in Report
Line 771: The value of the property "Value expression" is required.

mcremer

<blockquote class='ipsBlockquote' data-author="'pooh'" data-cid="80856" data-time="1312203833" data-date="01 August 2011 - 06:03 AM">
Hi, 
 
Thanks for the reply. 
Let me try to explain it better. 
 
I have a table with 3 columns. 
First column, I have inserted a TEXT as I need HTML capabilities. 
Second and third column are data retrieved from the Datasets. 
 
So example : 
No | City | Name 
X | Georgetown | Celious 
 
In the first column (where I have displayed X), I would like to get "City" Value through my Text Report Item. 
I tried row[0] or row["City"], but both failed to get me the value </blockquote>
 
 
Okey, Still not completely clear what you want. But I want to point out that for HTML options you can use the Text item from your palette were you can use the Text item where you can use REAL HTML code etc. 
 
Eny how you could write a script like the folowing: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
switch(dataSetRow["No"]) {
case 'X':
dataSetRow["City"];
break;
case 'Y':
dataSetRow["Name"];
break;
default :
'';
}
</pre>
 
If this doesnt help I sugest making a example report based on the inbedded databse of the BIRT engine so we can do this trough an example. Becouse your question is still not compleetly clear to me.

mwilliams

Are you sure the error is happening because of this text box? Do you have an empty text or dynamic textbox in your report? If you do, this error could be because of that.

pooh

Hi,

I have got it.

I need to change Dynamic Text in the drop-down, before inserting <value-of>row["industry_name"]</value-of>

Thanks alot guys!