subdataset help

[2006 JR Open Discussion]

By: Stg Unholy - stgunholy

subdataset help

2006-02-21 05:24

Hi! In my report I need to fetch a single value from a database. This value depends on parameters, used to fill report. I think that subdataset is the best way to do so. But how can I put the value of the subdataset field to the field of report. When I use standard syntax $F{filedName} the compilation error happens - Field not found...How can i get a value from a subdataset field?

 

 

By: Lucian Chirita - lucianc

RE: subdataset help

2006-02-22 09:52

Hi

 

Subdatasets are only used for charts and crosstabs. There is currently no such functionality of instantiating a subdataset and returning a value from it.

 

What you could do is to use the report scriptlet to execute the query and set the value to a variable in the report. You could also use an empty subreport to run the query and return the value, but I think it would be too much of a burden for such a task.

 

HTH,

Lucian

 

 

By: Stg Unholy - stgunholy

RE: subdataset help

2006-02-25 07:31

Thank you for your answer! I tied to use scriptlet and succeeded. But I think that it is not so clear way. The feature to populate fields from CallableStatements and so on will be very useful I think :)