Ask Your Question

Report Builder in BASE

asked 2019-03-14 20:40:37 +0100

taifatul gravatar image

updated 2019-03-14 20:41:22 +0100

  1. The VISIBLE field Property does not work image description

    1. The YEAR function does not work for a field image description

    2. is it possible to access any user-added field in the report?

    3. How do I create a count field for all records in a group? type here is this =COUNT(*)

edit retag flag offensive close merge delete


version libre office 6.2 , with firebird

taifatul gravatar imagetaifatul ( 2019-03-14 21:03:47 +0100 )edit

@taifatul Please keep questions to one item per question. This has four (#1 is listed twice) and makes it more difficult for others searching for answers.

Ratslinger gravatar imageRatslinger ( 2019-03-14 21:19:05 +0100 )edit

Видимость = Да != Visible = False ;-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-14 22:47:31 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-03-14 22:41:27 +0100

Ratslinger gravatar image

updated 2019-03-15 05:50:53 +0100


  • Item 1 (Visible) appears to be a bug; does not work. You can do the same thing by using the Conditional Print Expression:

  • Second Item 1 (YEAR function) agreed doesn't seem to work. However, it appears you want just the (four digit) year of the date for printing. If so, simply change the Formatting to Date with Format Code = YYYY

  • Item 2 (user fields) Don't understand what is meant by this. Need much better clarification.

  • Item 3 (Count) First, this would go in a group footer. Add a new field (text box) there. For the Data:

image description

Edit 2019-03-14:

In regard to item #2, you should be able to access any item which is on or available to the report. In most cases these items are calculations done throughout the report. Here is a post in which I explain the use of creating functions and using accumulators:

How to reuse an accumulated value in a Report?

or a similar post with actual sample attached:

Libre Data - multi-level report

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-14 20:40:37 +0100

Seen: 44 times

Last updated: Mar 15