# refresh dataset in report designer

**URL:** <https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [November 19, 2009, 8:48am UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086 "2009-11-19T08:48:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![galahad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/galahad/32/48_2.png) [@galahad](https://forums.toadworld.com/u/galahad)\
**Post date:** [November 19, 2009, 8:48am UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086/1 "2009-11-19T08:48:44Z")

</div>

Hallo,

i made a select and generated a report from it…everything works fine.

Now, there is the need of overworking the select and refreshing the dataset of the report.  
I overworked the select could’nt find a way to refresh it in the report.  
So i copied it and pasted in manually in the properties of the report.

If i open the report and take a look in the field list, i am not able to find my new generated fields.

Is there a possibility to add the new fields from the new select to an existing report?

Thank you for your help.

---

<div class="post-metadata">

**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:** [November 19, 2009, 12:13pm UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086/2 "2009-11-19T12:13:15Z")

</div>

Here is how to do this.

1. In the Report designer select the ‘Edit underlying Query’ tool button.
2. This will send the exisitng query to an editor. Change your query and execute.
3. Send the SQL and result set back to the designer. (See screenshot for toolbutton)
4. While back in the designer you will now see the new columns and can continue designing.
5. The Desinger tab does not have your original file name but it is using the origianl report design. Save the chnages to a new file name or the old.

This should give you what you need. See screenshots.

debbie  
 ![DataReportB.png](https://global.discourse-cdn.com/quest/original/2X/1/132e85c6bd7f1bec64d9293574c5a8ceb5d6cdbc.png)

---

<div class="post-metadata">

**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:** [November 19, 2009, 12:13pm UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086/3 "2009-11-19T12:13:15Z")

</div>

Here is how to do this.

1. In the Report designer select the 'Edit underlying Query' tool button.
2. This will send the exisitng query to an editor. Change your query and execute.
3. Send the SQL and result set back to the designer. (See screenshot for toolbutton)
4. While back in the designer you will now see the new columns and can continue designing.
5. The Desinger tab does not have your original file name but it is using the origianl report design. Save the chnages to a new file name or the old.

This should give you what you need. See screenshots.

debbie

 ![DataReportC.png](https://global.discourse-cdn.com/quest/original/2X/0/0d66616273b7bbcb4f66d40e18be27c16e7fe9c7.png)

---

<div class="post-metadata">

**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:** [November 19, 2009, 12:13pm UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086/4 "2009-11-19T12:13:15Z")

</div>

Here is how to do this.

1. In the Report designer select the 'Edit underlying Query' tool button.
2. This will send the exisitng query to an editor. Change your query and execute.
3. Send the SQL and result set back to the designer. (See screenshot for toolbutton)
4. While back in the designer you will now see the new columns and can continue designing.
5. The Desinger tab does not have your original file name but it is using the origianl report design. Save the chnages to a new file name or the old.

This should give you what you need. See screenshots.

debbie

 ![DataReportA.png](https://global.discourse-cdn.com/quest/original/2X/6/6ccbe2d176d7d1dd6786aebcce34e73bee0c04fd.png)

---

<div class="post-metadata">

**Author:** ![galahad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/galahad/32/48_2.png) [@galahad](https://forums.toadworld.com/u/galahad)\
**Post date:** [November 23, 2009, 5:19am UTC](https://forums.toadworld.com/t/refresh-dataset-in-report-designer/6086/5 "2009-11-23T05:19:17Z")

</div>

Hello debbie,

your answer was quite helpful.

Thank you very much for your help.