Hi John, Am Donnerstag, den 14.02.2008, 02:51 -0500 schrieb John Toliver: > Hello all,
[...] > With that said I have a few questions about methods of manipulating data: > 1. When I create a report, I may spend an hour or more getting the > report so that it formats my data the way I want it to display. I > choose to have my report set to display the results of a query. If I > wish to create another report looking at different aspects of the data > I would do this through another query (ie scenario 1: query me all > apples in report format A. scenario 2: query me all oranges in report > format A) My problem is once I create the report that took an hour to > do. I don't want to recreate the entire report pointing it to the > second query for displaying in report format "A". I want to be able > to At any rate copy it and paste (duplicate the report template) and > then change the data source from what it is displaying to data B but > use the duplicated report template. from query 1(apples) to query 2 > oranges. Is this possible to do, or must I create each report > manually through the wizard and point it to the data source I want? Although I didn't do that myself yet, it should be possible to: 1. make a copy of your report and give it a fitting name 2. open it in design mode 3. select anything that depends on database fields once and change the query it is based on. But That will be a lot of work, too. Another, better approach: I assume you are using the built-in wizard. There is another solution called "Sun Report Builder". That one has much better support for editing reports in design mode. If you are starting your work it is at least worth an evaluation, although I think it's not completed yet. To try it out you do: 1. go to http://extensions.openoffice.org 2. search the item "Sun Report Builder" 3. download it 4. start OO.o 5. use the manu "tools -> extension manager" to install it. The next time you create a report (not using the wizard IIRC) it will start up and show a help page explaining how to use it. > 2. Is it possible to undelete a table you have already deleted? :-) Only if yo did not commit the delete command yet. But since a default connection has "autocommit" mode switched on, this will mostly not be the case. When developing a base application I'm making backups after each big piece of work by making a numbered copy of the .odb file ... > 3. Is it possible to import a table into base. For example if a > fellow student is keeping track of another body of data, and I wish to > import her work, how would I import her table data to my database? Yes, this is possible. To make life easy it should undergo some planning and preparation regarding the table type and transfer way. > 4. When I am in the Forms section, I have found that the default > fields the wizard creates aren't that useful for the type of form I am > creating now. I need the flexibility of a text box. The problem is > the text box seems not to support a human readable label. So if one > field is for patient history, and another is for comments, I wouldn't > know it unless I remembered. How do I put visible labels on my text > box fields so that when I am working with the form I can see the title > of the fields? Can you explain the table structure and what you are doing? Normally each control in a form does get a label showing the column name. If you have, let's say a table with arbitrary texts of the type "history", "comment" and "medication" I'd suggest either separating into those categories (one table each) or add a column "category" to fill in when a text entry is created (when crating a comment text entry, the column "type" is set to "comment"). > 5. Also, how do I create the fields that the default wizard creates. > I can insert text boxes and other objects in the form but I can't find > anywhere that handles the fields the form wizard creates. I don't get you, can you describe in more detail, please? HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
