User SQL from template

[Oskar]

creating a new user SQL using Blank report gives me the dialog to enter the query.____However, useing a existing report as template does not.____So, what can I do to edit the SQL query in a existing report which has been created using a wizzard____TIA__Oskar

[kfleming]

A wizard report is an auto SQL report where R&R writes the SELECT. To modify it you would need to use Database Show SQL and the Copy.__Then use File New User SQL and paste the SELECT into the SELECT entry box.____Note that you can only copy the SELECT itself and not the existing report layout.____Kathleen__R&R Support

[Oskar]

>__>Note that you can only copy the SELECT itself and not the __>existing report layout. ____Does this mean in essence that I cannot copy fields (layout) from one report to an other? Basically have to redo the layout from scratch?____TIA__Oskar