On Sat, 15 Mar 2008 21:09:05 -0400 Drew Jensen <[EMAIL PROTECTED]> dijo:
> > I do know about File > Templates > Organize (I have created a lot of my > > own Writer templates for various purposes), but I can't find the report > > template. Where is it? > Well, now I am confused - I thought you where using the Report Builder > when you mentioned the headers and footers, but then you mention styles > and those are in Report Wizard. Two totally different packages - but > since Report Builder doesn't use styles ( least not that you can get to > in the UI ) I'll assume it is the Report Wizard. > > I'll try to help if I can., but I have one question. Could you just > describe the report you want to produce? - I still have a copy of a > database with a table structure based on our earlier exchange and if you > could tell me what you are trying to make I might be able to suggest > Report Wizard or Report Builder as the way to go. > > If the best tool is Report Builder then you might just want to wait for > a few more days, version 1.0.2 will be released simultaneously with OOo > 2.4 and if you upgrade both packages together it clears a whole > multitude of bugs and adds a number features that, from the sounds of > things, you could make use of. For example a pretty good re-work of the > Query analyzer. ( just upgrading one package and not the other doesn't > help really, you need to do both ) First, I resolved the problem myself. A local friend who knows SQL well helped me concatenate my four queries into one using the following syntax: SELECT ( SUBSTR( "QuestionCode", 1, 9 ) ) AS "Category", Count(*) AS "Count", Min( SUBSTR( "QuestionCode", 10, 3 ) ) AS "Minimum", Max( SUBSTR( "QuestionCode", 10, 3 ) ) AS "Maximum" FROM "MainBank" GROUP BY ( SUBSTR( "QuestionCode", 1, 9 ) ) I post that only in case someone else needs to figure out how to do multiple selects in the same query. Having created the above query, I used that with the Report Wizard and now have my report perfectly created. I still had to do a lot of reformatting of the form, so it would be nice if I could find where the Wizard gets its information for how the page should look and be formatted. It appears to be coming from a template somewhere. For example, it creates the report on a landscape page with all kinds of headers and footers that I don't want. I don't mind that it has presets formats and objects, I just want to change what they are. However, for future reference, where is the Report Builder? All I can find is the Wizard. I am loolking at the main window of the database where you see four icons on the left: Tables, Queries, Forms and Reports. Clicking on Reports gives you the (only) option of creating a report with the Wizard. From what you say it sounds as though the Report Builder might be a better tool for me, but where might it be lurking? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
