Toad World® Forums

refresh dataset in report designer


#1

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.


#2

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


#3

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


#4

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


#5

Hello debbie,

your answer was quite helpful.

Thank you very much for your help.