Here is my own steps which help me install BIP successfully. I need to install this file, mscomctl.ocx does not exist on my machineĩ13Kb file above, install it. How about I find some log files and go from there.Ĭ:\Users\ShannonM\AppData\Local\Temp has TemplateBuilderInstaller.log – WOW! direct hit.ĭescription: Component ‘MSCOMCTL.OCX’ or one of its dependencies not correctly registered: a file is missing or invalid Crazy trousers, but computers generally do the same thing given the same input. “Try uninstall and install again” – huh? Call me Mr. People are putting all sorts of stuff on forums that look like pot shots. “Template Builder Installer failed”: Unexpected Error” I’m using this machine for some BIP prototype work – cool.
This can also be used if needed.I’m running windows 7 virtual on OVM with office 2010. If you use the xml-tag <?CHECKBOX_IND=1?> in your template, it would return the value true or false. You see that your checkbox is checked or unchecked dependent on your value of xml-tag ‘CHECKBOX_IND’. Note: Value 9746 stands for checked checkbox and value 9744 stands for unchecked checkbox.Īll configuration is done, the final step is to upload our template into BI Publisher and run our report. Edit following setting under RTF-template.Ĭharacters used for checkbox: Arial Unicode MS 9746 9744. Go back to Admin tab and choose ‘Runtime Configuration’ -> Properties. Last step before we upload our template is configure our reports to use this font. Restart your OC4J! Now you can select your font-type. You have first to upload this into directory. Note: If ‘Arial Unicode MS’ –font is not available on the server. Log in to BI Publisher and go to ‘Admin’ tab.Ĭhoose ‘Font Mappings’ by ‘Runtime Configuration’. If everything is done, click in both dialog boxes on ‘OK’.Īt this moment, we have to prepare BI Publisher to understand our checkbox functionality. Second value is the comparising value that has to be met when returning true. First element, CHECKBOX_IND, is xml-tag in your xml-file. Choose ‘Add Help Text’ and specify your condition on this element.Įxtra information about condition: <?CHECKBOX_IND=1?> You can set the default value of the checkbox. You see now the properties of this element. Select your checkbox and right click on the icon. We are almost there, we have to add the BI Publisher functionality to get our checkbox work. The selected form element appears on your page. Click ‘OK’ and you will see a new tab into your Word-page.įollow next step to insert a new form element, in our case a checkbox: There appears a new window where you can set the option for a developer tab.Ĭheck box ‘Show Developer tab in the Ribbon’. Open MS Word 2007 and go to ‘Word Options’ under the Office-logo. To add an form element into our template, we have to do first some steps to get our element. SQL-query: SELECT 1 as checkbox_ind FROM dual Next step is to design a template to add our new functionality and as finishing touch, we upload it to BI Publisher and test it out. First, we have to create a SQL-query to get our value. We will create an checkbox which status is dependent on a value in the xml. This topic will handle about the usage of checkboxes in your RTF-template. Since BI Publisher is integrated with MS Office, you can use some features of Word to add extra functionality into your reports.