Reference fields from custom datasets

[denzildsouza555]

Hello,

I need to execute multiple queries and compare their results at the end.

I made multiple datasets in my report for it with the different queries.

But I am unable to use the fields in my report.

for instance I have a dataset created orders what has a field order_id. I try to use this field by using $F{orders.order_id}. I report doesn't recognize this.

Appreciate any assistance.

Thanks.

 

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[accounts_8]

I think your syntax is wrong. $F{orders.order_id} looks for a field called "orders.order_id". When you pass a Datasource to a (Sub-)Report, you have to create a field called "order_id" and call $F{order_id}. Jasperreports gets the data by calling

public Object getFieldValue(JRField jrField) throws JRException from JRDataSource

[rpachipu]

In studio, you cannot use a dataset fields directly into the main report. You can use Dataset fields,  if your main report has a list, table or sub-reports.  If you want to compare the results of datasets. There are two ways. 

1. writing a scriptlet 

2. Handling at the query itself.

3. using return variables from each dataset element and compare the values.

Hope this help you.

[denzildsouza555]

Hello rpachipu,

Thanks for your explanation.

The main issue that I face is that my dataset queries that I use to execute and print data in tables have parameters to be passed which I am taking from the main report.

How can I reference those parameters while executing the query for my table dataset ?

Thanks.

[rpachipu]

You pass the main report parameters to table dataset as shown below: