Forum Discussion

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
2 years ago

How can we make header as bold and increase the header size in both report & excel?

Dear Community,  We have a requirement to make all the headers in report as well as in excel to make it bold and to increase the size. Here, I wrote a Business Rule function in Cube View Extender t...
Cube View
Parameters
Reports
  • OS_Pizza's avatar
    OS_Pizza
    2 years ago

    You can update the format directly in the cube view editor. Please check the screenshot below and the result -

    Result

    (OR)

    If you want to use the business rule then you have to add the property for l2,l3 and so on. Check below

     

    The difference in Excel v/s report is because you have extracted the CubeView in excel directly. Open first in Report and then do an Export -> XLS

     

     

  • OS_Pizza's avatar
    OS_Pizza
    2 years ago

    Revert the changes in the Cube View Header format and use the logic in the business rule ( Check the updated comment ).

OS_Pizza's avatar
OS_Pizza
Contributor III
2 years ago

You can update the format directly in the cube view editor. Please check the screenshot below and the result -

Result

(OR)

If you want to use the business rule then you have to add the property for l2,l3 and so on. Check below

 

The difference in Excel v/s report is because you have extracted the CubeView in excel directly. Open first in Report and then do an Export -> XLS

 

 

  • Nitishkrish16's avatar
    Nitishkrish16
    New Contributor III
    2 years ago

    Thanks a lot for your response. The Condition needs to be applied in the report/excel headers. But, it's getting applied for all the row/column headers. Please check the below image. Thank you again for your time to get the solution. 

     

     

     

     

    • OS_Pizza's avatar
      OS_Pizza
      Contributor III
      2 years ago

      Revert the changes in the Cube View Header format and use the logic in the business rule ( Check the updated comment ).

      • Nitishkrish16's avatar
        Nitishkrish16
        New Contributor III
        2 years ago

        Thanks a ton!!! This has been solved! Thanks again, good day to you!  🙂 

  • mteich's avatar
    mteich
    New Contributor III
    10 months ago

    Can this same BR be written to apply directly to excel without requiring the report to first be run and then exported to excel? I need this to apply to export of an excel book that does not include that first step.