How to access value of field from another data source (JSON) in JasperReports?

Question

I'm using TIBCO Jaspersoft® Studio 6.3.1 final. I'm trying to create a report using two datasources (the format is JSON).

The structure of JSON is like:

{    
    "first":
        {"parameter1" : 123},
    "second":[
        {"key" : 1},
        {"key" : 2}
    ]
}

So I have two datasources. One for the first object (firstSource) and another (secondSource) for second object (array of objects).

The array (second) is printed in the table component. I'd like to access a field from first object (first.parameter1) and print it in the table header.

The table is using this dataset:

Then I'm printing its fields using $F{key}.

Do you know how can I access the parameter1 of the first object from table? Maybe using some sort of $V{} variable or merging both datasources?

I tried to use subDataSource and subDataSet approach without any luck.

Here's something I'd like to achieve in the result table:

Petter Friberg · Accepted Answer

Let me start with saying that json structure that you have in question is not the best structure to dynamically handle your expected output, it would have been better if parameter1 was actually inside the second node, see this How to create multiple tables in jasper report using json as a datasource? for how you could have handled and access the nodes if this was the case.

Anyway

Yes you are right in jasper reports you should think by datasource. In your expected output you basically have 2 datasources second which is your table and first which is your header. Yes first is only 1 record but to access it you can create a datasource for it and then use a component or a subreport to display it.

Considering this, one solution to your problem would be

Create a dataset for the table (field is key), passing as datasource the second node
Create a dataset for the header (field is parameter1), use this dataset in table to show the value.

Example

Notes:

In DatasetMain I create a parameter so I can access the report main datasource (the whole json file) again this time inside the table and create the new subDataSource for first
In the header I use a jr:list component to display the value of my second datasource (parameter1), you could also use a simple subreport to extract this value.

Output (using json provided in question)

How to access value of field from another data source (JSON) in JasperReports?

Answers (1)

Related Questions