Call multiple stored procedures in Studio

[julian111]

Hi Community,

thanks for reading. 

Does anyone know if it is possible to call multiple stored procedures in Jaspersoft Studio? I can call a single stored procedure via plsql but not two.

Thanks again!

[jgust]

Yes, you can but as either multiple DataSets or as a subreport.

When you create a DataSet the wizard is simple and doesn't allow you to specify the query language.  You can either create an empty one or add a temporary SQL in the wizard.

DataSet Wizard:

Once the bonus DataSet is created you can edit it and specify the plsql SQL language and update the text to the procedure call.

If you are going to use the multiple dataset route then you can use a List, Table, or CrossTab to present your data for each stored procedure.

[julian111]

Thank you!

Is there also a way to use both datasets in the same report then? When I try to pull the field from the additional dataset to the report studio just says:

Our goal is to have the column headers from the main dataset and the column content from the additional dataset or the other way around. 
 

 

[julian111]

Hey all! Can someone help here?

 

thanks!

[jgust]

You can display the fields from your datasets by using either a list, table, or crosstab.