Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Report Builder has more bugs than a sheep dip!
Using hidden parameters to control common font sizes. But for font size 7 is a no go. Font size 7 is available but not via parameter.
So obviously the font is loaded to RB at that smaller size but for some reason does not work when set via parameter!?
=Parameters!FontSize7.Value
In my report font size 8 and 9 are working but tried a smaller font and displays as like 10 point font.
Report Builder - bug using hidden parameter for Font Size 7
Feel free to up vote the Issue (bug) posting above so that m$ can get around to fixing ... like never 😞
Ok I will stop being lazy and do some testing around this issue ... unlike m$ who seem to have trouble testing their own products :}
Line of text. 'test'
Segoe UI = 'shes a no a work'
Arial = 'shes a no a work'
Courier New = 'shes a no a work'
FontWeight does not work either. What **bleep** ... m$ is a load of **bleep**. Thanks for destroying my career you ....
Solved! Go to Solution.
Cheers @bradsy, thanks for the test and reply.
Not sure about product naming but are not 'Power BI Report Builder' and 'Microsoft Report Builder' one and the same!? I gather by 'Power BI Report Builder' you mean 'Power BI Desktop'!? I suppose m$ marketing will add 'paginated' in there sometime to help distinguish between the two :}
I am using 'Power BI Report Builder' (paginated) as stated on the header line of the tool and the updates pop up below.
Testing.
1) being composite textbox, the first Branch line are hardcoded font size values and the second Branch line are hidden parameters
2) header panel testing, first line hard coded and second hidden parameter values
3) body panel testing, first line hard coded and second hidden parameter values
Editor...
Running...
Editor...
'This bag os no a work mate!'
I tripple checked to make sure the default value relate to each parameter and each test field matches the test description ...
Note for the Body panel test I used the same assignements as per the header test. eg =Parameters!ParameterDisplay_FontSize7.Value
All hidden parameters are of Data Type Text which is the default.
Bold testing.
Works but would be nice if wysiwyg worked too. Without wysiwyg it is not worth using hidden parameter as global variable.
Editor...
Run...
Cheers @bradsy, thanks for the test and reply.
Not sure about product naming but are not 'Power BI Report Builder' and 'Microsoft Report Builder' one and the same!? I gather by 'Power BI Report Builder' you mean 'Power BI Desktop'!? I suppose m$ marketing will add 'paginated' in there sometime to help distinguish between the two :}
I am using 'Power BI Report Builder' (paginated) as stated on the header line of the tool and the updates pop up below.
Testing.
1) being composite textbox, the first Branch line are hardcoded font size values and the second Branch line are hidden parameters
2) header panel testing, first line hard coded and second hidden parameter values
3) body panel testing, first line hard coded and second hidden parameter values
Editor...
Running...
Editor...
'This bag os no a work mate!'
I tripple checked to make sure the default value relate to each parameter and each test field matches the test description ...
Note for the Body panel test I used the same assignements as per the header test. eg =Parameters!ParameterDisplay_FontSize7.Value
All hidden parameters are of Data Type Text which is the default.
Hi garythomannCoGC,
The hidden parameter and font size does work. I was able to go down to 1pt size, which even with glasses I could not read.
I set up a hidden parameter called FontSize, text data type, with default value of 7pt. I then set the Font\FontSize "=Parameters!FontSize.Value" on the textbox or tablix cell. This is with Power BI Report Builder, but I this should work in Microsoft Report Builder as well.
@bradsy What font did you use for your testing? I just tried a whole swag again. Textbox properties only shows down to 8pt. But yes you can enter any value down to 1pt but parameter expression only works from 8pt up.
You wouldn't be telling porkies @bradsy would you ... maybe some m$ stock options coming up ... gotta keep the faith till one can make a clean exit ...