====== Report Themes ====== Themes enable the developer to customize the look and feel of any report. Themes let the developer to express their graphical & artistic capabilities (or in some cases, the lack thereof). Themes relate to: * Fonts * Foreground and background colors * Chart default sizes and initial colors * Grid line colors * Headers and totals foreground and background colors. * Chart colors * Exception style formatting To invoke Report Themes, Select **Report Themes** from the Admin menu. {{:biplus:documentation:reports_themes.png?nolink&550|}} This opens the **Report Themes** dialog. This dialog can be used to create a new theme or to edit an existing theme which defines the look and feel of different reports. Different departments may have different desired styles or fonts they like to use, so you can create different themes. Here you can create a new theme using the buttons to **Add** a new theme, **Modify** an existing theme, **Delete**, **Copy** and **Export** a theme into .smd file. {{:biplus:documentation:reports_themes_dialog.png?nolink&500|}} When you add a new theme you gets a **Report Theme - New Report Theme** dialog. Here, you will see that various attributes are set for odd and even row foreground and background colors, group and report total colors, gridline colors and whether or not to show gridlines and a color selector for gridlines. Also the default font for the theme is set. Themes enable people with graphic flair, a chance to use different colors to bring about different look and feel for each report. See image below. {{:biplus:documentation:report_theme_add.png?nolink&550|}} Here, we have given a name to this theme, **My Favourite Theme**. One can also make this theme as **Default Theme** by checking the Default Theme check-box. Once you make this as default theme then all reports will have style & colors of this theme. One can also apply a particular theme to a particular report. As shown in following image. {{:biplus:documentation:applying_themes.png?nolink&550|}} **NOTE:** Once you apply a theme to a particular report then for that report default theme will be overridden by selected theme. ===== General tab ===== Now lets see each attribute in themes and how and where changes will be reflected in the reports. First tab in Themes is **General** We have change color for some attribute so that we can see the changes clearly in demo reports. {{:biplus:documentation:theme_general_tab_main.png?nolink&550|}} As you see in above image, for some attributes background color is changed and the below report run displaying where the changes affected. {{:biplus:documentation:theme_general_tab.png?nolink&450|}} {{:biplus:documentation:theme_general_tab_1.png?nolink&450|}} ===== Table Report tab ===== Second tab in Themes is **Table Report**. * **Table Header Font:** Allows us to set font and font size for a column header. * **Table Header Background:** Allows us to select and set background color for table column. * **Odd Row Background:** Allows us to select and set background color for Odd Rows(1,3,5,...). * **Even Row Background:** Allows us to select and set background color for Even Rows(2,4,6,...). * **Group Total Font:** Allows us to set font and font size for a Group Total. * **Group Total Background:** Allows us to select and set background color for Group Total. * **Report Total Font:** Allows us to set font and font size for a Report Total. * **Report Total Background:** Allows us to select and set background color for Report Total. * **Empty Line Font:** Allows us to set font and font size for a Empty Line * **Empty Line Background:** Allows us to select and set background color for Empty Line. * **Gridlines color:** Allows us to select and set background color for table Grid Lines. * **Show Gridlines:** Enable/Disable table grid lines. {{:biplus:documentation:my_fav_theme.png?nolink&550|}} In above image you can see that we have changed some colors and fonts for Table Reports. * Table Header Font: Font = **MV Boli**, Size = **14**. * Table Header Background: **Grey color** * Odd Row Background: **Light Pink color** * Even Row Background: **Pale Green color** * Group Total Background: **Yellow color** * Report Total Background: **Magenta color** * Empty Line Background: **Blue color** * Gridlines Color: **Red Color** So when we runs a table report changed attributes will looks like this. {{:biplus:documentation:table_theme_report_1.png?nolink&550|}} {{:biplus:documentation:table_theme_report_2.png?nolink&550|}} ===== Table Row Styles tab ===== **Table Row Styles** are used to highlight a row or cell in table reports. Sometimes one want to highlight a cell if value goes up/down by certain amount or to highlight a specific product in a cell report. Each theme has up to 9 different styles. Following image shows different row style background colors. Each of the styles has a customizable background color. The foreground color is set by clicking the Text Font pop-up display, where you can set font type, size, bold, italic, underline and color. {{:biplus:documentation:theme_table_row_style.png?nolink&550|}} Now its time to apply row style color. Row style colors are used in **Totals, Pivot Properties, Field Format** (Cell style, Row Style, Column Group). Image shows example of applying style on Field Format(Row Style) and condition is **when PRODUCT column value = 'Dell Server' then that row background color will be selected style color**. This way we have created three different styles. {{:biplus:documentation:theme_table_row_style_applying.png?nolink&550|}} So when Amount value is less than 150 that cell will highlighted in **RED** color. Same way if PRODUCT type is Laptop the that cell will be highlighted in **YELLOW** color. {{:biplus:documentation:theme_table_row_style_applying_1.png?nolink&550|}} So whenever this report will be ran output will look like as follows. This way we can apply multiple style with multiple conditions. {{:biplus:documentation:theme_table_row_style_report.png?nolink&550|}} **NOTE:** When BIPLUS evaluates Row Style Field Formats at run time, for each row, the first Row Style Field format that returns a Boolean TRUE when checking the conditions will prevent any more Row Styles from being evaluated, so it is important to set the precedence and order in which conditional field formats are to be evaluated, otherwise you may get unexpected results. ===== Chart Report ===== Chart Report tab also has several option which are specially used in chart report. See image below. {{:biplus:documentation:theme_chart_report.png?nolink&550|}} Here you can change the **Background, Gradient Style, Gradient Distribution, Chart Label Font, Cell Style, Line Style** and **Color Series**. * **Background:** Background color of the chart report. Following image is showing two chart report with different background colors. * **Gradient Style:** Allows you to set gradient. First chart has 'Vertical Centered' gradient and second chart report has 'Left to Right' gradient. * **Gradient Distribution:** Allows you to set gradient opacity. * **Chart Label Font:** Font of label in chart report. * **Cell Style & Line Style:** You can mention default Cell Style and Line Style for flow-chart report. So that for each flow-chart report you don't need to make Cell Style and Line Style. {{:biplus:documentation:theme_chart_report_result.png?nolink&550|}}