Page 1 of 1
User SQL from template
Posted: Wed Apr 11, 2007 6:39 pm
by 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
=> RE: User SQL from template
Posted: Thu Apr 12, 2007 9:32 am
by 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
==> RE: User SQL from template
Posted: Thu Apr 12, 2007 11:03 am
by 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