Daniel Lewis wrote:
My concern is the Base Guide outline of chapter 4, specifically
the items below. I understand how to chose a layout and make little
changes in the appearance of a report (e.g., how to format the columns
in the report). I also understand how to use a table, query, or view
as the basis for a report. But what does SQL have to do with the
Report Wizard?
Dan
4.1. Query Wizard
4.2. Report Wizard
4.2.1. Tables and Queries and SQL
4.2.2. Chose a layout
4.2.3. Can I make this little change?
Hey Dan,
I suppose what I was getting at was this:
In Base the term query is most often misused to mean a QueryDefinition
which is an OpenOffice.org Base data structure.
An SQl statement is part of that query definition.
In report writing, particularly, one will get into situations where the
SQL needed for the task will quickly exceed the ability of the
QueryDefintions GUI component to handle.
From a reporting stand point, irregardless of reporting tool I would
think this a good time to introduce the reader to SQL conditional
statements, UNION and such.
This requirement is diminished with the use of the Sun Report Builder,
but not altogether missing.
What is looming on the horizon is OO.o 3.3 and the HSQLdb 2.0 engine,
this will bring a PL/SQL style language and stored procedures which are
also heavily utilized in generating non ad hoc reports.
Anyway - looking at this, The Report Wizard, it seems to me that it
would be best to move over that subject very rapidly. Just a simple
listing type report with a single grouping would seem like more then
enough information. Honestly, I would drop the SQL part.
By the way, sorry for taking so long on Chapter 3 - I did get into it
far enough to start creating the example database, I waited for the
first 3.2.1 snap shot build to actually follow the steps - get to test
two things at one time sort of then. I will keep going on chapter 3
right through to the end and send my comments, which so far are very slim.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
