How to Access mutiple datasets in a data field??

Hello guys,

I am new to this forum,i am currently working on BIRT Report designer.
I have some queries hope you will help me out of this.
i need to know how do i access data from different data sets in a single data field.
The problem is, a data field is bounded to one data set,so when i specify the data from other data set i says not found or something...

Find more posts tagged with

Comments

mwilliams

Hi havyascv,

Can you describe exactly what you're trying to do? Maybe I can offer a suggestion on how to do it. Let me know.

havyascv

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66389" data-time="1279054933" data-date="13 July 2010 - 02:02 PM">
Hi havyascv, 
 
Can you describe exactly what you're trying to do? Maybe I can offer a suggestion on how to do it. Let me know. </blockquote>
Hello, 
I am building a report which access a databases from which data is accessed by stored procedures in forms of various data sets. 
Now,if i need these data to be put in a table,from multiple data sets. 
how can a table access mutiple data sets,bcoz it can be bound to a single data set

mwilliams

One quick question before we go further into this. Do your dataSets have common keys on which you could join them using joint dataSets? This way you'd have a dataSet with all the values in it to be able to bind to the data element.

havyascv

No, that approach is not advisible in our case.I had thought of it earlier to join the datasets but that is not advisible.I need to access data from seperate data sets.Just tell me if there is a way in which i can bind a particular table or grid to multiple datasets.

thuston

You can put a table/grid inside another.

Then from the inner you can refer to the Outer row.
row._outer["T1Col1"] + row["T2Col1"]

LeinadJan

<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="66465" data-time="1279209977" data-date="15 July 2010 - 09:06 AM">
You can put a table/grid inside another. 
 
Then from the inner you can refer to the Outer row. 
row._outer["T1Col1"] + row["T2Col1"] </blockquote>
 
Oh that is nice to know.

havyascv

Hey thank you guys....thanx for your replies...now i am able to implement wat i needed...

Manisha P

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66425" data-time="1279122841" data-date="14 July 2010 - 08:54 AM">
One quick question before we go further into this. Do your dataSets have common keys on which you could join them using joint dataSets? This way you'd have a dataSet with all the values in it to be able to bind to the data element. </blockquote>
 
 
Hi I am using 2 different Dataset to generate report 
1) MSSQL

2) HBASE

i am creatubg bew join data set using above 2 . i am doing left outer of HBASE => MSSQL on pid 
 
so i need to group results from both dataset. I don't want to use in built grouping feature for some reason. So is there any way that in HBASE - open , fetch or on fetch method i can access MSSQL database using scripting? 
 
like while i am itrating HBASE rows guess pid = 234 i want all the result from MSSQL having pid = 234. 
 
i hope i exaplained well. 
 
Thanks 
M

mwilliams

If in your design, you put a text box that is bound to your MSSQL dataSet, then put a table bound to HBASE, you might be able to store the values from MSSQL into arrays or a hashmap in the onFetch method of the MSSQL dataSet and then search these in the fetch of the HBASE scripted dataSet since the MSSQL dataSet will have already run before the HBASE one is accessed. An easier option might just be to embed the MSSQL table inside the HBASE table. Then, like in the post above you can access the outer table's data using the expression builder.

Hope this helps.

Manisha P

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="79270" data-time="1309296222" data-date="28 June 2011 - 02:23 PM">
If in your design, you put a text box that is bound to your MSSQL dataSet, then put a table bound to HBASE, you might be able to store the values from MSSQL into arrays or a hashmap in the onFetch method of the MSSQL dataSet and then search these in the fetch of the HBASE scripted dataSet since the MSSQL dataSet will have already run before the HBASE one is accessed. An easier option might just be to embed the MSSQL table inside the HBASE table. Then, like in the post above you can access the outer table's data using the expression builder. 
 
Hope this helps. </blockquote>
 
 
Hi Thanks for your quick reply. 
 
But i don't want to put MSSQL text box . Then how can i access MSSQL data set in HBASE event method? 
 
Thanks

mwilliams

Take a look at the example in this forum post:

http://www.birt-exchange.org/org/forum/index.php/topic/22661-pivoting-a-dataset-after-aggregation/

It shows how data from one dataSet or table can be captured in an array and then used in a scripted dataSet. This is what I mean.

Manisha P

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="79270" data-time="1309296222" data-date="28 June 2011 - 02:23 PM">
If in your design, you put a text box that is bound to your MSSQL dataSet, then put a table bound to HBASE, you might be able to store the values from MSSQL into arrays or a hashmap in the onFetch method of the MSSQL dataSet and then search these in the fetch of the HBASE scripted dataSet since the MSSQL dataSet will have already run before the HBASE one is accessed. An easier option might just be to embed the MSSQL table inside the HBASE table. Then, like in the post above you can access the outer table's data using the expression builder. 
 
Hope this helps. </blockquote>
 
Hi , 
Thanks for the reply. How can i store values in HashMap in OnFetch method of MSSQL dataset ? 
 
Thanks 
M

Manisha P

<blockquote class='ipsBlockquote' data-author="'Manisha P'" data-cid="79433" data-time="1309459070" data-date="30 June 2011 - 11:37 AM">
Hi , 
Thanks for the reply. How can i store values in HashMap in OnFetch method of MSSQL dataset ? 
 
Thanks 
M </blockquote>
 
Hey . i got how to take it . using row['columnname']; 
 
Thanks

mwilliams

Awesome! Glad you got it. Let us know whenever you have questions!

Manisha P

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="79439" data-time="1309465915" data-date="30 June 2011 - 01:31 PM">
Awesome! Glad you got it. Let us know whenever you have questions!

</blockquote>
 
Hi , 
 
Many Thanks. I sorted out my whole issue. Thanks for your help so far