Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Greetings,
Paul, you left out one more way (#3?) to look at the data. Open the database table and read the data like a spreadsheet. Speaking of spreadsheets, you can link the database as a data source to a calc spreadsheet. I rarely do that, but when Report Builder was too slow to use a couple years ago, I did experiment with the Calc spreadsheet. As a result, I am glad the devs got RB running faster.
HTH.
Girvin Herr


On 12/05/2013 06:20 PM, Paul wrote:
Hi Bob,

I haven't played much with Base, but there are at least two ways of
viewing the stored information that I know of.

The first is to create a form. I know you can set the form so that you
cannot add, modify or delete any data, which in effect means the form
will be for viewing only.

The second way is to create a report. It really depends on what you
want people to be able to see as to which would suit you better. Forms
are more for viewing a single table one record at a time, whereas
reports are more for generating a listing of information from the
database, possibly from multiple joined tables, and usually only a
subset of the data for each record (but again that depends on how much
data there is), and possibly grouped, with subtotals and stuff.

Play a little and see if one of these two don't meet your needs,
otherwise feel free to provide a little more details about what you
want to achieve and someone here might come up with a better way.

Of course there are other ways outside of LO, like custom frontends,
possibly web frontends, but I'm not sure if you need that sort of
thing.

Paul



On Thu, 5 Dec 2013 14:25:35 -0500
"Bob Muir" <rmuir2@triad.rr.com> wrote:

Hi all,
I am a new user of LibreOffice Base and a beginner in database
creation.

I believe that I have figured out how to create my simple database of
tables and forms.

My question is "Is there a friendly, visual (GUI) thing for
retrieving information from the database?"  I don't want to  require
anyone to write SQL code or use the query design view provided by
Base.

It is possible that the database might be placed on a web server if
that makes a difference.

Thanks,

Bob



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.