Eclipse Community Forums: BIRT » Assigning a variable to a specific data

Home » Archived » BIRT » Assigning a variable to a specific data(data validation / data assignment)

Assigning a variable to a specific data [message #793226]

Tue, 07 February 2012 17:43

Eclipse User

Hello,

Can BIRT assign a data point or a data array (obtained from SQL dataset) to a global variable that can be accessed throughout the report?

for example, suppose I have the following data set:
----------------
| NAME | VALUE |
----------------
|JOHN | 4 |
----------------
|MARY | 8 |
----------------
|KATE | 0 |
----------------

Can I assign a value of zero associated with 'KATE' programmatically (x = 0)?

Thanks in advance,

Re: Assigning a variable to a specific data [message #793408 is a reply to message #793226]

Tue, 07 February 2012 23:43

Eclipse User

There are a lot of ways to do this in BIRT. It can be done in Java or
JavaScript. You can event create and use a Java HashMap from JavaScript
events. In this case a simple javascript array will probably do what
you want. Have a look at the attached example. A hidden table is used
to fire an oncreate event that loads a js array which is then used by a
scripted data set for a second table.

Jason

On 2/7/2012 5:43 PM, andrew smith wrote:
> Hello,
> Can BIRT assign a data point or a data array (obtained from SQL dataset)
> to a global variable that can be accessed throughout the report?
>
> for example, suppose I have the following data set:
> ----------------
> | NAME | VALUE |
> ----------------
> |JOHN | 4 |
> ----------------
> |MARY | 8 |
> ----------------
> |KATE | 0 |
> ----------------
>
> Can I assign a value of zero associated with 'KATE' programmatically (x
> = 0)?
>
> Thanks in advance,

Attachment: jsarray.zip
(Size: 2.72KB, Downloaded 319 times)

Previous Topic:	How To Add Text To Group Header
Next Topic:	birt view localization problem

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 15:20:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter