# Multiple datasets on one report **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [July 14, 2010, 10:49am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256 "2010-07-14T10:49:40Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dennis\_leary\_406](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dennis\_leary\_406](https://forums.toadworld.com/u/dennis_leary_406)\ **Post date:** [July 14, 2010, 10:49am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/1 "2010-07-14T10:49:40Z")
Can a report support multiple resultsets/datasets? I’m creating a consoldiated report that is the result of diff. queries and not sure how to get the different result sets onto a report. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [July 14, 2010, 1:49pm UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/2 "2010-07-14T13:49:09Z")
Currently the Toad Data Reports do not support multiple datasets. This is planned for our 3.0 release. For that type of report I would build an Excel report and export to different worksheets or cell locations on the same sheet. Debbie ---
**Author:** ![ccc14](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@ccc14](https://forums.toadworld.com/u/ccc14)\ **Post date:** [March 8, 2018, 10:42am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/3 "2018-03-08T10:42:06Z")
Has this functionality been made available to Toad Data Point 4.3.0.718? I have created a Toad Data Report and I am now needing to add another dataset to this same report. I am unable to figure out how to add a second dataset to the same report. Thank you, Crystal ---
**Author:** ![Jakub.Kremer](https://avatars.discourse-cdn.com/v4/letter/j/9f8e36/32.png) [@Jakub.Kremer](https://forums.toadworld.com/u/Jakub.Kremer)\ **Post date:** [March 9, 2018, 2:36am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/4 "2018-03-09T02:36:37Z")
Hi Crystal, so far i know we don’t support multiple datasets in one Data Report. Maybe the subquery is all you need. With regards Jakub.K. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [March 9, 2018, 10:09am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/5 "2018-03-09T10:09:08Z")
There are subreports but there seems to be some issues with this. Subreprots are on the Data report tool bar. You can also merge together separate reports into one report using the Toad Data report automation activity ---
**Author:** ![ccc14](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@ccc14](https://forums.toadworld.com/u/ccc14)\ **Post date:** [March 13, 2018, 1:16pm UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/6 "2018-03-13T13:16:04Z")
Thank you so much for the quick response. I have went with using subreports to accomplish what I need, however, I have run into another hurdle that I cannot figure out. I have my main report and 2 subreports in that main report. I am needing the data from second subreport to display on the first subreport if the ID that I am grouping on is the same between the two subreports, if that makes sense. For example: I have a list of charges in one subreport and a list of courses in another subreport for students with a page break between each student. I need the list of courses to display on the same page with the list of charges where the student ID is the same. Thank you, Crystal ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [March 13, 2018, 7:55pm UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/7 "2018-03-13T19:55:59Z")
In that case it sounds like you need to have two result sets that have master detail relationship. In this case i would go to Tools | Reports | Data reports. When you start from this path you enter the sql instead of loaded from a data grid. Here you can add more than one sql adn define the relationship column(s). this will load Toad Data Report with a dataset containing more than one table with relationship. you will see this looks different in the Report table/column viewer as one table will be nested inside the other. You can also add extra sql and define relationships on the Data tab in the report editor. the related tables will show in the field editor subreports are reports that are completely self contained. The above will allow for multiple result sets in the same subquery. ---
**Author:** ![elle](https://avatars.discourse-cdn.com/v4/letter/e/ccd318/32.png) [@elle](https://forums.toadworld.com/u/elle)\ **Post date:** [January 14, 2020, 8:03pm UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/8 "2020-01-14T20:03:37Z")
Hi, is there anywhere where this is documented? Ive tried doing this with no such luck. ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [January 15, 2020, 11:20am UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/9 "2020-01-15T11:20:49Z")
Hi elle, does this topic help you? ![image](https://global.discourse-cdn.com/quest/original/2X/d/d68773e69310285540c330806e2ad5d01721911d.png) ---
**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\ **Post date:** [January 15, 2020, 3:35pm UTC](https://forums.toadworld.com/t/multiple-datasets-on-one-report/6256/10 "2020-01-15T15:35:39Z")
There are also several blogs on Toad World related to Data Report in TDP. Maybe some of them should be helpful too [https://blog.toadworld.com/hs-search-results?term=Data+Report&type=SITE\_PAGE&type=BLOG\_POST&type=LISTING\_PAGE](https://blog.toadworld.com/hs-search-results?term=Data+Report&type=SITE_PAGE&type=BLOG_POST&type=LISTING_PAGE)