Can I have Multiple dataset for a table?

Hi.

I am having a report where i need to fetch few columns in a table based on parameters passed from two different data sets.

Find more posts tagged with

Comments

Hans_vd

Hi Shasha,

You can't bind two data sets to a table, if that is what you mean, but you can:
- create a joint data set and bind the table to that one
- create nested tables where you can use values of the outer table as parameters for the inner table

Hope this helps
Hans

Shasha

yes you got me right hans. thanks for reply. 
I tried nested tables also.. but formatting issue is dere with that.. I will try to figure it out.. 
 
N Yes.. I cant join both the data set. 
C my requirement is quite simple. 
 
I certain accounts which contains amount transaction related to it. Each transaction has some age (i.e. since when the transaction was recorded). 
 
If i will select the parameter as february month then it should fetch me result only for that month. But the catch is here in table i have to show data in some columns for previous month also. 
 
Please see the attachment for layout 
 
 
<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115660" data-time="1364980391" data-date="03 April 2013 - 02:13 AM">
Hi Shasha, 
 
You can't bind two data sets to a table, if that is what you mean, but you can: 
- create a joint data set and bind the table to that one 
- create nested tables where you can use values of the outer table as parameters for the inner table 
 
Hope this helps 
Hans </blockquote>

Hans_vd

So you have two data sets.
What data is in both of them?

Shasha

It may sound foolish of me but i made a seperate dataset just to fetch data for previous month. 
same query just month parameter value will be different in both dataset queries.. So now i will have two data set with data for 2 different months. 
 
Any other way to do it? 
If i wil fetch data for both month in single dataset then use some javascript to do the grouping. 
But i m not good in scripting. 
 
<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115662" data-time="1364986257" data-date="03 April 2013 - 03:50 AM">
So you have two data sets. 
What data is in both of them? </blockquote>

Hans_vd

Hi,

I created a very simple sample report that shows how you can use a crosstab to combine data from current and previous month in one row.
Hope it can get you started.

Regards
Hans

Shasha

Hi Hans thanks for your input. I already tried cross tab also.. 
 
Finally i got the solution by using group aggregation and using some if else statements.

<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115664" data-time="1364989950" data-date="03 April 2013 - 04:52 AM">
Hi, 
 
I created a very simple sample report that shows how you can use a crosstab to combine data from current and previous month in one row. 
Hope it can get you started. 
 
Regards 
Hans </blockquote>