Hi
I'm trying to fit the Cube View contents to the width of the page.
When I set "Auto Fit to Page Width" = "True" and "Auto Fit Number of Pages Wide" = "1", it increases the font size until the CV reaches the margins, instead of extending the rows with the line-item descriptions.
Is there a workaround for this?
Regards, Allison
Yes, one can use a Cube View Extender Business Rule. It's not the simplest thing, and it's a bit black magic, but it works.
First, create the Extender
The rule should contain this:
' this first line will already be there, leave it
Case Is = CVExtenderFunctionType.FormatReportUIItem
' the lines below must be added under that line
Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UiItemType = XFReportUIItemType.RowHeaderLabel Or uiItem.UiItemType = XFReportUIItemType.UpperLeftLabel Then
uiItem.width = uiItem.width * 1.5f
End IfBasically we specify the width of the cell, in this case 50% wider (x 1.5) when it's a row header or the top left "empty" corner. That width is technically a Single, so any number you use must end with "f" (awkward, I know). Instead of multiplying, you can add fixed values - for reference, the average header starts around 200 or 300 wide.
Then we attach it to the CV:
Note that extra formatting applied to the cell, like font size etc, can stop it from growing. You can check it in code with "if uiItem.CanGrow = False then", but to be honest I would just start without any formatting option, test the rule does what it should, and only then add extra formatting properties, so you can see quickly what creates problems.
Yes, one can use a Cube View Extender Business Rule. It's not the simplest thing, and it's a bit black magic, but it works.
First, create the Extender
The rule should contain this:
' this first line will already be there, leave it
Case Is = CVExtenderFunctionType.FormatReportUIItem
' the lines below must be added under that line
Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UiItemType = XFReportUIItemType.RowHeaderLabel Or uiItem.UiItemType = XFReportUIItemType.UpperLeftLabel Then
uiItem.width = uiItem.width * 1.5f
End IfBasically we specify the width of the cell, in this case 50% wider (x 1.5) when it's a row header or the top left "empty" corner. That width is technically a Single, so any number you use must end with "f" (awkward, I know). Instead of multiplying, you can add fixed values - for reference, the average header starts around 200 or 300 wide.
Then we attach it to the CV:
Note that extra formatting applied to the cell, like font size etc, can stop it from growing. You can check it in code with "if uiItem.CanGrow = False then", but to be honest I would just start without any formatting option, test the rule does what it should, and only then add extra formatting properties, so you can see quickly what creates problems.
