ok while hunting round the interwebz for a way of taking a date and turning it into a sub string a character at a time (don't ask its a finance report thing SHUDDER !) I stumbled across this incredibly cool Oracle document that shows loads of SQL , XSL, and FO elements and functions and how to do them in BI Publisher well cool and extremely Useful thank you Oracle thank you Oracle Techno Pixies :)
extremely cool and useful Linky
I am currently on a project to transfer Optio labels into BI publisher labels. They want to dynamically change the font if an xml field is so many characters. I have researched a lot about this and can't find anything that allows you to change the font based on a substring of characters. Please help.
ReplyDeleteHello there :) thats a good question. i think the easiest way to do this is going to be with a choose statement . are you wanting to change the font if the number of characters is say n characters long go with font 1 other wise go with font 2 or did you want something more like if a field = string 1 use font 1 other wise use font 2 ? let me know and ill put together an example choose statement for you to try in your template
ReplyDeletehave a look at this blog post
ReplyDeleteFriday, 14 March 2014
Using a Case statement in BI Publisher
now then if you apply your different font to the bits that read test 1 test 2 and test 3 just using the font buttons in word you can apply different font styling depending on a field value
I would like to change the font size based on the number of characters are in the string.
ReplyDeleteExample:
If >= 15 use Font size 12
else if < 15 use Font size 16
The reason for this is to make the font bigger when the xml tag string is shorter because it won't wrap to the next line.
This comment has been removed by the author.
ReplyDeleteno problem have a look at the length function here https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481158.htm you can combine that with a choose or if function to get the result you are after
ReplyDelete