BI Publisher 11g - Search/Replace SQL Query Data
We are using BI Publisher 11g link to an Oracle PLM for Process Database (MS SQL Server 2005) via a JDBC connection. Primarily, we use the BI Publisher Desktop Tool with Microsoft Word to create reports, as it is easier for the clients to take over and make modifications.
In the reports we are creating, we have to evaluate whether an element has any data in it before we actually display it, making sure we do not have a cluster of fields with no information in them. So, if it is blank, then skip it. The issue is how the Oracle PLM for Process denotes a blank field.
In the reports we are creating, we have to evaluate whether an element has any data in it before we actually display it, making sure we do not have a cluster of fields with no information in them. So, if it is blank, then skip it. The issue is how the Oracle PLM for Process denotes a blank field.
0