Enrich dataview formatting options to approach IBCS® standards

Idea created by rubicon on Mar 6, 2018
    Open for voting
    Score17

    1. What is your idea?

     

    Enrich the dataview's format settings. In particular the block-specific #format settings of a layout.

     

    Currently, the several formatting options I know are :

    1. use row templates for the ByRow entities
    2. use block formatting options (Dataview Menu > Layout > Block configuration > Format): I can set foreground and background color of the cells, but no border setting (border style, colour, thickness ...)
    3. use dataview settings to format further (Dataview Menu > Settings > Format > ...): I can set foreground and background color of the listed elements, but no border setting (border style, colour, thickness ...)

     

    What I wish to add is (feel free to add more in the comments):

    1. ability to set border properties for Label, Value, Total, Grand total of a specific block of a dataview. Example with
      • double border (top and bottom) for the grand total of each block
      • thick bottom border for the label of each block:
    2. ability to set properties at dataview level (apply to all blocks) for headers, GroupBy, Grand Total beyond the foreground and background colors, e.g.
      • text in bold, e.g. the grand total line of the table above: it has a bold text for TOTAL and the four total values.
      • borders settings (border style, thickness ...)

     

    2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to?

     

    This idea is maybe quite a small detail, but this enrichment would helps building a BOARD application using reporting standards as suggested by the ibcs ® standards (International Business Communication Standards).

    These standards aim at providing a consistent reporting set for the user, so that he can very quickly know whether he is looking on actuals, budget or previous period figures (for example).

     

    I give an example for a report table (Source) using IBCS standards so you can get a feeling on where I wish to achieve:

    Actual, plan and forecast figures are distinguished

    • in the headers text and
    • in the headers' borders of the table: bottom double border for plan, thick border for actuals, hatched for forecast

     

    3. What workaround have you found and used so far (if any)?

    a few workaround with labels or linked dataview might be used, but they work only for small and static dataviews, their print or export is not really acceptable by a customer, the drill-down function on the dataview would open a new dataview without the borders created by the workaround and so on.... See the question I asked regarding this topic.