# Updating Toad report datasets **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [September 20, 2010, 9:53pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326 "2010-09-20T21:53:28Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![fabricator\_296](https://avatars.discourse-cdn.com/v4/letter/f/d78d45/32.png) [@fabricator\_296](https://forums.toadworld.com/u/fabricator_296)\ **Post date:** [September 20, 2010, 9:53pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/1 "2010-09-20T21:53:28Z")
We’re using Toad for Data Analysts 2.1.0.227 with an Oracle 9 database for reports. I’m new to Toad and confused by one aspect: after I create a query and then a report using it, I am unable to make changes to the dataset afterward. I can edit the underlying query to add new fields, but those fields never show up as available to the dataset, and I can find no way to force the issue. I read through Toad’s Help and searched both this forum and the internet in general, but can find nothing documenting this (search for “dataset” in Toad’s Help turned up zero results!). Do I _really_ have to recreate a report from scratch every time I want to add or change a field??? Thanks in advance for any help. ---
**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:** [September 20, 2010, 11:18pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/2 "2010-09-20T23:18:42Z")
How are you changing the fields? If you use the edit query tool button and execute the query it will send back the new result set with the columns. ---
**Author:** ![fabricator\_296](https://avatars.discourse-cdn.com/v4/letter/f/d78d45/32.png) [@fabricator\_296](https://forums.toadworld.com/u/fabricator_296)\ **Post date:** [September 20, 2010, 11:35pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/3 "2010-09-20T23:35:36Z")
I am right-clicking on the report in the Project Manager list and selecting Edit Properties, which pulls up the attached query and lets me make changes. Updating this, however, doesn’t produce a new result set. I’m not sure how I would use the main query editor for this on the report being edited. Are there any step-by-step instructions? Toad’s Help comes up very short here… Thanks. ---
**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:** [September 20, 2010, 11:41pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/4 "2010-09-20T23:41:12Z")
See this post for editing the query. [http://tda.inside.quest.com/thread.jspa?threadID=24407](http://tda.inside.quest.com/thread.jspa?threadID=24407) Debbie ---
**Author:** ![elle](https://avatars.discourse-cdn.com/v4/letter/e/ccd318/32.png) [@elle](https://forums.toadworld.com/u/elle)\ **Post date:** [June 26, 2019, 9:52pm UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/5 "2019-06-26T21:52:32Z")
Hi, I am having the same issue and it appears the link is no longer valid. Can you pls point me in the rt direction? ---
**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:** [June 27, 2019, 11:03am UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/6 "2019-06-27T11:03:01Z")
Hi Elle, can you open up a new thread and describe your issue with more details? This one is 9 years old:) What version are you on and what database is it? Do you use xlsx reports? ---
**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:** [June 28, 2019, 3:56am UTC](https://forums.toadworld.com/t/updating-toad-report-datasets/6326/7 "2019-06-28T03:56:33Z")
see if this helps > **[Building Reports with Toad Data Point - Tip #4: Master/Detail Report](https://blog.toadworld.com/2018/08/29/building-reports-with-toad-data-point-tip-4)** > > Learn powerful tips on creating reports with Toad Data Point, demonstrated by Toad expert Dan Hotka. Part 4 of 4.