Why not do it in the query in the data model? simple and straightforward

on your FTP Administration page ... does it timeout when you click 'Test Connection'?

is the FTP client running on the same machine as BI Publisher? if not, then you have a network/firewall issue between FTP server and BIP server

Client is paying you to solve ... I suggest you dig into the queries behind the reports -- do the queries actually return data?

make sure you have trimmed both columns from leading & trailing spaces AND that you have matching datatypes ...

Don't do a type for type conversion ... PS: Your function, as presented, adds no value (and creates a syntax issue for your SQL) Simply your SQL should be: select ename ,empno,sal from emp where deptno = nvl(: P_MENT, deptno) <-- will return all deptno if var is NULL if you need multi-select departments then: select ename…

select ename ,empno,sal from emp where deptno = nvl(: P_MENT, deptno) <-- will return all deptno if var is NULL AND ( (firstname||' '||lastname)= NVL(: P_fullname,(firstname||' '||lastname)) <-- use a LOV with sql as SELECT (firstname||' '||lastname) fullname FROM emp ORDER BY 1 if you need multi-select departments then:…

Use a lookup value with menu type parameters and set "refresh other parameters on change" to on :dept LOV SQL = SELECT Department from tblDepartments ORDER BY Department <-- refresh other parameters :class LOV SQL = SELECT Class FROM tblClasses WHERE Department = NVL(:dept,Department) ORDER BY Class <-- will show all…

if you have SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable To be able to filter you can do one of the following: 1 - SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable WHERE (date1-date2)/86400000 > : P_Overdue 2 - SELECT EbEOverDue FROM (SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable) WHERE…

Create a unique data value out of patient/conditions then group on that and page break on the group: SMITH01 is different than SMITH10; you should get a page each...

You've started 2 posts with 'Oracle BI' as the subject ... please make your titles a little more meaningful ...

please post your specific URL in full ... maybe you have a switch out of place in it.

Your URL looks ok ... https://helpx.adobe.com/acrobat/kb/pdf-error-1015-11001-update.html

Is your printer configured/enabled to 'talk' on the ipp protocol? is port 631 the port it listens on? what is the actual model of your Epson printer?

Sources of "java.net.ConnectException: Connection refused: connect" * Client and Server, either or both of them are not in the network. <- not likely for you seeing as you can connect * Server is not running <- not likely for you seeing as you can connect * The server is running but not listening on the port, a client is…

Modify your page layout to a larger paper size ...

oi! ... agreed on an SLA before actually knowing what the performance impact is of cross database joins in XML publisher? Further than that: SELECT * ... seriously? In addition to that ... how is your EMP table configured for performance? Partitioned? Indexed? Is this the live transaction table or a replicated table for…

try it in another browser ... could be a browser issue. Not sure of your version of browser - check the certification matrix for your BIP version.

try saving as .... see if you end up with 2 layouts one with a logo and one with out ... might be a permissions issue.

I second @Christian Berg's comments ... the real issue is that you are at the point of implementation when this requirement should never have made it past the wish list. It's an non-vetted requirement leading to an runaway expectation ... your best action (as a consultant) is to get it documented and signed off on as such…