nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT Design question- multiple sql queries in one report, one dataSet

amw2326

I'm converting an Actuate report. In the Actuate report there is a sql query in the DataStream section. There is a second MRO connection in the Fetch() method that has a second sql query. I'm trying to replicate this. What is the best way to go about it? Is there a place to run a second sql query in a BIRT report? I've never used afterOpen, beforeClose, or any of these scripts. Any help or suggestions would be appreciated. Thanks!

Find more posts tagged with

Comments

micajblock

So for every row you are doing another query? You have two choices:1. Use a joined dataset.2. Use a nested table. There should be some example on the DevShare for how to do this. P.S. There is a specific forum for Maximo BIRT questions.

amw2326

I didn't realize, thanks! It's more like, they want to run a query, then after the query is run (separate from the original query) they want to run another query. So it's not per row of the original query. I'll check out the Forum for Maximo BIRT related questions. Thanks again!

micajblock

In BIRT data sets get executed one after the other. Additionally they will be only executed if they are used. So you can simply have two tables one after the other and the datasets will be executed one after the other.

amw2326

I believe that was just what I needed to know! Thank you!