REPORT - textbox - control - data - datafield (greyed out)

Getting your data onto paper - or the web - Discussing the reports features of Base

REPORT - textbox - control - data - datafield (greyed out)

Postby cirruss_design » Wed Apr 04, 2018 9:52 am

Hello

When trying to add an element to my report to contain a function/formula to run at runtime in either a 'textbox' or 'formatted field':

ADD TEXTBOX or FORMATTED FIELD to report in design view:

Right click on the object - control - data - datafield (greyed out)

using for a GCSE exam and students are unable to add runtime formulas as requested in exam papers so this is really urgent i can find a work around!!! :shock:

Let me know if there is further info which needs adding, i have spent hours trying to find a work around!
MACOS Sierra 10.12.6

OPEN OFFICE - 4.1.5
cirruss_design
 
Posts: 4
Joined: Wed Apr 04, 2018 9:44 am

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby UnklDonald418 » Wed Apr 04, 2018 5:43 pm

It sounds like your control has no data source.
Right click on your control and first select Form. On the Data tab of the Form Properties dialog choose Content type and Content. Then you should be able to select a Data field in the control properties dialog,
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1225
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby cirruss_design » Wed Apr 04, 2018 5:54 pm

Screen Shot 2018-04-04 at 17.53.06.png
MACOS Sierra 10.12.6

OPEN OFFICE - 4.1.5
cirruss_design
 
Posts: 4
Joined: Wed Apr 04, 2018 9:44 am

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby UnklDonald418 » Wed Apr 04, 2018 6:23 pm

That's the Properties: Formatted Field dialog, what you need to check first is the [b]Properties: Form[/b] dialog so that there is a data source before you can choose a Data Field
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1225
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby UnklDonald418 » Wed Apr 04, 2018 10:52 pm

After re-reading your goal
When trying to add an element to my report to contain a function/formula to run at runtime in either a 'textbox' or 'formatted field':

I don't think you can achieve that with the report writer built into Open Office. The Oracle Report Builder extension has far more capabilities, including functions
https://extensions.openoffice.org/project/reportdesign
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1225
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby cirruss_design » Thu Apr 05, 2018 8:31 am

Screen Shot 2018-04-05 at 08.27.24.png
Thanks for the replies both. I have screen shotted an example here to see what they are required to do:
MACOS Sierra 10.12.6

OPEN OFFICE - 4.1.5
cirruss_design
 
Posts: 4
Joined: Wed Apr 04, 2018 9:44 am

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby cirruss_design » Thu Apr 05, 2018 8:34 am

UnklDonald418 wrote:That's the Properties: Formatted Field dialog, what you need to check first is the [b]Properties: Form[/b] dialog so that there is a data source before you can choose a Data Field


Hey thanks for that!

How do I access the 'properties: Form' settings (the same happens when I try to use a textbox to output a simple SUM formula output).
MACOS Sierra 10.12.6

OPEN OFFICE - 4.1.5
cirruss_design
 
Posts: 4
Joined: Wed Apr 04, 2018 9:44 am

Re: REPORT - textbox - control - data - datafield (greyed ou

Postby UnklDonald418 » Thu Apr 05, 2018 5:04 pm

When using ORB adding a form control makes no sense.
From the ORB design window press F4 to toggle the properties dialog. Also, Insert->Report Controls will display a list of options including controls that you can add to a report.
Since LO uses the ORB as it's default report builder, download the LO Base Handbook and look at chapter 6
https://documentation.libreoffice.org/en/english-documentation/base/
The original Sun Report Builder documentation can be found at
https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1225
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests