05-24-2023 02:56 AM - last edited on 05-24-2023 12:23 PM by JackLacava
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 to make the change. But, I see it's getting reflected for only one of the headers in the report. Here, I'm attaching the images for the reference. Any solutions to this are really appreciated. Thanks.
-- This is what I have given in the report header.
-- And this is the output when generating the report. This bold needs to be applied to all the headers given here.
-- This is the output when I'm viewing it in the excel format. No changes are seen here.
-- Cube View Extender Business Rule which I used.
Solved! Go to Solution.
05-24-2023 04:22 AM - edited 05-24-2023 04:44 AM
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
05-24-2023 04:50 AM
Revert the changes in the Cube View Header format and use the logic in the business rule ( Check the updated comment ).
05-24-2023 04:22 AM - edited 05-24-2023 04:44 AM
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
05-24-2023 04:45 AM
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.
05-24-2023 04:50 AM
Revert the changes in the Cube View Header format and use the logic in the business rule ( Check the updated comment ).
05-24-2023 05:02 AM
Thanks a ton!!! This has been solved! Thanks again, good day to you! 🙂
03-06-2024 05:34 PM
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.