Search code examples
javaeclipseeclipse-pluginstrutsbirt

Joint data set limited to two tables in BIRT

I have a request that should extract data from three tables A, B, C based on two conditions, these tables A,B and C are located in the same data source.

does BIRT 3.1 supports joint data sets with more than two tables?

Otherwise, is there a way to overcome this limitation?

Solution

  • The solution for this problem is using the stored procedure query, you set your proceure with whatever sql request you want, compile it with your DBMS, and you call it from BIRT with the syntax
    call nameOfYourProceure{(?,?,?...)}
    Question marks refer to the parameters that you will pass to your stored procedure.