Call multiple stored procedures in Studio

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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!

julian111's picture
Joined: Aug 25 2021 - 12:15am
Last seen: 1 day 3 hours ago

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

jgust - 2 weeks 1 day ago

3 Answers:

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.

jgust's picture
1618
Joined: Jun 10 2010 - 6:39am
Last seen: 1 hour 20 min ago

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's picture
Joined: Aug 25 2021 - 12:15am
Last seen: 1 day 3 hours ago

Hey all! Can someone help here?

 

thanks!

julian111's picture
Joined: Aug 25 2021 - 12:15am
Last seen: 1 day 3 hours ago
Feedback