You can use extended sql functions ij RTF similar to sql programming ex: <?xdofx:Address Line1||Address Line2||Address Line3?>, Thanks

post what exactly your backend data for field the look like and what formula you applied on field? Thanks

The location or directory path where bi publisher repository is located(disk drive where reports and objects of bip ) don't have permissions to your user ,please check with admin.Thanks Also check you have proper access to create reports and data model.

BI publisher version ? Internet explorer version? use different web browser? Thanks

Use google chrome or mozilla firefox.Thanks

upload your documents.Thanks

Please upload xml or output file ,Thanks

follow below links This is know issue, https://blogs.oracle.com/xmlpublisher/entry/no_data_found use <?if@section: not(//ID)?>No Data Found<?end if?> at last page...

use :<?xdoxslt:sysdate("MM/DD/YYYY")?>, Thanks let me know if you have any issues.

Follow below links http://onlytechie.blogspot.com/2013/12/use-mysql-driver-for-bip.html Only Techie: Use MySQL driver for BIP

please clear your requirement ,Thanks

post your main query along with other dependency queries,Thanks

create an extra column in procedure which differentiate approved and incomplete po's and at template level we can filter approved po in 1st page and incomplete in 2nd page based on extra column by filtering at group level. Ex: 1st page <?for-each-group:G_1;./[extra_column='approved value']?> ---------extra column contains…

something wrong with your query.how you defined bind variables in sql query ? please post your query also screen shot LOV related to this parameter.Thanks

Are you logged with administrator user? then only you can able to clear cache ,Thanks

When you are using multiple datasets ,there might be performance impact. did you find any time difference between sql run at database and at data model? try to tune your queries at database level.Thanks how much volume of data does each data set has? Thanks

Once you saved your layout with new updates ,first run in bip environment then re-embed your bip report into dashboard.Thanks

please detail your environment ? bip version ? security ? ,does all users already exist in other source ? etc etc.Thanks

best way is to do at sql query side ,if you can't do ,send me query with sample data. or you can do at template level ,send me rtf and xml,will send you modified one. Follow below link at template level Matrix Report in BI Publisher Thanks http://apps2fusion.com/at/kr/345-matrix-cross-tab-report-bi-publisher

how you created your layout ? its RTF or default layout editor?