Can I have Multiple dataset for a table?
Options
Comments
-
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
HansWarning No formatter is installed for the format ipb0 -
yes you got me right hans. thanks for reply.<br />
I tried nested tables also.. but formatting issue is dere with that.. I will try to figure it out..<br />
<br />
N Yes.. I cant join both the data set.<br />
C my requirement is quite simple.<br />
<br />
I certain accounts which contains amount transaction related to it. Each transaction has some age (i.e. since when the transaction was recorded).<br />
<br />
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. <br />
<br />
Please see the attachment for layout<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115660" data-time="1364980391" data-date="03 April 2013 - 02:13 AM"><p>
Hi Shasha,<br />
<br />
You can't bind two data sets to a table, if that is what you mean, but you can:<br />
- create a joint data set and bind the table to that one<br />
- create nested tables where you can use values of the outer table as parameters for the inner table<br />
<br />
Hope this helps<br />
Hans<br /></p></blockquote>0 -
It may sound foolish of me but i made a seperate dataset just to fetch data for previous month.<br />
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.<br />
<br />
Any other way to do it?<br />
If i wil fetch data for both month in single dataset then use some javascript to do the grouping.<br />
But i m not good in scripting. <br />
<br />
<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115662" data-time="1364986257" data-date="03 April 2013 - 03:50 AM"><p>
So you have two data sets.<br />
What data is in both of them?<br /></p></blockquote>0 -
Hi Hans thanks for your input. I already tried cross tab also..<br />
<br />
Finally i got the solution by using group aggregation and using some if else statements. <br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="115664" data-time="1364989950" data-date="03 April 2013 - 04:52 AM"><p>
Hi,<br />
<br />
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.<br />
Hope it can get you started.<br />
<br />
Regards<br />
Hans<br /></p></blockquote>0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax