Page 1 of 1

Reporting Single Records/

PostPosted: Fri Dec 30, 2011 2:10 am
by Chrisl
Hello:

I'm a neophyte to database creation.

Does Base reporting allow for printing a report based on a SINGLE RECORD? I will explain:

I'd be using Base to create a quote form for our business and it would be used by multiple agents. The quote form would provide entry of data for sales prospects and would provide information necessary in creating proposals (in a non-Open Office separate application). The Base form once printed as a report would be used simply for reference. The form may be used to enter data specific and unique to each record (e.g. information related to John Smith, Jane Doe, Mark Jones, etc.)

In creating a report, then, I would want to be able to create a report based on a single record. When creating a proposal for John Smith based on information gathered from John Smith, I would NOT want information in a report from Jane Doe, etc. Such information would be meaningless, extraneous, etc. A single white paper report printed out after entering a single record in the database to be used for reference.

Is this possible?

Is there a way in creating a form to include/create a button (pointing to a macro?) when clicked on at the end of filling out the form based on each individual record that would automatically then, print a report showing only the single record?

Thanks.

Re: Reporting Single Records/

PostPosted: Mon Jan 09, 2012 12:35 am
by Arineckaig
A single white paper report printed out after entering a single record in the database to be used for reference.
Is this possible?

Welcome to the forum. It should certainly be possible to produce such reports. The various elements of OpenOffice work well together. For example, it is quite possible to create a Writer document in the layout required for your quotes with form controls that can readily be filled with the required content from a particular record read from either a table or a query in a separate Base file provided the database has been registered with OpenOffice. With any open Writer document, it is possible to press f4 to open a frame at the top which lists all the 'registered' databases from which the content of their tables and queries can be displayed and the required data used to fill the form control fields in the Writer document: it is similar to the mail merge process.

The operation is not specifically documented in the User Guides but an introductory tutorial can be found at http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=40493.

Re: Reporting Single Records/

PostPosted: Sat Jan 21, 2012 11:37 am
by F3K Total
Hello,
i attached an example using a macro with mailmerge.

1.) register DB "Contacts"
2.) exchange the database in writer file "Single_Row_Print.odt" to your location of "Contacts", save.
3.) Open form "contacts" in the .odb, select a row and hit a button.

Greats R