On Thu, 2011-04-07 at 09:43 -0400, Dan Lewis wrote: > Dan Lewis wrote: > > The Base Guide outline for chapter 4 contains this subheading > > under Report Wizard: > > Tables, Queries, Views, and SQL. > > I understand how to create a report from a tables, queries, and > > views. But creating a report using the wizard from SQL is something > > that I do not understand. How is this SQL statement created?
The SQL statement is created using the Query Designer, in this context most likely in SQl View mode. > Page 1 of > > the Report Wizard has the Tables and Queries dropdown list. How does > > this SQL statement become visible in the list? > > > > Jean: Chapter 4 of the Base Guide is completed with the exception > > of the Report Wizard section. I should be able to finish this section > > in about a week with the SQL part mentioned above. Without more > > information about how a SQL statement can be accessed by the Report > > Wizard, I will limit the section on creating a report from to the > > following: tables, queries, and views. > > > > Dan > As a follow-up on SQL: Is the SQL referred to in the outline the > SQL command entered into the Oracle Report Builder? Hi Dan, The Query designer can be called directly from the Report Builder interface, the generated SQL statement is then fed back into the Report definition. > After doing some > research, the Report Builder can create a report based upon a SQL > command. I don't see how the Report Wizard can. Again, for the older wizard the SQL is generated prior to the running the wizard and you connect to this, as you would a Table. Additionally, it would be common to use the Query designer to generate a complex SQL statement and then to turn this into a VIEW, the wizard then connects to the VIEW, as if it where a TABLE. //drew > Jean: If the SQL mentioned in the Report Wizard section belongs to > a section on the Report Builder, then perhaps the SQL should be removed > from the Report Wizard section? Also perhaps a note at the end of the > Report Wizard is needed. There mention that the Report Builder is > available and that SQL can be used as a source for a report. > > Dan > > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help > -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
