Problems with dynamic text

Hi,

I want to insert a dynamic text with a table item report. I have generated a table like this:

Type | Value

T1 | V1
T2 | V2
T3 | V3
SUM | VSUM

in my report I need to writte the percent of each of the values and I do this scripts in the dynamic text:

if ((row["type"] == "T1")) { ((row["Value"]*100)/row["VSUM"]) }

I get correctly this value but when I try this for the second row I dont obtein anything

Thanks!

María

Find more posts tagged with

Comments

mwilliams

Hi María,

So, you're wanting something that looks like:

Type | Value | Percent

T1 | V1 | P1
T2 | V2 | P2
T3 | V3 | P3

SUM | VSUM

Or are you wanting something else?

mgranadino

I need percent but not in the table. I want to write the text of the report using this value.

could you help me?

mgranadino

Is something that this:

I have a table in my report:

Type | Value

Fund 1.123.999
Bond 3.245.000
...

Total 8.353.000

Then, I need to comment the table with the percent of each type. "The bond is a 38'84% of the total"... I do this with a dynamic text but I cant get the value (3.245.000) because is the second row of the table..

mwilliams

María,

Will you know all the different "Types" from the table? If so, you could just use persistent global variables to store the value under the name of the type. This way, it won't matter what order the types are in, you'll always grab the correct value in your dynamic text box.

mgranadino

Hi,

I know all the different "Types" from the table, but if we try to access doing:

"if ((row["Types"] == "Bound")) { row["value"] }"

for the table:

Types | Value

Fund | 7,6
Bound | 5,4
....

Total 30,25

I get 7,6 instead 5,4 (Bound's value)

mwilliams

María,

What I was saying was that if you know all the "types", you could easily set all the "values" as variables to pass to your dynamic text boxes. I can probably come up with a simple example if you need one. Just let me know.