Try handling all complexity at data source level. Keep BIP template just for display purpose only e.g. put IF then else statement in the data source and display the derived value in template.

Please check this link Also please check bit version of the client you are installing.

Hi, To confirm, Unfortunately there is no out of box or in-built way in BIP to attach multiple files in a single email and this a long pending enhancement request with Oracle. However you can code custom java application to solve the problem. First send all separate invoices to a file location using FTP delivery channel…

'All' is equivalent to '*' for BI Publisher parameters.

Best way to do this is to create opaque view in RPD using the XMLP meatadata tables. Create opaque view using those 7-8 tables, you will have to convert BLOB columns into varchar type columns to get the most of the info.

Finally Oracle has excepted this as bug. ER is raised we are waiting for BIP product to be enhanced.

calculate sysdate-1 in your data source it self...get it as a column in datamodel and use it the way you want it.

Another information to share here is that if I follow the steps you just showed, I get the extension .csv even on email attachment but the output ignores report layout and just gives the data dump from xml publisher data model, which is of no use for us.

Thanks for response. It has not resolved the issue though as I mentioned we could correct file in .csv format if we do an ftp of the file however same file if we deliver on email (using BIP bursting) it gets unwanted extension '.txt' in the file.

It could be due to multiple reasons...to troubleshoot... 1. analyze detailed BIP logs, your Admin can provide it to you 2. try doing ftp from the server on which BIP is installed to the target ftp server, if it works it must from BIP schedule report as well 3. Check number of ftp threads in BIP admin page...sometimes when…

Only solution to this is to use xsl-fo template. You can convert your rtf template into xslfo, then manually modify the xml file for xslfo template to customize almost any formatting needs.

Please provide more details on the problem, the screenshot and subject of the issue doesn't seem enough to me.

Nothing that I know. As per my knowledge upload it and run the report.

Column limitation in RTF can be overcome using XSL-FO template. You can convert RTF teamplate into xsl-fo template. However I am not sure if after converting rtf into xsl-fo column split functionality will still be retained. Please try and share the results if it works.