Forum Discussion

MichelleChapman's avatar
MichelleChapman
Qrew Assistant Captain
6 years ago

Larger Font on Chart Report

How do I increase the font size on a chart report? When I save as JPEG the font is so small I cannot even read the bold fields. Is there a formula I can enter on the report to increase the font size? 
  • @Michelle Chapman, there is an old thread that has some code that you can put into a formula rich text field that will accomplish this. Here is the link to the original thread:

    link

    This solution was crafted by @_anom Diebolt). I found that it can be expanded to include other CSS elements and styling and can also be coupled with the .hide() function to remove various elements from the page.

    Take this code and paste it into a rich text formula field. The first two lines style the font and the third adjusts the background color; 100.5% is the font size parameter while Nirmala UI is the font type. This is just for example and it can be tailored to your specific need so feel free to delete any of the styling that you don't need or like.
    "<img src onerror='$(`*`).css(`font`, `bold 100.5% Nirmala UI`);'>
    <img src onerror='$(`*`).css(`color`, `blue`);'>
    <img src onerror='$(`*`).css(`background-color`, `lightgrey`);'>
    <img src onerror='
    $(\"#navTop\").hide();
    $(\"#tablesMenuBarWrapper\").hide();
    $(\"#TableNPageBarSeparator\").hide();
    $(\"#pageNavBarTray\").hide();
    $(\"#stdCustThisFormButton\").hide();
    $(\"#formFooterButtonsContainer\").hide();
    $(\"#customBasicBrandMenus\").hide();
    $(\"#recordNavBar\").hide();
    $(\"#signInLink\").hide();'>"ā€‹


    In the interest of the user experience, title the field - so that it doesn't take up space and add it as the last field in your table so it is out of the way. If you use it on a form, just tick the check box for an alternate title and leave it blank to not show the - on the form. You can make many of these formula fields and add them to various forms and tables to create different styling for each, they will just have to have unique field titles.

    Here is the original table report:


    And here is the result of using the formula rich text field on a table report:

    Here is the result on a form:

    This does not work on the mobile app.

    ------------------------------
    Adam Keever
    ------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    I am guessing this issue is because you have a ton of data on the chart.

    Is it possible to split your report into several reports? If it is a yearly report maybe try 2 or 4 parts instead. There might be a better way to split it up as well, I don't know the data you are working with.

    I haven't tried this so I'm not sure if it will apply but when printing you can go into More Settings and set the scale to higher to make the report larger. You might be able to do this and print it to a pdf file instead and end up with something that has a larger font. Worth it to test. You could even make that pdf into a picture afterwards but I know it isn't the greatest option. However, if it works for you...