open office base report edit menu has col head footer greyed out

Hi Terry

I'm sorry but I cannot find out what you are trying to do. Which versions of Ubuntu and OOo are you using?

Can you describe more fully the options you are taking and the process you are following. I cannot find any options for 'column' headers and footers, greyed or not.

If you use the design wizard it puts in default 'page' headers and footers and puts column headings in by default.

Tony

hello ubuntu version 8.1

oo o version 2.4

database module

clicked on reports.
create reports in design view (NOT the wizard) this is the oo extension report writer

menu edit

sub menu column header/footer.

i have used the report wizard but report in design view gives more capability.

thanks terry

--- On Sun, 17/5/09, Tony Pursell <email address hidden> wrote:

> From: Tony Pursell <email address hidden>
> Subject: Re: [Question #71436]: open office base report edit menu has col head footer greyed out
> To: <email address hidden>
> Date: Sunday, 17 May, 2009, 12:03 PM
> Your question #71436 on
> openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
>     Status: Open => Needs information
>
> Tony Pursell requested for more information:
> Hi Terry
>
> I'm sorry but I cannot find out what you are trying to
> do.  Which
> versions of Ubuntu and OOo are you using?
>
> Can you describe more fully the options you are taking and
> the process
> you are following.  I cannot find any options for
> 'column' headers and
> footers, greyed or not.
>
> If you use the design wizard it puts in default 'page'
> headers and
> footers and puts column headings in by default.
>
> Tony
>
> --
> To answer this request for more information, you can either
> reply to
> this email or enter your reply at the following page:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
> You received this question notification because you are a
> direct
> subscriber of the question.
>

Hi Terry

Can you tell me what this extension is called? I cannot find anything with quite the same name at

http://extensions.services.openoffice.org/

Tony

hello

the extension is
sun-report-builder.oxt

thanks terry

--- On Sun, 17/5/09, Tony Pursell <email address hidden> wrote:

> From: Tony Pursell <email address hidden>
> Subject: Re: [Question #71436]: open office base report edit menu has col head footer greyed out
> To: <email address hidden>
> Date: Sunday, 17 May, 2009, 5:19 PM
> Your question #71436 on
> openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
>     Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Hi Terry
>
> Can you tell me what this extension is called?  I
> cannot find anything
> with quite the same name at
>
> http://extensions.services.openoffice.org/
>
> Tony
>
> --
> If this answers your question, please go to the following
> page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436/+confirm?answer_id=2
>
> If you still need help, you can reply to this email or go
> to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
> You received this question notification because you are a
> direct
> subscriber of the question.
>

I'm sorry then, I can't help you. The current version of that is only compatible with OOo 3.1 and the version in Jaunty is 3.0.1, so I don't want to install it. Can I suggest you look for help on the OOo forums at

http://user.services.openoffice.org/en/forum/

There is a forum there for help with extensions.

Tony

hello tony

thanks for your help.

i found also that the current version from sun is compatible with version 3 of oo but there is a version compatible with oo 2.4 on synaptic.

i will try the forums .

terry

--- On Sun, 17/5/09, Tony Pursell <email address hidden> wrote:

> From: Tony Pursell <email address hidden>
> Subject: Re: [Question #71436]: open office base report edit menu has col head footer greyed out
> To: <email address hidden>
> Date: Sunday, 17 May, 2009, 10:20 PM
> Your question #71436 on
> openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
>     Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> I'm sorry then, I can't help you.  The current version
> of that is only
> compatible with OOo 3.1 and the version in Jaunty is 3.0.1,
> so I don't
> want to install it.  Can I suggest you look for help
> on the OOo forums
> at
>
> http://user.services.openoffice.org/en/forum/
>
> There is a forum there for help with extensions.
>
> Tony
>
> --
> If this answers your question, please go to the following
> page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436/+confirm?answer_id=4
>
> If you still need help, you can reply to this email or go
> to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
> You received this question notification because you are a
> direct
> subscriber of the question.
>

Hi Terry

I got the package from synaptic, installed it and had a play around with it. Trouble is, I can't find any way to create a table to put column headers/footers on. Where would you use them?

Tony

hello tony

i set up a sreadsheet and then opened it in data base using 'connect to to an existing db'

click on reports and select 'create report in design view'

on rhs select content 'probably as sheet1'

add field pop up appears. drag fields to detail section.

the label is put beside the field but for a column report you want it at the top of the columns so delete the labels beside the fields. maybe that is where i am going wrong.

note to delete the label you unselect the field and then click on the label. rt click and delete

if you look at the edit menu it has col heads and footers but it is greyed out.

thats as far as i got

i tried putting the labels in the page header but then on the first page they appear above the report title.

terry

--- On Mon, 18/5/09, Tony Pursell <email address hidden> wrote:

> From: Tony Pursell <email address hidden>
> Subject: Re: [Question #71436]: open office base report edit menu has col head footer greyed out
> To: <email address hidden>
> Date: Monday, 18 May, 2009, 6:55 PM
> Your question #71436 on
> openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
>     Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Hi Terry
>
> I got the package from synaptic, installed it and had a
> play around with
> it.  Trouble is, I can't find any way to create a
> table to put column
> headers/footers on.  Where would you use them?
>
> Tony
>
> --
> If this answers your question, please go to the following
> page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436/+confirm?answer_id=6
>
> If you still need help, you can reply to this email or go
> to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
> You received this question notification because you are a
> direct
> subscriber of the question.
>

hello tony

thanks for your efforts.

i am coming to the same opion as yourself. it keeps crashing for me and as you say there is no documentation.

it has got the thumbs down with me and i will stick with the wizard.

the only problem with the wizard as i see it , is that you cannot put a number of db fields in the same column ie one under the other.

i wanted a report which was too wide to fit on a page and wanted it to look like this

field1 field2 field3 (record 1)
           field4
           field5
field1 field2 field3 (record 2)
           field4
           field5

etc

i used to use the report generator in ms works in windows and it was able to do that.

i will have to either use windows (which i hate in principle ) or convince my wife who's report it is , that she can have the data in multiple reports.

oh well such is life, nothing is perfect.

i think that my origonal query should now be closed, if it is not already.

terry

--- On Thu, 21/5/09, Tony Pursell <email address hidden> wrote:

> From: Tony Pursell <email address hidden>
> Subject: Re: [Question #71436]: open office base report edit menu has col head footer greyed out
> To: <email address hidden>
> Date: Thursday, 21 May, 2009, 11:03 PM
> Your question #71436 on
> openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
>     Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Hi Terry
>
> I've had a play along the lines you described.  I
> don't really think
> dragging fields in a line across the details section
> constitutes a
> 'table' because they are not in any way bound
> together.  They can be
> moved independently.  Anyway you can add 'headers' by
> putting text
> fields above them in a report or page header, albeit in a
> similar
> unbound way.  I still don't know if there is a way to
> add a true table
> structure to the report.  If there is, then I'm sure
> that the column
> header/footers entry would spring into life when you create
> a table.
>
> I must say, I am not that impressed with this report
> writer.  It has
> crashed OOo for me once and crashed X once, on both
> occasions loosing
> the edits I had done.  Also I found that if you add a
> grouping, you
> cannot delete it, and the grouping didn't work for
> identical varchar
> fields (may be it does for other data types).
>
> My final criticism, is the apparently complete lack of
> documentation/help. So I'm afraid I have to give up on this
> one,
>
> Tony
>
> --
> If this answers your question, please go to the following
> page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436/+confirm?answer_id=8
>
> If you still need help, you can reply to this email or go
> to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/71436
>
> You received this question notification because you are a
> direct
> subscriber of the question.
>

tony answered to say that this report writer keeps crashing and has no documentation. so i will stick with the wizard.