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

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!  🙂