On Fri, 14 Mar 2008 00:20:30 -0400 Drew Jensen <[EMAIL PROTECTED]> dijo:
> John Jason Jordan wrote: > > I can't figure out how to connect my report to the database. The Help file > > says: > > > > First you must connect the report to a database table. > > 1.Move the mouse to the Properties view. You see two tab pages General and > > Data. > > 2.On the Data tab page, click Content to open the combo box. > > 3.Select the table for that you want to create the report. > > 4.After selecting the table, press the Tab key to leave the Content box. > > The Add Field window opens automatically and shows all fields of the > > selected table. > > > > I can't get to Step 1. Where is the Properties View? > > > > I assume you are talking about the SUN Report Builder here - and I must > admit this makes very little sense, but here you go. > > Open the report for editing. > To open the property editor - View > Properties > To set the properties for the report document overall - Edit > Select report > > You should see the data tab now. Thanks, but bad stuff has happened and now I need different advice. I am trying to create a report for a table that consists of 7,349 test questions. The first field is a keyed, unique, required, 12-character text field. The first nine characters of this field are capital letters indicating the category of the question. There are 59 different categories. The last three characters are numbers where each category is numbered 001 to however many questions there are for that category. I had (with your previous assistance) created a GROUP BY query that got me a table of the 49 categories as just the first nine characters. Using the SQL for it (and some poking on my own) I managed to create a Count query that got me a table with the total number of questions in each category, and then queries for Minimum and Maximum. I was trying to concatenate these four queries or somehow base a report on the queries so I could make a printout of the 59 categories and how many questions are in each category. I had been poking around at the queries and the attempted report off and on. Meantime I started working on a data entry form. In the midst of that the entire database hung and I had to kill it. I wish I knew precisely what caused it to hang so I could file a bug report, but I do not recall. When I relaunched Base the Recovery window popped up. I told it to recover the database. When it finished the queries that I had created were gone, as well as the report and form that I had been working on. There is no backup of those objects. They were lost because I did not save the database after creating the queries and the report. I do have automatic backups enabled for every five or ten minutes or something, but evidently that doesn't work for Base files. I have the SQL in saved e-mails, though, so I have already recreated the queries. And having recreated them they are now saved! So now that I have the queries recreated, can I base a report on a query? Evidently the only way to create a report is to use the Wizard. I find a list of tables and queries in the drop-down. I can put a query on the report using the Wizard, but only one query. The Wizard won't allow more than one query. I can create the report with one query, but can't figure out how to create additional controls based on the other three queries on the same report. As an alternative, is there a way to concatenate my four queries into one query? I tried to do so, but just get errors because, even if it can be done, evidently I can't figure out the syntax for "and then do this." Also, every time I open the report the changes I made to styles have reverted to the default font. Changes I make to the formatting for the report are not being saved. Also, on the data entry form that I have created I have text fields linked to fields in the MainBank table. Everything is working OK, that is, the text for each record appears in the text fields as I click through the records, but I can't get the text to appear at the top of the text field frame. It insists on being centered in the frame, in spite of setting it to Top (right-click, Alignment, Top). Some day I may actually figure this all out. Meantime, suggestions are welcome. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
