Jump to content
Changes to the Jaspersoft community edition download ×

Multiple dataset integration


adriano.agri

Recommended Posts

Hi.. i am using jasperstudio 6.6.0

I need to create a report that retrieve datas from a postgres database using as source filter a csv file.

so I made two dataset, the first which have as source the db connection (dataset1), and the second which have as source the xml dateset created by reading the csv file (dataset2)..

what i need is to have a query like this:

"select d2.*,d1.* from <dataset2>as d2 join <dataset1.mytable> as d1 on d1.id=d2.id"

 

Now how can i refer the dataset directly in the sql quuery, or how can i pass the value throught params/variables?

thanks..

 

 

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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...