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; } } }

Multiple queries in Scripted Datasource

RaulGomez

Hello friends, 
 
I have a specific scenario. 
I want to show a tabular report of four columns. 
first 2 columns will contain data retrieved by one query and the other 2 columns contain data retrieved by 
another query. 
I cannot join the 2 queries. They are complex and different. 
I am also using scripted data source. 
 
So how do i achieve that since, my table in the report can be BOUND with only one dataset @ a time. 
 
N e ideas ... please suggest ! 
 
Thanks and Regards 
Omkar Patkar

Find more posts tagged with

Comments

dan3874

<blockquote class='ipsBlockquote' data-author="'RaulGomez'" data-cid="66250" data-time="1278592097" data-date="08 July 2010 - 05:28 AM">
Hello friends, 
 
I have a specific scenario. 
I want to show a tabular report of four columns. 
first 2 columns will contain data retrieved by one query and the other 2 columns contain data retrieved by 
another query. 
I cannot join the 2 queries. They are complex and different. 
I am also using scripted data source. 
 
So how do i achieve that since, my table in the report can be BOUND with only one dataset @ a time. 
 
N e ideas ... please suggest ! 
 
Thanks and Regards 
Omkar Patkar </blockquote>
Omkar, You can make two separate 2 column tables and bind each to their own source. However, you do need to be able to relate the two tables so that the rows line up appropriately. 
 
Dan