Report Builder in BASE

[taifatul]

1. The VISIBLE field Property does not work
   

   

2. The YEAR function does not work for a field
   

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

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

[taifatul]

version libre office 6.2 , with firebird

[Ratslinger]

@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.

[mikekaganski]

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

[Ratslinger]

Hello,

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

    If(1=2)
  

• 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:

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