Open Forum

Expand all | Collapse all

Document formatting

  • 1.  Document formatting

    Posted Apr 02, 2019 07:09 PM
    ​Does anybody know if one can write conditional formatting into a NAV report (a standard NAV report, not a JET report)?

    I want a rule in the Word/SQL template that looks at the Sales Quote lines and says that when 'Type' = [blank] then the text in the 'Description' field should be in bold.

    So in the below example, I would like the highlighted areas to display in bold.

    Example of Output
    The current report template looks like this, and I don't know how to change it to do what I need it to...

    Sales Quote Report

    ------------------------------
    Elize Erasmus
    Business Process Analyst
    Lifting Solutions Inc.
    Edmonton AB
    ------------------------------
    NAVUG Summit - Post


  • 2.  RE: Document formatting

    Posted Apr 03, 2019 06:50 AM
    Hi Elize,

    In the RDLC layout, I would go into the Description's FontWeight property and set it to this expression:

    =iif(Fields!Type="","Bold","Normal")

    I'm not sure if there's a way to do this in a Word layout.  Let me know if this is what you were looking for.

    ------------------------------
    David Brobst
    Velosio
    Dublin OH
    ------------------------------

    NAVUG Summit - Post


  • 3.  RE: Document formatting

    Posted Apr 03, 2019 12:47 PM
    ​Thanks David, it worked!  I knew it must be possible, but our developer told me it wasn't.  Guess I'll be writing and formatting my own reports going forward.

    Thanks for pointing me in the right direction!

    ------------------------------
    Elize Erasmus
    Business Process Analyst
    Lifting Solutions Inc.
    Edmonton AB
    ------------------------------

    NAVUG Summit - Post


  • 4.  RE: Document formatting

    Posted Apr 03, 2019 03:02 PM
    That's great Elize, I'm glad it worked for you!

    ------------------------------
    David Brobst
    Velosio
    Dublin OH
    ------------------------------

    NAVUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role