Jump to content
Changes to the Jaspersoft community edition download ×

subdataset help


Recommended Posts

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 :)

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...